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

Re: Data corruption while taking backup of database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pushker Chaubey <pchaubey(at)vertex(dot)co(dot)in>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Data corruption while taking backup of database
Date: 2008-06-25 21:20:04
Message-ID: 23665.1214428804@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Pushker Chaubey <pchaubey(at)vertex(dot)co(dot)in> writes:
> We took back up of a database using the following command
> pg_dump -a

> In the back up file that was generated we found some data that was 
> violating foreign key constraints. And there fore we were not able to 
> restore database back with this back up file.

Was the data actually erroneous, or just loaded in the wrong order
(ie, referencing table before referenced one)?  pg_dump -a doesn't
guarantee to use a safe reload order.

			regards, tom lane

In response to

Responses

pgsql-jdbc by date

Next:From: Pushker ChaubeyDate: 2008-06-26 10:20:19
Subject: Re: Data corruption while taking backup of database
Previous:From: Pushker ChaubeyDate: 2008-06-25 10:08:28
Subject: Re: Data corruption while taking backup of database

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