At 09:54 AM 6/15/98 -0700, gary steve shelton wrote:
>i've been so far unsuccessful in my attempts at accessing PostgreSQL from
remote machines, UNIX or Win32 (using ODBC for Win32). I guess it takes a
bit more than editing the pg_hba.conf file, eh?
>
>at one time, long ago and on another RHL5 box, I had it working;
unfortunately, i didn't document the steps it took for me to arrive at
there, and now i'm floundering.
>
>anyone have suggestions?
Hmmm. I edited my pg_hba.conf file and that was all I needed to do. Are you
sure you're adding a user in the Postgres server for whatever username the
remote machine is identifying itself as? (e.g. if user "foobar" on client
machine is accessing database "numnut" on the server, then the server needs
to have a Postgres user (/usr/local/pgsql/bin/createuser) called numnut.
numnut may also need to have permissions granted to him on the database he
is trying to access.
If you're running 6.3.x or higher, postmaster also needs to be started with
the "-i" switch, a change from 6.2.x, to enable TCP/IP or Internet domain
socket communication.
HTH,
Derek
--
PLEASE read the Red Hat FAQ, Tips, Errata and the MAILING LIST ARCHIVES!
http://www.redhat.com/RedHat-FAQ /RedHat-Errata /RedHat-Tips /mailing-lists
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject.
