Re: Configuring Standby Server in PostgreSQL 9.3.3

From: John R Pierce <pierce(at)hogranch(dot)com>
To: fburgess(at)radiantblue(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Configuring Standby Server in PostgreSQL 9.3.3
Date: 2014-04-02 20:46:41
Message-ID: 533C7731.3060707@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 4/2/2014 11:07 AM, fburgess(at)radiantblue(dot)com wrote:
> We want to do this because our database is 7TB and takes 4-5 to backup
> and 8-9 days to restore to the standby server.

that might be true for pg_dump/pg_restore type backups, but the initial
copy made for streaming replication is a file system copy/clone.

how long does pg_basebackup take with your system operational?

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message shaharhd 2014-04-02 21:10:18 BUG #9833: daterange is not utilizing index correctly
Previous Message fburgess 2014-04-02 18:07:49 Configuring Standby Server in PostgreSQL 9.3.3