Re: Configuring Standby Server in PostgreSQL 9.3.3

Did you guys benchmark the basebackup utility? The master database will have to remain online during this backup/restore process, since it is receiving real time data feeds. Not sure which technique is better for our 7TB db.

1.) Running from the slave. 1.2.3.4 is the ip of master database.

basebackup -D /u01/fiber/postgreSQL_data -F p -x stream -c fast -P -v -h 1.2.3.4 -p 5432 -U replication

2.) compared to ...

psql -c "select pg_start_backup('initial_backup');"

rsync -cva --inplace --exclude=*pg_xlog* /u01/fiber/postgreSQL_data/ postgres(at)1(dot)2(dot)3(dot)4:/u01/fiber/postgreSQL_data/

psql -c " select pg_stop_backup () ;"

3.) or this ...

psql –c “select pg_start_backup(‘hot backup’)”

cp –pr /u01/fiber/postgreSQL_data 1.2.3.4:/u01/fiber/postgreSQL_data

psql –c “select pg_stop_backup(‘hot backup’)”

thanks for the feedback. much appreciated.

-------- Original Message --------

Subject: Re: [BUGS] Configuring Standby Server in PostgreSQL 9.3.3

From: Michele michele(dot)mariani(at)databtech(dot)com

Date: Sun, April 06, 2014 1:59 am

To: fburgess(at)radiantblue(dot)com

hi, we have just configured a primary/secondary server in POostgreSQL 9.3.

I send you our configuration guide.

if u want we create a php application for secondary, primary server management and switch. if u want info write to Sergio Mior: sergio(dot)mior(at)databtech(dot)com(dot)

Kind regards

Il 04/04/2014 16:49, fburgess(at)radiantblue(dot)com ha scritto:

No, Haven't set the server as primary yet. Spent yesterday installing 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.

-------- Original Message --------

Subject: Re: [BUGS] Configuring Standby Server in PostgreSQL 9.3.3

From: chileme88 michele(dot)mariani(at)databtech(dot)com

Date: Thu, April 03, 2014 8:31 am

To: pgsql-bugs(at)postgresql(dot)org

have u already edit postgres.conf on primary?

-----

Michele Mariani

Database Technology s.r.l.

tel: +39 02 89500080

--

View this message in context: http://postgresql.1045698.n5.nabble.com/Configuring-Standby-Server-in-PostgreSQL-9-3-3-tp5798372p5798529.html

Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

--

Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-bugs

--

Questa e-mail è priva di virus e malware perché è attiva la protezione avast! Antivirus .