Re: Backup WAL Replication Server - Mailing list pgsql-general

From Michael Paquier
Subject Re: Backup WAL Replication Server
Date
Msg-id CAB7nPqTR+7MP1Mh2BupsX7GatNq-dPzxQ8cKnH_BXSyh8pxMjg@mail.gmail.com
Whole thread Raw
In response to Backup WAL Replication Server  (basti <mailinglist@unix-solution.de>)
List pgsql-general
On Thu, Mar 20, 2014 at 9:48 PM, basti <mailinglist@unix-solution.de> wrote:
> at the moment we use a Postgres Server as Master and one as Hot-Standby.
> The Database is around 50GB and will massive grow next time.
>
> Backup and Restore with pg_dump take several hours, is there a faster
> way to do this?
Everything is here:
http://www.postgresql.org/docs/devel/static/backup.html
Roughly, taking periodic base backups and maintaining WAL archives is
the way to go.
Regards
--
Michael


pgsql-general by date:

Previous
From: José Pedro Santos
Date:
Subject: Re: Dump Database
Next
From: basti
Date:
Subject: WAL Replication Server + repmgr + Slony