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
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 |