restoring an old database to a new instance -- possible ?

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: restoring an old database to a new instance -- possible ?
Date: 2005-08-11 09:09:29
Message-ID: 71E37EF6B7DCC1499CEA0316A2568328024BB760@loki.wc.globexplorer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Using PostSQL 7.4 on a linux server, we have one postgres instance with two databases, "gex_runtime" and "mq_geoloc." We had a mishap in which we ran out of disk space. The failure occured in writing to the gex_runtime database.

Then an unfortunate slip of an admin's keyboard led to the deletion of the gex_runtime data itself under the $PGDATA directory. As far as I can tell the mq_geoloc database files (about 3 gigs worth) were undamaged.

We moved the mq_geoloc files to a safe location, and now have taken a copy of the runtime database from another server and recreated our server as far as the runtime database goes.

My question is whether there is anyway of retrieving the old geoloc database ? Or is my reading of these files total out-of-line with reality ?

If not it's not a crisis -- just a matter of time rebuilding table and reindexing it, but if there's a faster way I'd be willing to try it.

Thanks for your time,

Greg Williamson
DBA
GlobeXplorer LLC

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian FREISLICH 2005-08-11 09:34:05 Schema authorization after create database.
Previous Message Ramesh Patel 2005-08-11 07:33:24 Problem in restore data