Re: Backup's from standby - Mailing list pgsql-hackers

From Valentine Gogichashvili
Subject Re: Backup's from standby
Date
Msg-id CAP93muXn2S3+OadSt56_iY+0XKWGyCotazu58ZF=rgF76zTJwg@mail.gmail.com
Whole thread Raw
In response to Re: Backup's from standby  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Backup's from standby
List pgsql-hackers
> > What issue we may face if you take a backups(includes data dir + wal files)
> > at standby without LVM snapshot?
>
> The backup might be corrupted in arbitrary ways.
>

And what will happen, if one issues a pg_start_backup() on the master, then takes a file-backup on slave, and issues pg_stop_backup() on master again? As far as I remember this approach was working for me, considering, that all needed WAL files are transferred to the newly created DB copy as well. 

-- Valentine Gogichashvili

pgsql-hackers by date:

Previous
From: Gokulakannan Somasundaram
Date:
Subject: Re: the big picture for index-only scans
Next
From: Tom Lane
Date:
Subject: Re: "make -j4 world" falls over