On Jun 25, 2012, at 10:34 AM, Eduardo Morras wrote:
>>> Thanks in advance
>> Snapshots are "safe" (but will result in a roll-forward on restart) IF AND
>> ONLY IF the log data and database table spaces are all on the same
>> snapshotted volume.
>>
>> IF THEY ARE NOT then it will probably work
On Mon, Jun 25, 2012 at 4:34 PM, Eduardo Morras wrote:
> At 15:16 25/06/2012, you wrote:
>
>
>> On 6/25/2012 7:35 AM, Eduardo Morras wrote:
>>>
>>>
>>> Hi everyone,
>>>
>>> I'm using FreeBSD 9 for Postgres and want to know if these actions are
>>> safe for make a backup of the database:
>>>
>>> a)
At 15:16 25/06/2012, you wrote:
On 6/25/2012 7:35 AM, Eduardo Morras wrote:
Hi everyone,
I'm using FreeBSD 9 for Postgres and want to know if these actions
are safe for make a backup of the database:
a) call pg_start_backup('b1')
b) take an UFS2 snapshot of data files
c) call pg_stop_back
On 6/25/2012 7:35 AM, Eduardo Morras wrote:
>
> Hi everyone,
>
> I'm using FreeBSD 9 for Postgres and want to know if these actions are
> safe for make a backup of the database:
>
> a) call pg_start_backup('b1')
> b) take an UFS2 snapshot of data files
> c) call pg_stop_backup()
> d) change to th
Hi everyone,
I'm using FreeBSD 9 for Postgres and want to know if these actions
are safe for make a backup of the database:
a) call pg_start_backup('b1')
b) take an UFS2 snapshot of data files
c) call pg_stop_backup()
d) change to the snapshot dir and rsync/dd/dump/transfer it to backup
file
