Re: server will not start (Debian)

2019-12-15 Thread Peter J. Holzer
On 2019-12-10 12:03:30 -0500, stan wrote: > OK, here is the latets. If I do sudo systemctl start postgresql@12-main > > the instance starts and works fine. > > However, if I reboot the machine, the instance is not started. Check whether the service is enabled in systemd: # systemctl status post

Re: server will not start (Debian)

2019-12-10 Thread Adrian Klaver
On 12/10/19 9:03 AM, stan wrote: On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote: On 10/12/2019 16:11, Adrian Klaver wrote: On 12/10/19 7:32 AM, stan wrote: On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: Hi Stan Check security make sure V12 postgres?? has the correct

Re: server will not start (Debian)

2019-12-10 Thread Adrian Klaver
On 12/10/19 8:24 AM, stan wrote: On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote: On 10/12/2019 16:11, Adrian Klaver wrote: On 12/10/19 7:32 AM, stan wrote: On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: Hi Stan Check security make sure V12 postgres?? has the correct

Re: server will not start (Debian)

2019-12-10 Thread stan
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote: > On 10/12/2019 16:11, Adrian Klaver wrote: > > On 12/10/19 7:32 AM, stan wrote: > >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: > >>> Hi Stan > >>> > >>> Check security make sure V12 postgres?? has the correct credential

Re: server will not start (Debian)

2019-12-10 Thread stan
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote: > On 10/12/2019 16:11, Adrian Klaver wrote: > > On 12/10/19 7:32 AM, stan wrote: > >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: > >>> Hi Stan > >>> > >>> Check security make sure V12 postgres?? has the correct credential

Re: server will not start (Debian)

2019-12-10 Thread Justin
will the service start from the command line without creating the stats directory??? to my understanding after every shutdown pg_stat_tmp is deleted and recreated during startup starting manually, yet the service will not normally points to a credentials or path issue https://www.postgresql.org/

Re: server will not start (Debian)

2019-12-10 Thread Ray O'Donnell
On 10/12/2019 16:11, Adrian Klaver wrote: > On 12/10/19 7:32 AM, stan wrote: >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: >>> Hi Stan >>> >>> Check security make sure V12 postgresĀ  has the correct credentials >>> >> OK, >> >> postgres@stantest:/var/run/postgresql$ ls -ld >> drwxrw

Re: server will not start (Debian)

2019-12-10 Thread Adrian Klaver
On 12/10/19 7:32 AM, stan wrote: On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: Hi Stan Check security make sure V12 postgres has the correct credentials OK, postgres@stantest:/var/run/postgresql$ ls -ld drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 . Looks correct to me. Th

Re: server will not start (Debian)

2019-12-10 Thread stan
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote: > Hi Stan > > Check security make sure V12 postgres has the correct credentials > OK, postgres@stantest:/var/run/postgresql$ ls -ld drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 . Looks correct to me. This sundirectory 12-main.pg_

Re: server will not start (Debian)

2019-12-10 Thread stan
On Tue, Dec 10, 2019 at 06:48:23AM -0500, stan wrote: > I just went to do soem work on our test/sandbox instance. I had upgraded > this ssytem to V12 a few days agao. I found that it was not running: > > Here is the last thing in the log: > > 2019-12-06 14:16:06.149 EST [3764] LOG: received fast