pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Hot backup
8+ messages / 5 participants
[nested] [flat]

* Hot backup
@ 2004-05-26 14:50  Krishna R Palati <krishna@hedgehoghosting.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Krishna R Palati @ 2004-05-26 14:50 UTC (permalink / raw)
  To: pgsql-admin

Hello,

 

I read online that Postgres 7.4.1 has the capability to do hotbackups
(equivalent to Hotbackups on Oracle). But am not able to find any
documentation which will help me set up one. Can you please point me to a
resource that I can use to set up hotbackups for Postgres 7.4.1 ?

 

Thanks,

Krishna Palati.

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

* Re: Hot backup
@ 2004-05-31 09:15  Bruno Wolff III <bruno@wolff.to>
  parent: Krishna R Palati <krishna@hedgehoghosting.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Bruno Wolff III @ 2004-05-31 09:15 UTC (permalink / raw)
  To: Krishna R Palati <krishna@hedgehoghosting.com>; +Cc: pgsql-admin

On Wed, May 26, 2004 at 10:50:21 -0400,
  Krishna R Palati <krishna@hedgehoghosting.com> wrote:
> 
> I read online that Postgres 7.4.1 has the capability to do hotbackups
> (equivalent to Hotbackups on Oracle). But am not able to find any
> documentation which will help me set up one. Can you please point me to a
> resource that I can use to set up hotbackups for Postgres 7.4.1 ?

pg_dump and pg_dumpall provide consistant dumps of the database.



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

* Re: Hot backup
@ 2004-06-01 14:55  Krishna R Palati <krishna@hedgehoghosting.com>
  parent: Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 8+ messages in thread

From: Krishna R Palati @ 2004-06-01 14:55 UTC (permalink / raw)
  To: 'Bruno Wolff III' <bruno@wolff.to>; +Cc: pgsql-admin

Hello,

Thanks for the reply. Pg_dump might provide consistent dump at that point of
time. But my question is:

We can setup pg_dump everyday at 3AM. Suppose a crash occurs at 10PM. Is
there a way in Postgres for us to use the dump file from 3AM and the
transaction logs since then so that we can do a point in time recovery (to
recover everything till 10PM) ? 

With pg_dump as I understand, we can recover only from the dump made at 3AM.
So we will be losing every transaction on the db which is done between
pg_dumps.

Thanks again for your time.
-Krishna.




-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to] 
Sent: Monday, May 31, 2004 5:15 AM
To: Krishna R Palati
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hot backup

On Wed, May 26, 2004 at 10:50:21 -0400,
  Krishna R Palati <krishna@hedgehoghosting.com> wrote:
> 
> I read online that Postgres 7.4.1 has the capability to do hotbackups
> (equivalent to Hotbackups on Oracle). But am not able to find any
> documentation which will help me set up one. Can you please point me to a
> resource that I can use to set up hotbackups for Postgres 7.4.1 ?

pg_dump and pg_dumpall provide consistant dumps of the database.




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

* Re: Hot backup
@ 2004-06-02 18:14  Bruno Wolff III <bruno@wolff.to>
  parent: Krishna R Palati <krishna@hedgehoghosting.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Bruno Wolff III @ 2004-06-02 18:14 UTC (permalink / raw)
  To: Krishna R Palati <krishna@hedgehoghosting.com>; +Cc: pgsql-admin

On Tue, Jun 01, 2004 at 10:55:26 -0400,
  Krishna R Palati <krishna@hedgehoghosting.com> wrote:
> Hello,
> 
> Thanks for the reply. Pg_dump might provide consistent dump at that point of
> time. But my question is:
> 
> We can setup pg_dump everyday at 3AM. Suppose a crash occurs at 10PM. Is
> there a way in Postgres for us to use the dump file from 3AM and the
> transaction logs since then so that we can do a point in time recovery (to
> recover everything till 10PM) ? 

If you are talking about a system crash, you won't lose any committed
transactions and you don't need to reload from a dump at all. Just start
the server back up and it will recover.

If you are talking a head crash (or multiple ones taking out a raid set),
then you can only recover from the last dump, since the data that might
be used to roll forward from a dump will be lost.

If you are talking about going back to before an erroneous transaction ruined
the database, you can't do that now without going back to the last dump
or trying to fix the live version with new transactions. The next version
may have point in time recovery which would allow you to roll forward from
a dump to a particular time. We won't know for about a month if this
feature will make it in. The next version will be released sometime this fall.



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

* Re: Hot backup
@ 2004-06-02 18:17  Krishna R Palati <krishna@hedgehoghosting.com>
  parent: Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 8+ messages in thread

From: Krishna R Palati @ 2004-06-02 18:17 UTC (permalink / raw)
  To: 'Bruno Wolff III' <bruno@wolff.to>; +Cc: pgsql-admin


I was talking about a scenario where we lose the datafiles due to various
issues. Your reply answers my question. Thank you very much for your time. 
I really appreciate that.
-Krishna.

