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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: maheshetty20(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15979: PG_VERSION , pg_tblspc got deleted automatically & postgres server creased.
Date: 2019-08-27 07:15:58
Message-ID: 20190827071558.GI7422@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2019-08-27 12:19:44 Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE'
Previous Message Michael Paquier 2019-08-27 04:08:03 Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE'