"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