RE: Postgresql Query - Mailing list pgsql-bugs

From Bansal, Abhishek (Abhishek)
Subject RE: Postgresql Query
Date
Msg-id SN6PR1501MB21606099164A48119367FA91FFA80@SN6PR1501MB2160.namprd15.prod.outlook.com
Whole thread Raw
In response to RE: Postgresql Query  ("Bansal, Abhishek (Abhishek)" <bansal7@avaya.com>)
Responses Re: Postgresql Query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs

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

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #15966: Docs:
Next
From: Tom Lane
Date:
Subject: Re: Postgresql Query