From: | Gregory Haase <haaseg(at)onefreevoice(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ZFS snapshots - to use pg_start_backup() and pg_stop_backup() or no? |
Date: | 2013-09-11 23:29:48 |
Message-ID: | CAHA6QFTqtEo71puexX9GeYLy6WR7SNHz66LAzatRtkvPvdRGWQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I was trying to figure out how to get the following syntax to work:
echo "select pg_start_backup('zfs_snapshot'); \\! zfs snapshot
zroot/zpgsql(at)test; \\ select pg_stop_backup();" | psql postgres
The above command successfully starts the backup and creates the snapshot
but then fails to stop the backup. I've tried various combinations of \ and
\\ here with different whitespace and I just can't seem to find a
combination that works. I don't understand the proper use of \\ (described
as the separator metacommand).
However, in my research, I noted that a bunch of people seem to just not
even bother with pg_start_backup/pg_stop_backup and I guess aren't that
worried about the crash recovery process if they need to perform a restore.
I also find the omission of the start/stop backup functions from the File
System Level Backup page:
http://www.postgresql.org/docs/9.2/static/backup-file.html
Is the pg_start_backup() and pg_stop_backup() even necessary?
It would be nice to understand the proper syntax for the psql pipe,
regardless whether or not it is even necessary in this case.
Thanks,
Greg Haase
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Schlansker | 2013-09-11 23:46:27 | Re: ZFS snapshots - to use pg_start_backup() and pg_stop_backup() or no? |
Previous Message | David Johnston | 2013-09-11 22:52:37 | Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |