From: CS DBA <cs_dba@consistentstate.com>
To: pgsql-admin@postgresql.org
Cc: cs_dba@consistentstate.com
Subject: odd pg_start_backup() issue
Date: Fri, 31 Jan 2014 10:55:40 -0700
Message-ID: <52EBE39C.4000105@consistentstate.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi All;
I'm setting up PITR based backups on a production db server.
When the script runs the pg_start_backup it takes forever, like 30minutes+
I can run a checkpoint while waiting for it to complete and it finishes
almost immediately
For now we're executing the start backup like this (in the automated
base backup script:
echo "checkpoint; select pg_start_backup('$tag'); checkpoint;" | psql
we tried it like this and id did not help:
echo "checkpoint; select pg_start_backup('$tag');" | psql
so we added the checkpoint after the pg_start_backup command
Next I'll try this (I assume the first checkpoint is simply un-needed):
echo "select pg_start_backup('$tag'); checkpoint;" | psql
However, this works well and the pg_start_backup finishes in less than
1minute,
but if I leave the checkpoint command(s) out then we're back to
30minutes or more for the pg_start_backup...
We're running version 9.2.4 on a Centos 6 server
Thoughts?
Thanks in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cs_dba@consistentstate.com
Subject: Re: odd pg_start_backup() issue
In-Reply-To: <52EBE39C.4000105@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox