Yes you may run postmaster with -i option but its simpler to modify
postgresql.conf file (also known as GUC)
uncomment the line
#tcp_connections=false
and change false to true.
then change pg_hba.conf file to allow access from the client ip address.
that file is exemplified .
if you still face problem revert back
regds
mallah
> Please refer me to a source which explains in some detail how to access a database residing on
> a server. I've already setup the server database and have applications running on the server
> which successfullly use the Postgres database. Now I want/need to access this database from a
> client workstation. Please help me set needed parameters on a host and client in order to
> access pgsql from that client workstation. I think I also need to run postmaster with the
> "-i" parameter and perhaps I need to modify the HOST:$PGDATA/usr/local/pgsql/data/pg_hba.conf
> file. I have been reading:
>
> http://www.ca.postgresql.org/docs/faq-english.html but I still don't know how to do it.
>
> Red Hat gives no support on this simple question. I just need a little help or a suggestion
> or two.
>
> Thank you,
>
> Jim Apsey
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?
>
> http://archives.postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/