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

Поиск
Список
Период
Сортировка
От Donald Fraser
Тема Re: [PERFORM] backup/restore - another area.
Дата
Msg-id 001001c39435$dbd82920$1664a8c0@DEMOLITION
обсуждение исходный текст
Ответ на Re: [PERFORM] backup/restore - another area.  (Jeff <threshar@torgo.978.org>)
Ответы Re: [PERFORM] backup/restore - another area.  (Jeff <threshar@torgo.978.org>)
Список pgsql-admin
> > 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: rebuild index question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: rebuild index question