Postgres Pro
Downloads
Home   >   mailing lists

Re: Table has 22 million records, but backup doesn't see them - Mailing list pgsql-general

From Radcon Entec
Subject Re: Table has 22 million records, but backup doesn't see them
Date
Msg-id 715168.81895.qm@web43407.mail.sp1.yahoo.com
Whole thread Raw
In response to Re: Table has 22 million records, but backup doesn't see them  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: Table has 22 million records, but backup doesn't see them
List pgsql-general
Tree view
By the way, a full backup and restore using PGAdmin and accepting all default setings worked successfully, including all 22 million feedback records.
 
I still would like to understand why the feedback table cannot be backed up by itself.  The technique of backing up and restoring only selected tables will be frequently useful for many customers, and I would like to know how to get around this problem if it shows up again.
 
RobR
 

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Now I am back, next thing. Final PGS tuning.
Next
From: Steve Crawford
Date:
Subject: Re: Table has 22 million records, but backup doesn't see them