Re: [PERFORM] backup/restore - another area.

> > Jeff,
> >
> > > The downside is
> > > this method will only work on that specific version of PG and it
> > > isn't the"cleanest" thing in the world since you are essentially
> > > simulating a power failure to PG. Luckly the WAL works like a champ.
> > > Also, these backups can be much larger since it has to include the
> > > indexes as well. but this is a price you have to pay.
> >
> > The other downside is, of course, that the database needs to be shut
> > down.
> >
>
> I left the DB up while doing this.
>
> Even had a program sitting around committing data to try and corrupt
> things. (Which is how I discovered I was doing the snapshot wrong)
>
> You could do pg_ctl stop; snapshot; pg_ctls tart for a "clean" image.
>

Since this seems to work for you,
would you be kind enough to post the shell script for doing the snapshot with
LVM.

Regards
Donald Fraser