Re: Tables not restored from V7.4 to v8.1.4

From: adey <adey11(at)gmail(dot)com>
To: "Aaron Bono" <postgresql(at)aranya(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, postgresql-l <postgresql-l(at)groups(dot)ittoolbox(dot)com>
Subject: Re: Tables not restored from V7.4 to v8.1.4
Date: 2006-07-19 07:48:34
Message-ID: 1c66bda80607190048u382b91bw6450b03d25da8156@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)aranya(dot)com> wrote:
>
> On 7/17/06, adey <adey11(at)gmail(dot)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
> ==================================================================
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Merlin Moncure 2006-07-19 14:17:03 Re: [GENERAL] is there any dataware housing tools for postgresql
Previous Message John DeSoi 2006-07-19 05:31:18 Re: is there any dataware housing tools for postgresql