pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres deployment
6+ messages / 4 participants
[nested] [flat]

* postgres deployment
@ 2009-03-10 05:47  Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
  0 siblings, 2 replies; 6+ messages in thread

From: Nagalingam, Karthikeyan @ 2009-03-10 05:47 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-admin

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
 
 

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres deployment
@ 2009-03-10 07:05  Michael Monnerie <michael.monnerie@is.it-management.at>
  parent: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Michael Monnerie @ 2009-03-10 07:05 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres deployment
@ 2009-03-10 07:11  Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
  parent: Michael Monnerie <michael.monnerie@is.it-management.at>
  0 siblings, 0 replies; 6+ messages in thread

From: Nagalingam, Karthikeyan @ 2009-03-10 07:11 UTC (permalink / raw)
  To: Michael Monnerie <michael.monnerie@is.it-management.at>; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [GENERAL] postgres deployment
@ 2009-03-10 08:55  Simon Riggs <simon@2ndQuadrant.com>
  parent: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Simon Riggs @ 2009-03-10 08:55 UTC (permalink / raw)
  To: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>; +Cc: pgsql-general@postgresql.org; 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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [GENERAL] postgres deployment
@ 2009-03-10 08:57  Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
  parent: Simon Riggs <simon@2ndQuadrant.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Nagalingam, Karthikeyan @ 2009-03-10 08:57 UTC (permalink / raw)
  To: Simon Riggs <simon@2ndQuadrant.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [GENERAL] postgres deployment
@ 2009-03-10 09:42  Scott Marlowe <scott.marlowe@gmail.com>
  parent: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Scott Marlowe @ 2009-03-10 09:42 UTC (permalink / raw)
  To: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>; +Cc: Simon Riggs <simon@2ndquadrant.com>; pgsql-general@postgresql.org; pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2009-03-10 09:42 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-10 05:47 postgres deployment Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
2009-03-10 07:05 ` Michael Monnerie <michael.monnerie@is.it-management.at>
2009-03-10 07:11   ` Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
2009-03-10 08:55 ` Simon Riggs <simon@2ndQuadrant.com>
2009-03-10 08:57   ` Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
2009-03-10 09:42     ` Scott Marlowe <scott.marlowe@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox