pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
restoring an old database to a new instance -- possible ?
3+ messages / 2 participants
[nested] [flat]

* restoring an old database to a new instance -- possible ?
@ 2005-08-11 09:09 Gregory S. Williamson <gsw@globexplorer.com>
  2005-08-11 14:07 ` Re: restoring an old database to a new instance -- possible ? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Gregory S. Williamson @ 2005-08-11 09:09 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: restoring an old database to a new instance -- possible ?
  2005-08-11 09:09 restoring an old database to a new instance -- possible ? Gregory S. Williamson <gsw@globexplorer.com>
@ 2005-08-11 14:07 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2005-08-11 14:07 UTC (permalink / raw)
  To: Gregory S. Williamson <gsw@globexplorer.com>; +Cc: pgsql-admin

"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> 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 you saved the *whole* $PGDATA directory tree including pg_clog and so
on, then there's nothing at all wrong with the mq_geoloc database.  Just
don't try to connect to gex_runtime.  I'd fire up a postmaster and
pg_dump mq_geoloc, then reload that data into your new installation.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: restoring an old database to a new instance -- possible ?
@ 2005-08-11 20:03 Gregory S. Williamson <gsw@globexplorer.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Gregory S. Williamson @ 2005-08-11 20:03 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Tom --

Thanks for suggestion. We'll give it a try.

Greg W.

-----Original Message-----
From:	Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent:	Thu 8/11/2005 7:07 AM
To:	Gregory S. Williamson
Cc:	pgsql-admin@postgresql.org
Subject:	Re: [ADMIN] restoring an old database to a new instance -- possible ? 
"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> 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 you saved the *whole* $PGDATA directory tree including pg_clog and so
on, then there's nothing at all wrong with the mq_geoloc database.  Just
don't try to connect to gex_runtime.  I'd fire up a postmaster and
pg_dump mq_geoloc, then reload that data into your new installation.

			regards, tom lane

!DSPAM:42fb5baa311789077918311!







^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-08-11 20:03 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-11 09:09 restoring an old database to a new instance -- possible ? Gregory S. Williamson <gsw@globexplorer.com>
2005-08-11 14:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-08-11 20:03 Re: restoring an old database to a new instance -- possible ? Gregory S. Williamson <gsw@globexplorer.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox