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/docs/current/runtime-config-statistics.html On Tue, Dec 10, 2019 at 10:32 AM stan <st...@panix.com> 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 > > -- > "They that would give up essential liberty for temporary safety deserve > neither liberty nor safety." > -- Benjamin Franklin >