Re: Large Database Restore - Mailing list pgsql-general

From Richard Huxton
Subject Re: Large Database Restore
Date
Msg-id 464DC7B5.6050802@archonet.com
Whole thread Raw
In response to Re: Large Database Restore  (Lee Keel <lee.keel@uai.com>)
List pgsql-general
Lee Keel wrote:
> Thanks to everyone for their input on this.  After reading all the emails
> and some of the documentation (section 23.3), I think this is all a little
> more than what I need.  My database is basically read-only and all I was
> looking to do is to be able to take snap-shots of it and be able to restore
> on a developer's machine and not take 30 hours.  So I was thinking I would
> zip the data directories associated to my database, then the developer could
> just copy the zip file and unzip in their own data directory.  My question
> now is: what file would a developer need to change to add this new directory
> to their database list, or will it just automatically show up when they
> refresh the service?

You can't do a file-level backup of one database I'm afraid, only all
databases in one installation.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with inherited tables vs query planning
Next
From: Scott Marlowe
Date:
Subject: Re: Memory settings, vm.overcommit, how to get it really safe?