Re: [ADMIN] Restore database from tablespace

2010-01-29 Thread Greg Spiegelberg
On Thu, Jan 28, 2010 at 4:26 PM, Kevin Grittner wrote: > > I'm still not sure I follow, but there's a technique which isn't > worth much for backup proper, but can be a good way to repeatedly > get to a consistent starting point for tests in some circumstances. > Look at CREATE DATABASE x WITH TEM

Re: [ADMIN] Restore database from tablespace

2010-01-28 Thread Kevin Grittner
Greg Spiegelberg wrote: > I don't know if this was the intent but it did provide me with > what I thought was a good idea. > * Snapshot a schema / tablespace / database to another schema / > tablespace / database. > > The applications for this could be > * an alternative to the existing backu

Re: [ADMIN] Restore database from tablespace

2010-01-28 Thread Greg Spiegelberg
On Thu, Jan 28, 2010 at 9:56 AM, Kevin Grittner wrote: > "dev.pho" wrote: > >> I was wondering if I could restore the database from the location >> of the tablespace. > > It's not clear exactly what you want to do.  Have you read through > the documentation on backup and restore?: I don't know i

Re: [ADMIN] Restore database from tablespace

2010-01-28 Thread Kevin Grittner
"dev.pho" wrote: > I was wondering if I could restore the database from the location > of the tablespace. It's not clear exactly what you want to do. Have you read through the documentation on backup and restore?: http://www.postgresql.org/docs/8.4/interactive/backup.html Perhaps you want