Re: BUG #15979: PG_VERSION , pg_tblspc got deleted automatically &postgres server creased. - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15979: PG_VERSION , pg_tblspc got deleted automatically &postgres server creased.
Date
Msg-id 20190827071558.GI7422@paquier.xyz
Whole thread Raw
In response to BUG #15979: PG_VERSION , pg_tblspc got deleted automatically & postgres server creased.  (PG Bug reporting form <noreply@postgresql.org>)
List 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

Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclaredidentifier 'FD_SETSIZE'
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclaredidentifier 'FD_SETSIZE'