"Prakash Suryavanshi" <cadet_02prakash@yahoo.com> writes:
> system flashes error as follows
> bash-2.05b$ pg_dump chrome2105 > 2nov1505
> pg_dump: ERROR: _mdfd_getrelnfd: cannot open relation ed_accounttype:
> Permission denied
You've apparently started the postmaster as the wrong user, or else
someone's changed the ownership/permissions of the database files
underneath you. Every file within the $PGDATA directory tree ought to
be owned by the user that the postmaster runs as, and readable/writable
only by that user (mode -rw-------, or -rwx------ for directories).
Note that pg 7.2 is horribly ancient --- you should update to something
newer and still-supported as soon as you get that dump made.
regards, tom lane
