Re: BUG #2049: pg_dump BACKUP error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Prakash Suryavanshi" <cadet_02prakash(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2049: pg_dump BACKUP error
Date: 2005-11-18 14:39:41
Message-ID: 5861.1132324781@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Prakash Suryavanshi" <cadet_02prakash(at)yahoo(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2005-11-18 14:41:22 Re: BUG #2050: Bad plan by using of LIKE
Previous Message Tom Lane 2005-11-18 14:32:43 Re: BUG #2052: Federal Agency Tech Hub Refuses to Accept Postgresql on Network because of Security Vulnerabilities