Re: BUG #15979: PG_VERSION , pg_tblspc got deleted automatically &postgres server creased.

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #15979: PG_VERSION , pg_tblspc got deleted automatically &postgres server creased.
Дата
Msg-id 20190827071558.GI7422@paquier.xyz
обсуждение исходный текст
Ответ на BUG #15979: PG_VERSION , pg_tblspc got deleted automatically & postgres server creased.  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On Mon, Aug 26, 2019 at 12:33:38PM +0000, PG Bug reporting form wrote:
> -bash-4.1$  /usr/pgsql-9.4/bin/postgres -D /var/lib/pgsql/9.4/data <
> 2019-08-20 00:13:29.353 CDT >FATAL:  "/var/lib/pgsql/9.4/data" is not a
> valid data directory < 2019-08-20 00:13:29.353 CDT >DETAIL:  File
> "/var/lib/pgsql/9.4/data/PG_VERSION" is missing.
> There was missing PG_VERSION  which was created manually
>
> -bash-4.1$ postmaster -D /var/lib/pgsql/9.4/data/ < 2019-08-20 00:27:35.275
> CDT >FATAL:  could not open directory "pg_tblspc": No such file or directory
> -bash-4.1$
> There was missing pg_tblspc  which was created manually

Those first two problems point out that you may have much more
problems than you think, so you should be careful with the way you do
things if you have a corrupted cluster and not employ shortcuts you
think may work.  Here are some guidelines from the wiki:
https://wiki.postgresql.org/wiki/Corruption

This is hard to qualify as a bug by the way, and 9.4.4 is utterly
outdated.  You should consider upgrading to a newer version as well as
9.4 is going to be EOL'd by community in a couple of months.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclaredidentifier 'FD_SETSIZE'
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclaredidentifier 'FD_SETSIZE'