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?
Dear Jim

your application must be having some method of specifying
the datasource , typically hostname,username,password and database name
are asked for .

In case the application is expecting an ODBC datasource you will have
to download pgsqlodbc.

Unless you tell us more details abt what app it is its difficult to
tell
regds
mallah.

>
> Thank you,
> Jim Apsey
> ---------------------------------------------------------------------------------------------------------------> mallah(at)trade-india(dot)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(at)postgresql(dot)org
>>
>>

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/