From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | rob stone <floriparob(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: A change in the Debian install |
Date: | 2017-04-06 04:14:44 |
Message-ID: | 1d4a833d-9664-1518-61ee-4ddfd4b22615@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/05/2017 08:03 PM, rob stone wrote:
> Hello,
>
> Postgres is started via pg_ctl and NOT systemd.
> Below are the log entries when version 9.6.2-1 is started.
>
> 2017-04-04 07:15:27 AESTLOG: database system was shut down at 2017-04-
> 03 13:08:27 AEST
> 2017-04-04 07:15:28 AESTLOG: MultiXact member wraparound protections
> are now enabled
> 2017-04-04 07:15:28 AESTLOG: database system is ready to accept
> connections
> 2017-04-04 07:15:28 AESTLOG: autovacuum launcher started
>
>
> Upgraded to version 9.6.2-2 and these are the log entries on start-up:-
What repos are you using, the Debian or the PGDG one?
I guess the question I should really ask is, are you using a repo or
some other method to upgrade?
>
> 2017-04-05 08:03:29 AESTLOG: test message did not get through on
> socket for statistics collector
> 2017-04-05 08:03:29 AESTLOG: disabling statistics collector for lack
> of working socket
> 2017-04-05 08:03:29 AESTWARNING: autovacuum not started because of
> misconfiguration
> 2017-04-05 08:03:29 AESTHINT: Enable the "track_counts" option.
> 2017-04-05 08:03:29 AESTLOG: database system was shut down at 2017-04-
> 04 13:05:46 AEST
> 2017-04-05 08:03:30 AESTLOG: MultiXact member wraparound protections
> are now enabled
> 2017-04-05 08:03:30 AESTLOG: database system is ready to accept
> connections
>
> It is ignoring the PGDATA path and obtaining postgresql.conf from
> /etc/postgresql/9.6/main.
>
> Removed all the Postgres conf files from the /etc path and it is back
> working as intended.
>
>
> Is this just something the Debian package maintainers have done or do
> we have to alter the start-up scripts to specify the config_file
> setting?
>
> The doco says "By default, all three configuration files are stored in
> the database cluster's data directory." which IMHO means where PGDATA
> is pointing.
That is packaging dependent. When using the Debian/Ubuntu
postgresql-common system the postgresql.conf will be in
/etc/postgresql/version/cluster_name/
>
> Has anybody else struck this issue?
>
> Cheers,
> Rob
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Arjen Nienhuis | 2017-04-06 05:35:41 | Re: regexp_matches where clause - PG 9.1 |
Previous Message | Tom Lane | 2017-04-06 04:05:51 | Re: A change in the Debian install |