RE: Postgresql Query

Hi, Merlin,

Thank you for the reply

When files are emptied then it caused the outage for other servers using this server as a administration. The files were emptied because the disk space was keep increasing due so we emptied these files which eventually reduced the disk size however it caused another issues

Below is the directory where the files are emptied

/var/lib/pgsql/data/base

Abhishek

-----Original Message-----
From: Merlin Moncure <mmoncure(at)gmail(dot)com>
Sent: Monday, August 19, 2019 7:09 PM
To: Bansal, Abhishek (Abhishek) <bansal7(at)avaya(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql Query

On Mon, Aug 19, 2019 at 2:15 AM Bansal, Abhishek (Abhishek) <bansal7(at)avaya(dot)com<mailto:bansal7(at)avaya(dot)com>> wrote:

>

> Hello, Team,

>

> Am running into a hard situation where few files are emptied with the below directory of the PostgreSQL.

>

> The files marked as red are emptied which caused server behaving very bad, could you please let us know if there is any way we can retrieve these emptied files?

The data is probably gone. It's possible some of all may still reside in the underlying disks depending how it was deleted and how much disk activity has occurred since the deletion event but the restoration process would be very complex with low chance of recovery.

If the database is allowing queries, Inside of the system catalogs, you can figure out which tables those files are attached to; it looks like two tables were impacted. The number before the period can be matched against pg_class.relfilenode. Once you've identified the tables, you need to restore them from backup and get the database back in shape assuming you can't or don't want to do a full database

restore from backup. What happens so that he files were emptied?

merlin