From: | Samuel Stearns <SStearns(at)internode(dot)com(dot)au> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Update pg_type possible problems |
Date: | 2013-05-20 01:32:36 |
Message-ID: | CBAC86BE623FDB4E8B6225471691724291F67CD8@EXCHMBX-ADL6-01.staff.internode.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Howdy,
Environment:
Postgres 8.4.2
Gentoo 2.0.1
Server crash over the weekend. After crash customer noticed table missing and when trying to re-create they got error:
>[Error] Script lines: 20-33 ------------------------
ERROR: type "solar_promotion_query" already exists
Line: 1 _
To resolve they did:
BEGIN;
update pg_type set typname = 'solar_promotion_query_id_seq_old' where typrelid = 5434806;
update pg_type set typname = 'solar_promotion_query_old' where typrelid = 5434808;
COMMIT;
Everything seems to be fine but wondering if the above action could cause any future issues with relations or any other problems?
Thank you,
Samuel Stearns
From | Date | Subject | |
---|---|---|---|
Next Message | Armand du Plessis | 2013-05-20 09:41:30 | Re: Transaction ID wrap limit is log entries |
Previous Message | Amit Langote | 2013-05-20 00:36:48 | Re: Steps to switch from Master to standby mode : |