On Wed, 2010-04-28 at 12:44 -0400, Robert Haas wrote: > On Wed, Apr 28, 2010 at 11:25 AM, Heikki Linnakangas > <heikki.linnakan...@enterprisedb.com> wrote: > > Robert Haas wrote: > >> At least as I understand it, even when not using > >> archive_mode, streaming replication, or hot standby, it's still > >> perfectly legal to use pg_start_backup() to take a hot backup. > > > > Nope. The correct procedure to take a hot backup is described in > > http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html#BACKUP-TIPS. > > It involves setting archive_mode=on, and archive_command to a shell > > command that normally just returns true, except when backup is in > > progress. You can't take a hot backup without archiving (or streaming) > > at least temporarily. (except with filesystem-level snapshot capabilities). > > Oh. Well, in that case the proposed change seems reasonable... but > what do you mean by "except with filesystem-level snapshot > capabilities"?
Like LVM, SANS or ZFS. Joshua D. Drake > > ...Robert > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
