Re: [GENERAL] A change in the Debian install

2017-04-08 Thread Adrian Klaver
On 04/07/2017 08:56 PM, rob stone wrote: Hello Adrian, On Thu, 2017-04-06 at 21:24 -0700, Adrian Klaver wrote: On 04/06/2017 08:01 PM, rob stone wrote: That is the default location and is generally the case in a source install. Package maintainers can and do often put them elsewhere.

Re: [GENERAL] A change in the Debian install

2017-04-08 Thread Daniel Verite
rob stone wrote: > You create a new cluster by running initdb:- > > initdb -D /path/to/my/new/cluster No, if you want to use the infrastructure brought by the debian packages for your cluster, it should be created with: pg_createcluster 9.5 nameofcluster See

Re: [GENERAL] A change in the Debian install

2017-04-07 Thread rob stone
Hello Adrian, On Thu, 2017-04-06 at 21:24 -0700, Adrian Klaver wrote: > On 04/06/2017 08:01 PM, rob stone wrote: > > > > > > > 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

Re: [GENERAL] A change in the Debian install

2017-04-07 Thread Joshua D. Drake
On 04/05/2017 09:05 PM, Tom Lane wrote: (But ... these statements are based on an assumption of out-of-the- box Postgres behavior. I would not exactly put it past the Debian packagers to have decided to change this for reasons of their own, and their track record of telling us about such

Re: [GENERAL] A change in the Debian install

2017-04-07 Thread Christoph Berg
Re: Magnus Hagander 2017-04-06 > On Thu, Apr 6, 2017 at 3:46 PM, Stephen Frost wrote: > > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > > (But ... these statements are based on an assumption of out-of-the- >

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread Adrian Klaver
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

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread rob stone
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

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread Adrian Klaver
On 04/06/2017 03:16 PM, rob stone wrote: On Wed, 2017-04-05 at 21:14 -0700, Adrian Klaver wrote: 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? Upgraded from standard Debian repos.

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread rob stone
On Wed, 2017-04-05 at 21:14 -0700, Adrian Klaver wrote: > > 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? > > Upgraded from standard Debian repos. Nothing else was changed

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread Magnus Hagander
On Thu, Apr 6, 2017 at 3:46 PM, Stephen Frost wrote: > Tom, > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > (But ... these statements are based on an assumption of out-of-the- > > box Postgres behavior. I would not exactly put it past the Debian > > packagers to have decided

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread Stephen Frost
Tom, * Tom Lane (t...@sss.pgh.pa.us) wrote: > (But ... these statements are based on an assumption of out-of-the- > box Postgres behavior. I would not exactly put it past the Debian > packagers to have decided to change this for reasons of their own, > and their track record of telling us about

Re: [GENERAL] A change in the Debian install

2017-04-06 Thread Karsten Hilbert
On Thu, Apr 06, 2017 at 12:05:51AM -0400, Tom Lane wrote: > rob stone writes: > > Upgraded to version 9.6.2-2 and these are the log entries on start-up:- > > > 2017-04-05 08:03:29 AESTLOG:  test message did not get through on > > socket for statistics collector ... >

Re: [GENERAL] A change in the Debian install

2017-04-05 Thread Adrian Klaver
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

Re: [GENERAL] A change in the Debian install

2017-04-05 Thread Tom Lane
rob stone writes: > Upgraded to version 9.6.2-2 and these are the log entries on start-up:- > 2017-04-05 08:03:29 AESTLOG:  test message did not get through on > socket for statistics collector This is not something that would be affected by any Postgres setting; the stats

[GENERAL] A change in the Debian install

2017-04-05 Thread rob stone
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