Re: Table has 22 million records, but backup doesn't see them

From: Radcon Entec <radconentec(at)yahoo(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table has 22 million records, but backup doesn't see them
Date: 2009-04-08 16:58:08
Message-ID: 715168.81895.qm@web43407.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-04-08 17:04:58 Re: Are there performance advantages in storing bulky field in separate table?
Previous Message John R Pierce 2009-04-08 16:55:53 Re: Now I am back, next thing. Final PGS tuning.