Re: server will not start (Debian)

Поиск
Список
Период
Сортировка
От Justin
Тема Re: server will not start (Debian)
Дата
Msg-id CALL-XeNAKUtrNC6UJsiOmvB84SsHxPg=j+7MHSRjPuqmm2L=EQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: server will not start (Debian)  (stan <stanb@panix.com>)
Список pgsql-general
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@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ray O'Donnell
Дата:
Сообщение: Re: server will not start (Debian)
Следующее
От: stan
Дата:
Сообщение: Re: A question about upgrading on Debian/Ubuntu