Re: Data corruption while taking backup of database

Here is the exact command we use

pg_dump --disable-triggers -v -a -U postgres -p 5432 -h 127.0.0.1 -n
pam=20
-f  <backupfilename>

on the postgres database version 8.1.11

Regards,
Pushker Chaubey

Pushker Chaubey wrote:
> Hi Experts,
>
> We took back up of a database using the following command
> pg_dump -a
> Please note that when we took the back the database was available for=20
> use simultaneously from various clients.
>
> In the back up file that was generated we found some data that was=20
> violating foreign key constraints. And there fore we were not able to=20
> restore database back with this back up file.
>
> What may be the possible reasons?
>
> Also please tell me, is it safe if we allow concurrent modification
of=20
> data through DMLs and the same time take the back up using pg_dump?
>
> Regards
> Pushker
>

=0D
The information contained in this electronic message and any attachments
to=
 this message are intended for the exclusive use of the addressee(s) and
ma=
y contain proprietary, confidential or privileged information. If you are
n=
ot the intended recipient, you should not disseminate, distribute or copy
t=
his e-mail. Please notify the sender immediately and destroy the original
m=
essage all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
shoul=
d check this email and any attachments for the presence of viruses. The
com=
pany accepts no liability for any damage caused by any virus transmitted
by=
 this email.

Please do not print this email unless it is absolutely necessary.
--=20
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc