John-
Look here to find out how to turn on TCP/IP access in postgresql.conf:
http://www.postgresql.org/idocs/index.php?runtime-config.html
(look for tcpip_socket
Look here to find out how to authorize access in pg_hba.conf:
http://www.postgresql.org/idocs/index.php?client-authentication.html#PG-HBA.
CONF
Once you've taken care of these two steps, you should be ready to go.
If you have psql installed on the remote machine, you can use the -h option
to test the connection.
-Nick
---------------------------------------------------------------------
Nick Fankhauser
Business:
nickf@doxpop.com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
nick@fankhausers.com http://www.fankhausers.com
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of John Fabiani
> Sent: Wednesday, October 03, 2001 4:22 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] so much to learn
>
>
> Hi,
> I have just installed RH 7.1 server on a 733MHz machine. I also have
> installed postgresql 7.1.3. I can run the examples from the postgres
> interactive tutorial but I can't figure out how to access the data from a
> remote computer. I have a laptop with RH 7.0 (all the network things work
> i.e. telenet,NFS) and want to be able to connect to the server to
> access the
> postgresql. I think I'm missing something or just don't
> understand what I'm
> suppose to do. What I really want to do is get Kylix to access
> the data from
> the laptop. I hoping someone knows how to access the postgres
> server via the
> network or point me to a website.
> TIA
> John
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>