Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Accessing PostgreSQL from Mac-only network

Thank you, Javier Blanque, Edoardo Panfili, Moises Lejter, and others
who made time to respond to me. I appreciate it.

I still have the some problem (I have copied the driver and set the
CLASSPATH accordingly, so Thanks to you, driver issue is no longer).
If, however, anyone can make further suggestions, I would welcome. In
the mean time I will read more as it appears I cannot communicate with
the "server"...

Here is what I checked and ensured they are in place before I restart
PostgreSQL:

1. ensure that the pg_hba.conf file has an entry for the iMac:

host all all xxx.xxx.xxx.xxx 255.255.255.255 trust <==x's
are the IP address of the Mac Cube

2. ensure that in the the postgresql.conf file I have

#tcpip_socket = true <==was "false"

3. start (postmaster) with -i option, to enable TCP/IP connections

4. Make sure I get connected to the Cube from iMac,

5. on the iMac, when connection dialog box appears to "login",
I have substituted "localhost" with the IP address of the Cube (which
also appears as a separate line in the pg_hba.conf:

JTextField("jdbc:postgresql://xxx.xxx.xxx.xxx:5432/
myname?charSet=LATIN1");

where xxx.xxx.xxx.xxx is the IP address of the Mac Cube (server).

I get:

Connection refused. Check that the hostname and port are correct and
that the postmaster is accepting TCP/IP connections.

Again, thanks for all your help.

Oguz
_______________________________________________
java-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/java-dev
Be sure to read the FAQ http://developer.apple.com/java/faq/ before posting
Do not post admin requests to the list. They will be ignored.


Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.