On Wed, 13 Aug 2003, Murthy Kambhampaty wrote:
On Monday, August 11, 2003 17:26, [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 17:26
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Backup routine
In article
On Monday, August 11, 2003 17:26, [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 17:26
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Backup routine
In article [EMAIL PROTECTED],
Bruce Momjian [EMAIL PROTECTED
On Friday 08 August 2003 18:59, Enio Schutt Junior wrote:
Hi
Here, where I work, the backups of the postgresql databases are being done
the following way: There is a daily copy of nearly all the hd (excluding
/tmp, /proc, /dev and so on) in which databases are and besides this there
is also
The world rejoiced as [EMAIL PROTECTED] (Peter and Sarah Childs) wrote:
However there is a third way. That should be safe but some
people may disagree with me! If you can freeze the disk while you
take the backup. The backup can be used as if the computer had
crashed with no hard disk
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 23:13
To: Christopher Browne
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Backup routine
Christopher Browne wrote:
The world rejoiced as [EMAIL PROTECTED] (Peter
and Sarah Childs) wrote
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
Yeah. Instead, exclude the directories below it ($PGDATA/base, etc).
Yes, but if he restores everything but /base, he gets xlog and clog, and
other stuff he shouldn't be restoring.
That's why I said etc. Only the loose files in the
In article [EMAIL PROTECTED],
Bruce Momjian [EMAIL PROTECTED] wrote:
Also, I assume you have to stop the server just for a moment while you
do the freeze, right?
It depends on if you need known state or just consistent state.
Taking a snapshot of the system will get you a consistent state just
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Bruce Momjian) would write:
Christopher Browne wrote:
The world rejoiced as [EMAIL PROTECTED] (Peter and Sarah Childs) wrote:
However there is a third way. That should be safe but some
people may disagree with me! If you can
Oh, good point. By grabbing xlog along with the data files, you do get
a consistent snapshot just like if it had crashed.
---
Mike Castle wrote:
In article [EMAIL PROTECTED],
Bruce Momjian [EMAIL PROTECTED] wrote:
Christopher Browne wrote:
The world rejoiced as [EMAIL PROTECTED] (Peter and Sarah Childs) wrote:
However there is a third way. That should be safe but some
people may disagree with me! If you can freeze the disk while you
take the backup. The backup can be used as if the computer had
Hi Enio,
Enio Schutt Junior wrote:
Hi
Here, where I work, the backups of the postgresql databases are being
done the following way:
There is a daily copy of nearly all the hd (excluding /tmp, /proc,
/dev and so on) in which databases are
and besides this there is also one script which makes
Hi
Here, where I work, the backups of the postgresql
databases are being done the following way:
There is a daily copy of nearly all the hd
(excluding /tmp, /proc, /dev and so on) in which databases are
and besides this there is also one script which makes the pg_dump of each one of the
12 matches
Mail list logo