pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Tables not restored from V7.4 to v8.1.4
3+ messages / 2 participants
[nested] [flat]

* Tables not restored from V7.4 to v8.1.4
@ 2006-07-18 00:50  adey <adey11@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: adey @ 2006-07-18 00:50 UTC (permalink / raw)
  To: pgsql-admin; postgresql-l <postgresql-l@Groups.ittoolbox.com>

We recently backed up our production database (dumpall) on Postgres v7.4 and
restored on v8.1.4. All of the tables restored except three. The tables were
created, but their data wasn't applied. I can see the tables in the dump
file, and no errors were reported in the restore. What am I missing please,
and what should I check next?

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Tables not restored from V7.4 to v8.1.4
@ 2006-07-18 15:21  Aaron Bono <postgresql@aranya.com>
  parent: adey <adey11@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Aaron Bono @ 2006-07-18 15:21 UTC (permalink / raw)
  To: adey <adey11@gmail.com>; +Cc: pgsql-admin; postgresql-l <postgresql-l@groups.ittoolbox.com>

On 7/17/06, adey <adey11@gmail.com> wrote:
>
> We recently backed up our production database (dumpall) on Postgres v7.4and restored on
> v8.1.4. All of the tables restored except three. The tables were created,
> but their data wasn't applied. I can see the tables in the dump file, and no
> errors were reported in the restore. What am I missing please, and what
> should I check next?
>


You say you see the tables in the restore.  Do you see the data in the
restore file as well?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
==================================================================

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Tables not restored from V7.4 to v8.1.4
@ 2006-07-19 07:48  adey <adey11@gmail.com>
  parent: Aaron Bono <postgresql@aranya.com>
  0 siblings, 0 replies; 3+ messages in thread

From: adey @ 2006-07-19 07:48 UTC (permalink / raw)
  To: Aaron Bono <postgresql@aranya.com>; +Cc: pgsql-admin; postgresql-l <postgresql-l@groups.ittoolbox.com>

We found corrupt data today in production that cannot be converted to UTF8.
We are in the process of coorecting the data values. Thanks for your
response.

On 7/19/06, Aaron Bono <postgresql@aranya.com> wrote:
>
> On 7/17/06, adey <adey11@gmail.com> wrote:
> >
> > We recently backed up our production database (dumpall) on Postgres v7.4and restored on
> > v8.1.4. All of the tables restored except three. The tables were
> > created, but their data wasn't applied. I can see the tables in the dump
> > file, and no errors were reported in the restore. What am I missing please,
> > and what should I check next?
> >
>
>
> You say you see the tables in the restore.  Do you see the data in the
> restore file as well?
>
> ==================================================================
>
>    Aaron Bono
>    Aranya Software Technologies, Inc.
>    http://www.aranya.com
> ==================================================================
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-07-19 07:48 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-18 00:50 Tables not restored from V7.4 to v8.1.4 adey <adey11@gmail.com>
2006-07-18 15:21 ` Aaron Bono <postgresql@aranya.com>
2006-07-19 07:48   ` adey <adey11@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox