Skip site navigation (1) Skip section navigation (2)

Re: Backing up a replication set every 30 mins

From: Khusro Jaleel <mailing-lists(at)kerneljack(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up a replication set every 30 mins
Date: 2012-02-15 14:05:26
Message-ID: 4F3BBBA6.1040707@kerneljack.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 02/15/2012 12:58 PM, Vladimir Rusinov wrote:
>
> pg_dump won't block writes, thanks to MVCC. It may increase bloat and it
> will block DDL operations (ALTER TABLE/etc), but if your database is
> relatively small but have high load and you need frequent backups, this
> may be a way to go.
>
> --
> Vladimir Rusinov
> http://greenmice.info/

Thanks Vladimir. Would a simple script with 'pg_start_backup' and 
'pg_stop_backup' and an rsync job or tar job in between would work 
equally well? I thought that was the better way to do it, rather than 
pg_dump?


In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-02-15 14:48:17
Subject: Re: Backing up a replication set every 30 mins
Previous:From: Vladimir RusinovDate: 2012-02-15 12:58:41
Subject: Re: Backing up a replication set every 30 mins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group