Database Backup/Restore with Inherited Tables

From: Dawn Hollingsworth <dmh(at)airdefense(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database Backup/Restore with Inherited Tables
Date: 2003-05-23 03:20:43
Message-ID: 1053660043.1929.47.camel@kaos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Postgres 7.2.3

The application I am working had a database schema utilizing table
inheritance. As the application changes so does our schema and recently
modifications where made to these tables. For existing customers I
generally write an upgrade script to migrate the schema. In this case it
only involved adding a few new columns to the base table.

Customers are provided utilities to backup and restore their database as
they see fit. The problem arose when this migrated database was backed
up and restored. When the base table was altered the new columns were
added to the end of the inherited table automatically( base table
columns, inherited table additional columns, new base table columns).
But if you backup and restore the schema changes to base table, new base
table columns then inherited table additional columns. Unfortunately the
data is in the other order.

I've pulled apart the pg_dump file and I understand what is happening I
would like any suggestions on how to migrate my schema so the
backup/restore will work.

Dawn

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-05-23 06:42:36 Re: [ADMIN] Q: Structured index - which one runs faster?
Previous Message Tom Lane 2003-05-23 00:00:14 Re: Q: Structured index - which one runs faster?