Re: Configuring Standby Server in PostgreSQL 9.3.3

<span style=3D"font-family:Verdana; color:#000000; font-size:10=
pt;">HI John, all of the backups we have taken were from the 24/7 upti=
me operational production servers. The 4-5 days duration is taken from thes=
e backups. Several months ago we restored one of these backups to another h=
igher capacity database server on fiber channel storage in a different loca=
tion, then we upgraded postgis from 1.5.8 to 2.1.1 and PostgreSQL from 9.1.=
6 to 9.3.3, that restore took 9-10 days to finish. We have another VM that =
has been set aside to be stood up asap as our standby server to this primar=
y. Currently, this standby VM only has Linux 6.4 installed, no PostgreSQL o=
r PostGIS. I was thinking if we can perform a VM clone, we wouldn't have to=
 install PostgreSQL, Postgis, packages, etc., on the standby server.</d=
iv>=0A<blockquote id=3D"replyBlockquote" webm=
ail=3D"1" style=3D"border-left: 2px solid blue; margin-left: 8px; padding-l=
eft: 8px; font-size:10pt; color:black; font-family:verdana;">=0A<div id=3D"=
wmQuoteWrapper">=0A-------- Original Message --------=0ASubject: Re: [B=
UGS] Configuring Standby Server in PostgreSQL 9.3.3=0AFrom: John R Pier=
ce <pierce@hogranch.com><b=
r>=0ADate: Wed, April 02, 2014 1:46 pm=0ATo: <a href=3D"mailto:fburgess=
@radiantblue.com">fburgess@radiantblue.com, <a href=3D"mailto:pgsql-bug=
s@postgresql.org">pgsql-bugs@postgresql.org=0A=0A     <div clas=
s=3D"moz-cite-prefix">On 4/2/2014 11:07 AM, <a target=3D"_blank" class=3D"m=
oz-txt-link-abbreviated" href=3D"mailto:fburgess@radiantblue.com">fburgess@=
radiantblue.com wrote:  <blockquote cite=3D"mid:2014040211074=
9.5a830134ae84016b0174832fdc1a3173.28ee073a59.wbe@email11.secureserver.net"=
 type=3D"cite"><span style=3D"font-family:Verdana; color:#000000; font-size=
:10pt;">We want to do this because our database is 7TB and takes 4-5 to bac=
kup 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.<br=
>  how long does pg_basebackup  take with your system operational?=
  -- =0Ajohn r pierce     =
                                 37N 122W=0Asomewhere on the middle of the =
left coast   =0A=0A