Re: server will not start (Debian)

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 <stanb(at)panix(dot)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(at)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
>