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@gmail.com>
Cc: pgsql-bugs@lists.postgresql.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@gmail.com>
Sent: Monday, August 19, 2019 8:48 PM
To: Bansal, Abhishek (Abhishek) <bansal7@avaya.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Postgresql Query
On Mon, Aug 19, 2019 at 10:03 AM Bansal, Abhishek (Abhishek) <bansal7@avaya.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