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

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.