dbTalk Databases Forums  

[BUGS] Backups with pg_dumpall do not restore all data

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] Backups with pg_dumpall do not restore all data in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mike
 
Posts: n/a

Default [BUGS] Backups with pg_dumpall do not restore all data - 04-08-2004 , 03:10 PM






================================================== ==========================
POSTGRESQL BUG REPORT TEMPLATE
================================================== ==========================


Your name : Mike Martin
Your email address : mike (AT) bristolreccc (DOT) co.uk


System Configuration
---------------------
Architecture (example: Intel Pentium) : AMD duron

Operating System (example: Linux 2.4.18) : Linux 2.6.3

PostgreSQL version (example: PostgreSQL-7.4.2): PostgreSQL-7.4.2

Compiler used (example: gcc 2.95.2) : n/a


Please enter a FULL description of your problem:
------------------------------------------------
There appears to be a problem with pg_dumpall.
I maintaain a DB of around 6-7 tables, being a finance and contacts
system.
If I use pg_dumpall, two of the tables are restored without any data.
These are linked together.

Even more curious the data is dumped into the dump file.

If I use pg_dump there is no problem.






---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.