Re: [ADMIN] pg_start_backup - backups

2011-04-12 Thread David Roland
Subject: Re: [ADMIN] pg_start_backup - backups David Roland david.rol...@soapware.com wrote: changes to the data folder continue even after the PG_START_BACKUP command has been issued. This implies to me that the contents of any copy of the data folder may be unreliable. i.e. the copy may

Re: [ADMIN] pg_start_backup - backups

2011-04-11 Thread David Roland
@postgresql.org Subject: Re: [ADMIN] pg_start_backup - backups Attempting to run a backup with the database online. I first issue 'PG_START_BACKUP', then copy the contents of the postgresql data folder, then issue 'PG_STOP_BACKUP'. The database service remains running during the copy. If queries

Re: [ADMIN] pg_start_backup - backups

2011-04-11 Thread Kevin Grittner
David Roland david.rol...@soapware.com wrote: changes to the data folder continue even after the PG_START_BACKUP command has been issued. This implies to me that the contents of any copy of the data folder may be unreliable. i.e. the copy may not reflect the state of the data folder either

[ADMIN] pg_start_backup - backups

2011-04-08 Thread droland
Attempting to run a backup with the database online. I first issue 'PG_START_BACKUP', then copy the contents of the postgresql data folder, then issue 'PG_STOP_BACKUP'. The database service remains running during the copy. If queries continue to hit the database after the PG_START_BACKUP command

Re: [ADMIN] pg_start_backup - backups

2011-04-08 Thread Ian Lea
Attempting to run a backup with the database online. I first issue 'PG_START_BACKUP', then copy the contents of the postgresql data folder, then issue 'PG_STOP_BACKUP'. The database service remains running during the copy. If queries continue to hit the database after the PG_START_BACKUP

Re: [ADMIN] pg_start_backup - backups

2011-04-08 Thread Ian Lea
AM To: David Roland Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_start_backup - backups Attempting to run a backup with the database online. I first issue 'PG_START_BACKUP', then copy the contents of the postgresql data folder, then issue 'PG_STOP_BACKUP'. The database service