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
@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
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
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
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
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