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
> ==================================================================
>
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 |