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

From: Chris <dmagick(at)gmail(dot)com>
To: Radcon Entec <radconentec(at)yahoo(dot)com>
Cc: 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 22:49:49
Message-ID: 49DD2A0D.2050409@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I still would like to understand why the feedback table cannot be backed
> up by itself.

Because there is no actual data in the feedback table.

It's being stored in the "feedback_active", "feedback_archived_7000" and
your other tables instead.

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bernard Barton 2009-04-08 23:08:02 Is it possible for PostgreSQL to support mmddyyyy date format?
Previous Message Erik Jones 2009-04-08 22:27:11 Re: nooby Q: temp tables good for web apps?