-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to] 
Sent: Wednesday, June 02, 2004 2:14 PM
To: Krishna R Palati
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hot backup

On Tue, Jun 01, 2004 at 10:55:26 -0400,
  Krishna R Palati <krishna@hedgehoghosting.com> wrote:
> Hello,
> 
> Thanks for the reply. Pg_dump might provide consistent dump at that point
of
> time. But my question is:
> 
> We can setup pg_dump everyday at 3AM. Suppose a crash occurs at 10PM. Is
> there a way in Postgres for us to use the dump file from 3AM and the
> transaction logs since then so that we can do a point in time recovery (to
> recover everything till 10PM) ? 

If you are talking about a system crash, you won't lose any committed
transactions and you don't need to reload from a dump at all. Just start
the server back up and it will recover.

If you are talking a head crash (or multiple ones taking out a raid set),
then you can only recover from the last dump, since the data that might
be used to roll forward from a dump will be lost.

If you are talking about going back to before an erroneous transaction
ruined
the database, you can't do that now without going back to the last dump
or trying to fix the live version with new transactions. The next version
may have point in time recovery which would allow you to roll forward from
a dump to a particular time. We won't know for about a month if this
feature will make it in. The next version will be released sometime this
fall.




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

* hot backup
@ 2005-08-03 08:46  Steulet Grégory <Gregory.Steulet@he-arc.ch>
  0 siblings, 1 reply; 8+ messages in thread

From: Steulet Grégory @ 2005-08-03 08:46 UTC (permalink / raw)
  To: pgsql-admin

Hi,
 
I just would like to know if it's possible to dot hot backup(not dump) with postgres. 
 
Thank you
 
Greg
 

 

Grégory Steulet
Assistant HES         

 


HEG Haute école de gestion Arc
Laboratoire de Base de Données
84, rue de la Maladière
CH-2007 Neuchâtel


Tél.
Fax
Internet


+41 32 717 42 22
+41 32 889 60 33 
http://libd.isnetne.ch <http://libd.isnetne.ch/;  

				

 
 

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

* Re: hot backup
@ 2005-08-05 05:25  Jeff Frost <jeff@frostconsultingllc.com>
  parent: Steulet Grégory <Gregory.Steulet@he-arc.ch>
  0 siblings, 0 replies; 8+ messages in thread

From: Jeff Frost @ 2005-08-05 05:25 UTC (permalink / raw)
  To: Steulet Grégory <Gregory.Steulet@he-arc.ch>; +Cc: pgsql-admin

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

---481964751-187987940-1123219547=:4931
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT

On Wed, 3 Aug 2005, Steulet Grégory wrote:

> I just would like to know if it's possible to dot hot backup(not dump) with 
> postgres.

That probably depends what you define as a hot backup. Likely what you are 
looking for is Point in Time Recovery through WAL archiving.  Read about it 
here:

http://www.postgresql.org/docs/8.0/interactive/backup-online.html

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954
---481964751-187987940-1123219547=:4931--



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

* Re: hot backup
@ 2005-08-05 07:44  KÖPFERL Robert <robert.koepferl@sonorys.at>
  0 siblings, 0 replies; 8+ messages in thread

From: KÖPFERL Robert @ 2005-08-05 07:44 UTC (permalink / raw)
  To: pgsql-admin

yes, either by snapshot (Os-feature) or pg_dump

-----Original Message-----
From: Steulet Grégory [mailto:Gregory.Steulet@he-arc.ch]
Sent: Mittwoch, 03. August 2005 10:47
To: pgsql-admin@postgresql.org
Subject: [ADMIN] hot backup


Hi,
 
I just would like to know if it's possible to dot hot backup(not dump) with
postgres. 
 
Thank you
 
Greg
 


 


Grégory Steulet
Assistant HES         

 



HEG Haute école de gestion Arc
Laboratoire de Base de Données
84, rue de la Maladière
CH-2007 Neuchâtel


Tél.
Fax
Internet


+41 32 717 42 22
+41 32 889 60 33 
http://libd.isnetne.ch <http://libd.isnetne.ch/;  

				



 
 

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


end of thread, other threads:[~2005-08-05 07:44 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-26 14:50 Hot backup Krishna R Palati <krishna@hedgehoghosting.com>
2004-05-31 09:15 ` Bruno Wolff III <bruno@wolff.to>
2004-06-01 14:55   ` Krishna R Palati <krishna@hedgehoghosting.com>
2004-06-02 18:14     ` Bruno Wolff III <bruno@wolff.to>
2004-06-02 18:17       ` Krishna R Palati <krishna@hedgehoghosting.com>
2005-08-03 08:46 hot backup Steulet Grégory <Gregory.Steulet@he-arc.ch>
2005-08-05 05:25 ` Re: hot backup Jeff Frost <jeff@frostconsultingllc.com>
2005-08-05 07:44 Re: hot backup KÖPFERL Robert <robert.koepferl@sonorys.at>

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