Re: Backup WAL Replication Server

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: basti <mailinglist(at)unix-solution(dot)de>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backup WAL Replication Server
Date: 2014-03-20 14:19:09
Message-ID: CAB7nPqTR+7MP1Mh2BupsX7GatNq-dPzxQ8cKnH_BXSyh8pxMjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 20, 2014 at 9:48 PM, basti <mailinglist(at)unix-solution(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message basti 2014-03-20 14:37:05 WAL Replication Server + repmgr + Slony
Previous Message José Pedro Santos 2014-03-20 13:35:55 Re: Dump Database