Re: Postgres client/server parameters?

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
>
>
>