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

Backups with pg_dumpall do not restore all data

From: mike <mike(at)bristolreccc(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Backups with pg_dumpall do not restore all data
Date: 2004-04-08 17:26:11
Message-ID: 1081445171.6108.1.camel@datacontrol (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================
 
 
Your name               :       Mike Martin
Your email address      :       mike(at)bristolreccc(dot)co(dot)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.
 
 
 
 


pgsql-bugs by date

Next:From: mikeDate: 2004-04-08 17:42:48
Subject: Backups with pg_dumpall do not restore all data
Previous:From: Pavel StehuleDate: 2004-04-08 15:31:55
Subject: npgsql and czech diacritics again

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