Обсуждение: postgres deployment
Hi,
Can I know the effective solution to do the backup and recovery for Postgres in storage environment.
Please share Any existing deployment and solution for backup and recovery for Postgres in storage
Any suggestion and recommendation are welcome.
Regards
Karthikeyan.N
On Dienstag 10 März 2009 Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery > for Postgres in storage environment. Did you read this? http://www.postgresql.org/docs/8.3/static/warm-standby.html http://www.postgresql.org/docs/8.3/static/pgstandby.html http://scale-out-blog.blogspot.com/2009/02/simple-ha-with-postgresql-point-in-time.html mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
Nice link Michael Monnerie, Can I get any more suggestion from real deployment... Regards Karthikeyan.N -----Original Message----- From: Michael Monnerie [mailto:michael.monnerie@is.it-management.at] Sent: Tuesday, March 10, 2009 12:35 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] postgres deployment On Dienstag 10 März 2009 Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery for > Postgres in storage environment. Did you read this? http://www.postgresql.org/docs/8.3/static/warm-standby.html http://www.postgresql.org/docs/8.3/static/pgstandby.html http://scale-out-blog.blogspot.com/2009/02/simple-ha-with-postgresql-point-in-time.html mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
On Tue, 2009-03-10 at 11:17 +0530, Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery > for Postgres in storage environment. > > Please share Any existing deployment and solution for backup and > recovery for Postgres in storage > > Any suggestion and recommendation are welcome. Postgres has sophisticated techniques for backup and recovery, proven in the field over many years. Please start here http://developer.postgresql.org/pgdocs/postgres/backup.html Integration is possible with 3rd party devices and software. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
Thanks Simon Riggs, I am following the same. Can I get some real time backup solution in production. Regards Karthikeyan.N -----Original Message----- From: Simon Riggs [mailto:simon@2ndQuadrant.com] Sent: Tuesday, March 10, 2009 2:25 PM To: Nagalingam, Karthikeyan Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.org Subject: Re: [GENERAL] postgres deployment On Tue, 2009-03-10 at 11:17 +0530, Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery > for Postgres in storage environment. > > Please share Any existing deployment and solution for backup and > recovery for Postgres in storage > > Any suggestion and recommendation are welcome. Postgres has sophisticated techniques for backup and recovery, proven in the field over many years. Please start here http://developer.postgresql.org/pgdocs/postgres/backup.html Integration is possible with 3rd party devices and software. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
On Tue, Mar 10, 2009 at 2:57 AM, Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com> wrote: > Thanks Simon Riggs, I am following the same. > > Can I get some real time backup solution in production. I'm pretty sure that's what Michael Monnerie posted. Those ARE the strategies used in REAL deployments.