pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTables 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