Forum OpenACS Q&A: How to access postgres-db on other port than 5432

Collapse
1: How to access postgres-db on other port than 5432
Posted by Peter Alberer on 01/07/03 06:51 PM
I would like to test pg-73 with openacs-4.7. The Postgres Server is running on port 6543 as pg-72 is using the default port. Is there any chance to supply the db-port in the config-file?

TIA,

Collapse
2: Re: How to access postgres-db on other port than 5432 (response to 1)
Posted by David Walker on 01/07/03 07:01 PM
In your nsd.tcl use the following style

ns_section "ns/db/pool/postgres_pool"
ns_param  driver          postgres_driver
ns_param  datasource      HOSTNAME:PORT:database_name

Collapse
4: Re: How to access postgres-db on other port than 5432 (response to 2)
Posted by Tilmann Singer on 01/07/03 07:07 PM
Don't know if that still applies but if you need to recompile the postgres driver here's a good guide:

http://pascal.scheffers.net/openacs/pgupdate/

Collapse
3: Re: How to access postgres-db on other port than 5432 (response to 1)
Posted by James Thornton on 01/07/03 07:12 PM
Start postmaster with the -i -p 9876 options, and in your nsd.tcl file, set PG to run on localhost:9876:yourdb, where 9876 is the port you want.
Collapse
5: Re: How to access postgres-db on other port than 5432 (response to 1)
Posted by Peter Alberer on 01/07/03 07:32 PM
Thanks to all! That did it!