RE: Postgresql Query

Sure, thank you Tom,

Abhishek

-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Tuesday, August 20, 2019 12:50 AM
To: Bansal, Abhishek (Abhishek) <bansal7(at)avaya(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql Query

"Bansal, Abhishek (Abhishek)" <bansal7(at)avaya(dot)com> writes:
> 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?

You shouldn't manually mess with *anything* under the data/ directory, except for the documented configuration files (postgresql.conf etc).

Exceptions to this rule are very rare, and you'd better know exactly what you're doing.

regards, tom lane