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. -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin
