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


	The Toolkit for Online Communities 15899 Community Members, 0 members online, 2352 visitors today			Log In	Register

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

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

Back to OpenACS Q&A

Icon of Envelope Request notifications

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,

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

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/

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.

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!

Back to OpenACS Q&A