Re: Use of Port 5433 with Postgresql 9.6

2018-01-02 Thread Graeme
Jeff, Andrew, Andreas: Thank you for your replies. Environment is Mageia 6 x86_64. I think the packagers must have set up the 5433 port (although I notice the documentation for pg_ctl contains several examples using 5433). Anyway, I am relieved that 5432 is still regarded as the main port, and

Re: Use of Port 5433 with Postgresql 9.6

2018-01-01 Thread Paul Jungwirth
On 01/01/2018 10:40 AM, Jeff Janes wrote: The Ubuntu packages use 5433 if you already have something (either a different packaged version, or an unpackaged system) running on 5432. Also on Ubuntu lots of the Postgres utilities will obey an envvar like `PGCLUSTER=9.5/main` to let you choose whi

Re: Use of Port 5433 with Postgresql 9.6

2018-01-01 Thread Jeff Janes
On Mon, Jan 1, 2018 at 12:42 PM, Graeme wrote: > If the default port for v9.6 is 5433, why does the utility pg_isready > still default to searching for 5432? The Ubuntu packages use 5433 if you already have something (either a different packaged version, or an unpackaged system) running on 5432

Re: Use of Port 5433 with Postgresql 9.6

2018-01-01 Thread Andreas Kretschmer
On 1 January 2018 18:42:28 CET, Graeme wrote: >If the default port for v9.6 is 5433, why does the utility pg_isready >still default to searching for 5432? The default port for PostgreSQL is 5432. You can use option -p or --port to specify an other Port. You can also set Environment-varibles, pl

Re: Use of Port 5433 with Postgresql 9.6

2018-01-01 Thread Karsten Hilbert
On Mon, Jan 01, 2018 at 05:42:28PM +, Graeme wrote: > If the default port for v9.6 is 5433, It is not. > why does the utility pg_isready still > default to searching for 5432? Which is why. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F