RE: Postgresql Query

Hi, Merlin,

I've last question for this thread, sorry

Inside - /var/lib/pgsql/data/base - so can't we delete or empty any files? How we come to know which files don’t get affected?

Abhishek

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

Ok thank you, Merlin, for your time replying to my questions patiently Have a good one

Abhishek

-----Original Message-----

From: Merlin Moncure <mmoncure(at)gmail(dot)com<mailto:mmoncure(at)gmail(dot)com>>

Sent: Monday, August 19, 2019 8:48 PM

To: Bansal, Abhishek (Abhishek) <bansal7(at)avaya(dot)com<mailto:bansal7(at)avaya(dot)com>>

Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org<mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>

Subject: Re: Postgresql Query

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

>

> Hi, Merlin,

> Thank you for the update

>

> Ok so there seems now no procedure, either complex, to restore the emptied files?

> Would you like me to recommend few courses for PostgreSQL databases that will really help us understanding it better and nevertheless the troubleshooting steps?

As you've described the situation, the data is gone. This is not

really a database problem; you emptied the files by hand. As it

relates to training, it seems like you need some. There are a lot of very good free resources online but you may also want to read a book or two.

merlin