pg_shard icon indicating copy to clipboard operation
pg_shard copied to clipboard

Unable to restore from backup made with pg_dump

Open jasonmp85 opened this issue 10 years ago • 0 comments

Though pg_shard correctly marks its metadata tables so they are included in the output of pg_dump, these dumps are unusable because the relation_id column of pg_shard's metadata tables is of type oid. Because there is no guarantee a given relation will have identical oids, the oids in the metadata tables will not match any relations, rendering the dump unusable.

I found an old thread that insinuates pg_dump will produce a textual representation of tables that works across a restore boundary if the column is of type regclass instead of oid. As far as lower-level code is concerned, these two types are identical (so we will not need to change any implementation). By switching to regclass we can give users the ability to rebuild a master in an identical fashion to restoring a normal PostgreSQL instance from backup.

jasonmp85 avatar Jan 22 '15 23:01 jasonmp85