On Mon, Dec 08, 2025 at 01:20:13PM -0500, Tom Lane wrote:
> Don't do that. Generally speaking, you don't want installed files to
> be writable at all by ordinary user accounts ... but if they are,
> for heaven's sake don't cd into those directories before doing work.
> You're just setting yourself up for trouble.
Yeah, I got a permission error when I tried this:
/usr/local/pgsql/bin$ ./pg_dump -Ft -s -c -v -f postgres schema_clean.tar1
pg_dump: error: could not open TOC file "postgres" for output: Permission denied
So you'd have to either make the binary writable or use "sudo" or something
to get in this situation, which is hopefully uncommon.
--
nathan
