Skip site navigation (1) Skip section navigation (2)

BUG #2049: pg_dump BACKUP error

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Mikael CarneholmDate: 2005-11-17 14:11:13
Subject: Autovacuum deadlock - bug or not?
Previous:From: MattDate: 2005-11-17 08:33:12
Subject: Huge query stalls at PARSE/BIND stage (2)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group