Skip site navigation (1) Skip section navigation (2)

Restoring database from alternative location

From: Marcus Better <marcus(at)better(dot)se>
To: psql-admin(at)postgresql(dot)org
Subject: Restoring database from alternative location
Date: 2005-10-11 18:12:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi all,

I used initlocation to create a database in some directory other than
the default, with Postgresl 7.4. I have a file-system level backup of
this data directory, but the main data directory (which did not contain
any real data) was lost.

Is there a way to restore the database from this backup?

The backed-up directory has the following layout:
  base/17142/{lots of files here}

Can I add this data directory to a fresh Postgresql installation? I
would be very grateful for any comments on this problem!

I am running Postgresql 7.4 on Debian i386.

Please CC replies to me, since I'm not (yet) subscribed to the list.


Marcus B.

pgsql-admin by date

Next:From: Lollar, James RDate: 2005-10-11 22:19:34
Previous:From: Tom LaneDate: 2005-10-11 15:58:06
Subject: Re: Memory/Performance issue: server closed the connection unexpectedly

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group