Thank you Mallah, I think I understand now how to setup the host system
with changes to GUC and pg_hba.conf files. But what do I need to do on
the client side as far as letting application know which database and
where it is located?
Thank you,
Jim Apsey
---------------------------------------------------------------------------------------------------------------
mallah@trade-india.com wrote:
>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/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
