On 12/10/19 9:03 AM, stan wrote:
On Tue, Dec 10, 2019 at 04:13:02PM +0000, 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 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_stat_tmp keeps getting deleted.
If I create it by hand as user psotgres, the DB starts up when I run:
/usr/lib/postgresql/12/bin/postgres -D /var/lib/postgresql/12/main -c
config_file=/etc/postgresql/12/main/postgresql.conf
But tring to start it with /etc/ini.d/postgresql start fails
How did you install Postgres 12?
Why are you using the file in init.d/ instead of pg_ctlcluster?
Or indeed systemctl? :-)
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.
Thoughts as to what to check next, appreciated.
In /etc/postgresql/12/main there is file start.conf with:
# Automatic startup configuration
# auto: automatically start the cluster
# manual: manual startup with pg_ctlcluster/postgresql@.service only
# disabled: refuse to start cluster
# See pg_createcluster(1) for details. When running from systemd,
# invoke 'systemctl daemon-reload' after editing this file.
auto
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
