[GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
I wish to run an instance of PG-9.2 concurrently with our production version (9.1). I have changed the listening port number. listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost' #port = 5432# (change requires restart) port = 5433 However, I am getting

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread Devrim Gündüz
Hi, Is this an RPM installation? If so, you also need to change the port in the init script, too. Regards, Devrim James B. Byrne byrn...@harte-lyne.ca wrote: I wish to run an instance of PG-9.2 concurrently with our production version (9.1). I have changed the listening port number.

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread Adrian Klaver
On 12/14/2012 06:26 AM, James B. Byrne wrote: I wish to run an instance of PG-9.2 concurrently with our production version (9.1). I have changed the listening port number. listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost' #port = 5432# (change

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 09:40, Adrian Klaver wrote: On 12/14/2012 06:26 AM, James B. Byrne wrote: I wish to run an instance of PG-9.2 concurrently with our production version (9.1). I have changed the listening port number. listen_addresses = 'pgsql-dbms.hamilton.harte-lyne.ca, localhost'

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread Birta Levente
On 14/12/2012 16:37, Devrim Gündüz wrote: Hi, Is this an RPM installation? If so, you also need to change the port in the init script, too. Or if it's rhel/centos/sciencific like linux, you can specify in /etc/sysconfig/pgsql/postgresql-9.2: PGPORT=5433 Regards, Devrim James B. Byrne

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread Adrian Klaver
On 12/14/2012 06:48 AM, James B. Byrne wrote: And this is the running instance: service postgresql-9.1 status postgresql-9.1 (pid 1299) is running... So, I am fairly sure that I am trying to get 9.2 started and failing and not trying to start another instance of 9.1. Assuming an RPM

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 09:52, Adrian Klaver wrote: Assuming an RPM install, see Devrims reply. Might one inquire as to why it is necessary to override the configuration file in the startup script? -- *** E-Mail is NOT a SECURE channel *** James B. Byrne

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread Tom Lane
James B. Byrne byrn...@harte-lyne.ca writes: On Fri, December 14, 2012 09:52, Adrian Klaver wrote: Assuming an RPM install, see Devrims reply. Might one inquire as to why it is necessary to override the configuration file in the startup script? There's some background about that here:

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 10:21, James B. Byrne wrote: On Fri, December 14, 2012 09:52, Adrian Klaver wrote: Assuming an RPM install, see Devrims reply. Might one inquire as to why it is necessary to override the configuration file in the startup script? This is a patch for

Re: [GENERAL] Problem starting PG-9.2 on non-default port

2012-12-14 Thread James B. Byrne
On Fri, December 14, 2012 10:21, James B. Byrne wrote: This is a patch for /etc/init.d/postgresql-9.2 to retrieve the port from the postgresql.conf file and override the default setting if it A slight, but important, correction that handles leading white space in the first selection: