From: | "Prakash Suryavanshi" <cadet_02prakash(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2049: pg_dump BACKUP error |
Date: | 2005-11-17 09:33:49 |
Message-ID: | 20051117093349.EBAA4F0BA6@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2049
Logged by: Prakash Suryavanshi
Email address: cadet_02prakash(at)yahoo(dot)com
PostgreSQL version: 7.2
Operating system: Linux
Description: pg_dump BACKUP error
Details:
Respected Sir,
I am working on Linux 9.0 and using postgres 7.2 on it. I am facing
problem while taking backup of database. I am elaborating situation as
follows.
Pg_dump commond used to take a backup of my database the command which I
used is as follows
> pg_dump <Database name> > <target file name>
system flashes error as follows
bash-2.05b$ pg_dump chrome2105 > 2nov1505
pg_dump: ERROR: _mdfd_getrelnfd: cannot open relation ed_accounttype:
Permission denied
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "ed_accounttype" failed:
PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
public.ed_accounttype (accounttypeid, sname, shname, des, active,
systemflag, softdelete, datalocationid) TO stdout;
bash-2.05b$
Can anybody send me solution how to take backup if above error occured..?
This is happening frequently. I had formated the server and again installed
Linux then restore database steel problem persist.
hopping to get early response.
Thanks and regards
Prakash Suryavanshi
iota technologies ltd., Pune
From | Date | Subject | |
---|---|---|---|
Next Message | Mikael Carneholm | 2005-11-17 14:11:13 | Autovacuum deadlock - bug or not? |
Previous Message | Matt | 2005-11-17 08:33:12 | Huge query stalls at PARSE/BIND stage (2) |