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? sudo apt-get install pointed at: deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main > > > > Why are you using the file in init.d/ instead of pg_ctlcluster? > > Or indeed systemctl? :-) I tried that also. did not remeber also: postgres@ica-db:~$ pg_ctlcluster 12 main start Warning: the cluster will not be running as a systemd service. Consider using systemctl: sudo systemctl start postgresql@12-main Cluster is already running. > > Ray. > > -- > Raymond O'Donnell // Galway // Ireland > ray@xxxxxxxxxxxx -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin
