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
On Tue, Dec 10, 2019 at 10:32 AM stan <stanb@xxxxxxxxx> 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
