Home > mailing lists

hot backup with zfs ? - Mailing list pgsql-general

From	Laurent Laborde
Subject	hot backup with zfs ?
Date	August 20, 2015 16:50:32
Msg-id	CAEy3c_QncFypqVoFYWNYJurRCNKLbgxJztCdifvPaZ=SziZvFw@mail.gmail.com Whole thread Raw
Responses	Re: hot backup with zfs ? Re: hot backup with zfs ?
List	pgsql-general

Friendly greetings !

I'm wondering if anyone tried the following hot backup process, and if it works :

pg_start_backup()

zfs snapshop

pg_stop_backup()

copy the snapshot to the backup server.

Thx :)

PS : the WAL will still be archived the usual way.

Laurent "ker2x" Laborde

From: Merlin Moncure
Date: 20 August 2015, 16:43:02
Subject: Re: Preparing statement using PQexec vs PQprepare

From: Yves Dorfsman
Date: 20 August 2015, 17:03:22
Subject: Re: hot backup with zfs ?