Re: Configuring Standby Server in PostgreSQL 9.3.3 - Mailing list pgsql-bugs

From John R Pierce
Subject Re: Configuring Standby Server in PostgreSQL 9.3.3
Date
Msg-id 533C7731.3060707@hogranch.com
Whole thread Raw
In response to Configuring Standby Server in PostgreSQL 9.3.3  (<fburgess@radiantblue.com>)
List pgsql-bugs
On 4/2/2014 11:07 AM, fburgess@radiantblue.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

pgsql-bugs by date:

Previous
From:
Date:
Subject: Configuring Standby Server in PostgreSQL 9.3.3
Next
From: Tom Lane
Date:
Subject: Re: BUG #9518: temporary login failure - "missing pg_hba entry"