in reply to Re^2: Querying Postgres DB on Linux from Windows
in thread Querying Postgres DB on Linux from Windows

i forgot this one, too: cat /etc/redhat-release

name of the server: hostname
or to get its ip address: /sbin/ifconfig
note that 'localhost' (and 127.0.0.1) always points to yourself, so you wouldn't use it to access a remote server (unless you have a ssh tunnel)...

does pg_hba.conf exist anywhere (locate pg_hba.conf)? Refer to the postgres docs on Client Authentication for more information.

Replies are listed 'Best First'.
Re^4: Querying Postgres DB on Linux from Windows
by bkiahg (Pilgrim) on Oct 04, 2005 at 15:17 UTC
    Found it in /usr/local/pgsql/data

    The only two lines not commented out are: 
    trust
local   all   all     ident   sameuser

    [download]
    I think with the information supplied above I can figure it out. Thank you again for your generous help.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom