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

From
Subject Re: Configuring Standby Server in PostgreSQL 9.3.3
Date
Msg-id 20140407152514.5a830134ae84016b0174832fdc1a3173.38bd7c0e22.wbe@email11.secureserver.net
Whole thread Raw
In response to Configuring Standby Server in PostgreSQL 9.3.3  (<fburgess@radiantblue.com>)
Responses Re: Configuring Standby Server in PostgreSQL 9.3.3  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-bugs
<span style=3D"font-family:Verdana; color:#000000; font-size:10=
pt;">Did you guys benchmark the basebackup utility? The master databas=
e will have to remain online during this backup/restore process, since it i=
s receiving real time data feeds. Not sure which technique is better for ou=
r 7TB db.1.) Running from the slave.  1.2.3.4 is the ip of mas=
ter database.basebackup -D /u01/fiber/postgreSQL_data -F p -x strea=
m -c fast -P -v -h 1.2.3.4 -p 5432 -U replication2.) compared to ..=
.psql -c "select pg_start_backup('initial_backup');"rsync -cva =
--inplace --exclude=3D*pg_xlog* /u01/fiber/postgreSQL_data/ postgres@1.2.3.=
4:/u01/fiber/postgreSQL_data/psql -c " select pg_stop_backup () ;"<=
br>3.) or this ...psql =E2=80=93c =E2=80=9Cselect pg_start_backup(=
=E2=80=98hot backup=E2=80=99)=E2=80=9Dcp =E2=80=93pr /u01/fiber/postgre=
SQL_data 1.2.3.4:/u01/fiber/postgreSQL_datapsql =E2=80=93c =E2=80=9Csel=
ect pg_stop_backup(=E2=80=98hot backup=E2=80=99)=E2=80=9Dthanks for=
 the feedback. much appreciated.=0A<blockquote id=3D"repl=
yBlockquote" webmail=3D"1" style=3D"border-left: 2px solid blue; margin-lef=
t: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana=
;">=0A=0A-------- Original Message --------=
=0ASubject: Re: [BUGS] Configuring Standby Server in PostgreSQL 9.3.3=
=0AFrom: Michele <miche=
le.mariani@databtech.com>=0ADate: Sun, April 06, 2014 1:59 am<br=
>=0ATo: fburgess@radiantblue.co=
m=0A=0A     hi, we have just configured a primary/secondary ser=
ver in POostgreSQL 9.3. I send you our configuration guide.  if=
 u want we create a php application for secondary, primary server managemen=
t and switch. if u want info write to Sergio Mior: <a target=3D"_blank" cla=
ss=3D"moz-txt-link-abbreviated" href=3D"mailto:sergio.mior@databtech.com">s=
ergio.mior@databtech.com. Kind regards   <div class=3D=
"moz-cite-prefix">Il 04/04/2014 16:49, <a target=3D"_blank" class=3D"moz-tx=
t-link-abbreviated" href=3D"mailto:fburgess@radiantblue.com">fburgess@radia=
ntblue.com ha scritto:  <blockquote cite=3D"mid:2014040407495=
4.5a830134ae84016b0174832fdc1a3173.85ff9d3a15.wbe@email11.secureserver.net"=
 type=3D"cite"><span style=3D"font-family:Verdana; color:#000000; font-size=
:10pt;"> No, Haven't set the server as primary yet. Spent yesterday in=
stalling PostgreSQL 9.3.3 and PostGIS 2.1.1 on the standby server. Now that=
's done, I think the next step is to run a backup from the yet to be setup =
Primary server.   <blockquote id=3D"replyBlockquote" webmail=
=3D"1" style=3D"border-left: 2px solid blue; margin-left: 8px; padding-left=
: 8px; font-size:10pt; color:black; font-family:verdana;"> <div id=3D"wmQuo=
teWrapper"> -------- Original Message -------- Subject: Re: [BUGS] Conf=
iguring Standby Server in PostgreSQL 9.3.3 From: chileme88 <<a targe=
t=3D"_blank" moz-do-not-send=3D"true" href=3D"mailto:michele.mariani@databt=
ech.com">michele.mariani@databtech.com> Date: Thu, April 03, 201=
4 8:31 am To: <a target=3D"_blank" moz-do-not-send=3D"true" href=3D"mai=
lto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org  have =
u already edit postgres.conf on primary?    ----- Miche=
le Mariani Database & Technology s.r.l.  tel: +39 02 89500080<b=
r> -- View this message in context: <a target=3D"_blank" moz-do-not-sen=
d=3D"true" href=3D"http://postgresql.1045698.n5.nabble.com/Configuring-Stan=
dby-Server-in-PostgreSQL-9-3-3-tp5798372p5798529.html">http://postgresql.10=
45698.n5.nabble.com/Configuring-Standby-Server-in-PostgreSQL-9-3-3-tp579837=
2p5798529.html Sent from the PostgreSQL - bugs mailing list archive=
 at <a target=3D"_blank" moz-do-not-send=3D"true" href=3D"http://Nabble.com=
">Nabble.com.   --  Sent via pgsql-bugs mailing list (<=
a target=3D"_blank" moz-do-not-send=3D"true" href=3D"mailto:pgsql-bugs@post=
gresql.org">pgsql-bugs@postgresql.org) To make changes to your subs=
cription: <a target=3D"_blank" moz-do-not-send=3D"true" href=3D"http://=
www.postgresql.org/mailpref/pgsql-bugs">http://www.postgresql.org/mailpref/=
pgsql-bugs      <div cla=
ss=3D"moz-signature">--  <img   src=3D"cid:part7.04050605.04010306@data=
btech.com" wbeuser=3D"fburgess@radiantblue.com" border=3D"0"> <br=
> <hr style=3D"border:none; color:#909090; background-color:#B0B0B0; height=
: 1px; width: 99%;"> <table style=3D"border-collapse:collapse;border:none;"=
>   <a target=
=3D"_blank" href=3D"http://www.avast.com/"> <img   src=3D"http://static.ava=
st.com/emails/avast-mail-stamp.png" border=3D"0">    <div styl=
e=3D"color:#3d4d5a; font-family:"Calibri","Verdana",&qu=
ot;Arial","Helvetica"; font-size:12pt;"> Questa e-mail =C3=
=A8 priva di virus e malware perch=C3=A9 =C3=A8 attiva la protezione <a tar=
get=3D"_blank" href=3D"http://www.avast.com/">avast! Antivirus . =
       =0A=0A</body=
>

pgsql-bugs by date:

Previous
From: Vik Fearing
Date:
Subject: Re: BUG #9896: Bug in FULL OUTER JOIN
Next
From: Michael Paquier
Date:
Subject: Re: BUG #9895: Duplicate pkey