Re: BUG #8721: pg_wrapper unaware of configuration includes

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8721: pg_wrapper unaware of configuration includes
Date: 2014-01-04 04:26:59
Message-ID: 1388809619331-5785294.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jodynickel wrote
> The following bug has been logged on the website:
>
> Bug reference: 8721
> Logged by: Jody Nickel
> Email address:

> jodynickel@

> PostgreSQL version: 9.3.2
> Operating system: Kubuntu 13.04
> Description:
>
> I installed postgres 9.3 on a machine where 9.1 was installed. I
> dumped/loaded the 9.1 databases into 9.3. I then stopped and uninstalled
> 9.1.
>
>
> When I installed, since there was already a postgres installed, the port
> was
> assigned to 5433.
>
>
> I then used a secondary configuration file to hold my configuration
> changes
> for postgres (shared memory etc) and used the include statement in
> postgresql.conf. One of the lines in that secondary file was port = 5432.
>
>
> I then restarted postgres to put the changes into effect.
>
>
> When I started psql, it gave an error that it couldn't connect to port
> 5433.
>
>
> I think it was reading postgresql.conf, and ignoring the included files
> that
> had changed the port number.
>
>
> This is a very minor bug, and was easily worked around by changing the
> port
> configuration in the postgresql.conf file.

This is not a PostgreSQL bug, nor is it likely a distro bug. Most likely
because you are making changes to default configurations you have to learn
where those defaults are stored for pg_wrapper and make the appropriate
change there. I doubt it reads PostgreSQL.conf but instead stores 5433
somewhere upon install and you need to change that.

Google and "man" are your friends.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8721-pg-wrapper-unaware-of-configuration-includes-tp5785254p5785294.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Johnston 2014-01-04 04:31:13 Re: BUG #8721: pg_wrapper unaware of configuration includes
Previous Message David Johnston 2014-01-03 21:25:49 Re: BUG #8718: serial datatype creates a sequence with bigserial limits