| From: | Mikael Kjellström <mikael(dot)kjellstrom(at)mksoft(dot)nu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Corrupt view in PostgreSQL 9.0.9 |
| Date: | 2012-09-28 17:50:04 |
| Message-ID: | 5065E34C.7030109@mksoft.nu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2012-09-28 19:39, Tom Lane wrote:
> =?ISO-8859-1?Q?Mikael_Kjellstr=F6m?= <mikael(dot)kjellstrom(at)mksoft(dot)nu> writes:
>> Your recomendation is to restore the backup to a new database and drop
>> the old one, right?
>
> Right. If you've got more than one active database in this
> installation, it might be prudent to dump and restore the whole thing
> --- but in any case, you don't want to trust this database's
> pg_attribute anymore.
Ok. I've done just that. I dumped the database, dropped it and then
created it and restored the backup. All the data seems to be there also
at a first glance.
I also took the oppertunity to compile and upgrade to 9.0.10 when I had
the chance.
Thanks for all the help.
/Mikael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mr.dash.four | 2012-09-28 22:08:30 | BUG #7575: "between" does not work properly with inet/cidr addresses |
| Previous Message | Tom Lane | 2012-09-28 17:39:38 | Re: Corrupt view in PostgreSQL 9.0.9 |