Re: A change in the Debian install

On 04/06/2017 08:01 PM, rob stone wrote:
>
>
> On Thu, 2017-04-06 at 15:58 -0700, Adrian Klaver wrote:
>> On 04/06/2017 03:16 PM, rob stone wrote:
>>>
>>>
>>
>> Which is what has me confused. If you are using the postgresql-
>> common
>> system then the *.conf files should be in
>> /etc/postgresql/version/cluster_name/.
>>
>> Where exactly is PGDATA and why is the *.conf file there?
>>
>
> It's always been in the PGDATA path and it has always worked.
> The doco implies that PGDATA is the place for the *.conf files unless
> overridden by the config_file parameter.

That is the default location and is generally the case in a source
install. Package maintainers can and do often put them elsewhere. AFAIK
the Debian/Ubuntu way using postgresql-common is to put them in
/etc/postgresql/version/cluster_name/. So on one of my Ubuntu 16.04
installs with Postgres 9.6.2:

aklaver(at)arkansas:~$ l /etc/postgresql/9.6/main/
total 56
drwxr-xr-x 2 postgres postgres 4096 Feb 11 16:23 ./
drwxr-xr-x 3 postgres postgres 4096 Feb 11 07:15 ../
-rw-r--r-- 1 postgres postgres 315 Feb 11 07:15 environment
-rw-r--r-- 1 postgres postgres 143 Feb 11 07:15 pg_ctl.conf
-rw-r----- 1 postgres postgres 4642 Feb 11 16:23 pg_hba.conf
-rw-r----- 1 postgres postgres 1636 Feb 11 07:15 pg_ident.conf
-rw-r--r-- 1 postgres postgres 22438 Feb 11 16:11 postgresql.conf
-rw-r--r-- 1 postgres postgres 317 Feb 11 07:15 start.conf

and PGDATA:

aklaver(at)arkansas:~$ sudo ls -al /var/lib/postgresql/9.6/main/
total 92
drwx------ 19 postgres postgres 4096 Apr 6 15:54 .
drwxr-xr-x 3 postgres postgres 4096 Feb 11 07:15 ..
drwx------ 6 postgres postgres 4096 Feb 11 16:06 base
drwx------ 2 postgres postgres 4096 Mar 22 12:22 global
drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_clog
drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_commit_ts
drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_dynshmem
drwx------ 4 postgres postgres 4096 Feb 11 07:15 pg_logical
drwx------ 4 postgres postgres 4096 Feb 11 07:15 pg_multixact

drwx------ 2 postgres postgres 4096 Mar 22 12:21 pg_notify

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_replslot

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_serial

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_snapshots

drwx------ 2 postgres postgres 4096 Mar 22 12:21 pg_stat

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_stat_tmp

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_subtrans

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_tblspc

drwx------ 2 postgres postgres 4096 Feb 11 07:15 pg_twophase

-rw------- 1 postgres postgres 4 Feb 11 07:15 PG_VERSION

drwx------ 3 postgres postgres 4096 Feb 11 07:15 pg_xlog

-rw------- 1 postgres postgres 88 Feb 11 07:15 postgresql.auto.conf

-rw------- 1 postgres postgres 133 Mar 22 12:21 postmaster.opts

-rw------- 1 postgres postgres 100 Mar 22 12:21 postmaster.pid

This is why I am trying to figure out if you are using the Debian packaging:

A) What is your PGDATA?

B) How postgresql.conf got there?

The reason it is important is that the next update will probably land
you back in the same situation that started this thread, unless we
figure out what is going on.

Another question:

Have you ever installed Postgres on this machine using something other
then the Debian packages?

>
> Cheers,
> Rob
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com