Re: Postgresql Query

On Mon, Aug 19, 2019 at 2:15 AM Bansal, Abhishek (Abhishek)
<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