Thread: postgres deployment

postgres deployment

From
"Nagalingam, Karthikeyan"
Date:
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
 
 

Re: postgres deployment

From
Simon Riggs
Date:
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


Re: postgres deployment

From
"Nagalingam, Karthikeyan"
Date:
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


Re: [ADMIN] postgres deployment

From
Scott Marlowe
Date:
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.