On Thu, May 1, 2014 at 12:39:44PM -0700, bricklen wrote: > > On Thu, May 1, 2014 at 8:54 AM, Shaun Thomas <stho...@optionshouse.com> wrote: > > On 05/01/2014 10:31 AM, Edson Richter wrote: > > > I'm wondering if would be possible to execute these backups in the > slave > server instead, so I can avoid the overhead of backups on master > system? > > > If you're on PostgreSQL 9.3, you can backup the slave server safely. If > not, you'll need to run this command on the master system first: > > SELECT pg_start_backup('some-label'); > > After the backup is done, run this on the master server: > > SELECT pg_stop_backup(); > > > Or alternatively, if "backup" = pg_dump, then backups can taken from the slave > too. Have a look at pg_xlog_replay_pause() + pg_dump + > pg_xlog_replay_resume(). > http://www.postgresql.org/docs/current/static/functions-admin.html# > FUNCTIONS-RECOVERY-CONTROL-TABLE
Uh, what is the pause for? So the transaction will not be cancelled? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general