Hi Simon,
Actually, me too. Never saw the need for the Oracle command myself.
It actually has. If you want to move your redo logs to a new disk, you
create a new redo log file and then issue a ALTER SYSTEM SWITCH LOGFILE;
to switch to the new logfile. Then you can remove the old one
(speaking just
It is also recommended when creating new standby control files, when
Oracle can't
automatically expand the data file capacity on a standby like it does
with
a live database. Nothing like seeing the 'Didn't restore from
sufficiently old
backup' message when Oracle is confused (which seems
On Wed, 2005-04-20 at 09:28 +0200, Klaus Naumann wrote:
Actually, me too. Never saw the need for the Oracle command myself.
It actually has. If you want to move your redo logs to a new disk, you
create a new redo log file and then issue a ALTER SYSTEM SWITCH LOGFILE;
to switch to the new
On Mon, 2005-04-18 at 21:25 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
The wal file could be truncated after the log switch record, though I'd
want to make sure that didn't cause other problems.
Which it would: that would break WAL file
On Tue, 2005-04-19 at 08:55 +0400, Oleg Bartunov wrote:
On Mon, 18 Apr 2005, Simon Riggs wrote:
but I'm not sure it's best practice to delete them at that point. I
would recommend that users keep at least the last 3 backups. So, I'd
prefer the wording
...all archived WAL segments with
On Tue, 19 Apr 2005, Simon Riggs wrote:
On Tue, 2005-04-19 at 08:55 +0400, Oleg Bartunov wrote:
On Mon, 18 Apr 2005, Simon Riggs wrote:
but I'm not sure it's best practice to delete them at that point. I
would recommend that users keep at least the last 3 backups. So, I'd
prefer the wording
...all
Simon Riggs wrote:
On Mon, 2005-04-18 at 21:25 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
The wal file could be truncated after the log switch record, though I'd
want to make sure that didn't cause other problems.
Which it would: that
Bruce Momjian pgman@candle.pha.pa.us writes:
I was thinking of the archiver filling because of lots of almost-empty
16mb files. If you archive every five seconds, it is 11 Gigs/hour,
which is not too bad, I guess, but I would bet compression would save
space and I/O load too.
If you wanted
On Tue, Apr 19, 2005 at 11:05:32AM -0400, Bruce Momjian wrote:
Simon Riggs wrote:
The disk would only fill if the archiver doesn't keep up with
transmitting xlog files to the archive. The archive can fill up if it is
not correctly sized, even now. Switching log files every N seconds would
Alvaro Herrera wrote:
On Tue, Apr 19, 2005 at 11:05:32AM -0400, Bruce Momjian wrote:
Simon Riggs wrote:
The disk would only fill if the archiver doesn't keep up with
transmitting xlog files to the archive. The archive can fill up if it is
not correctly sized, even now. Switching log
On Tue, 2005-04-19 at 15:23 +0400, Oleg Bartunov wrote:
This is not an argument ! It's shame we still don't understand do we really
have reliable online backup or just hype with a lot of restriction and
caution. I'm not experienced Oracle DBA but I don't want to be a blind user.
I read
Jeff Davis wrote:
Unless I misunderstand something, I think you're overreacting a bit. The
failure case is that the machine on which the database resides vaporizes
after you've done pg_stop_backup() but before the archiver archives
the WAL segments used during the backup procedure.
In
On Tue, 19 Apr 2005, Jeff Davis wrote:
Unless I misunderstand something, I think you're overreacting a bit. The
Y're right. It's all emotions :)
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
On Mon, 2005-04-18 at 00:20 -0400, Bruce Momjian wrote:
Jeff Davis wrote:
Can you sort of run through the failure case again, and how to prevent
it?
The failure case in the original docs is that you do your
pg_stop_backup(), and then delete all the WAL file before the *.backup
file
On Mon, 18 Apr 2005, Bruce Momjian wrote:
Jeff Davis wrote:
I could still use a little clarification. It seems sort of like there is
an extra step, like:
(1) start archiving
(2) pg_start_backup()
(3) copy PGDATA directory with tar
(4) pg_stop_backup()
(5) ??
And the text you have at
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't understand what's the problem to
generate WAL file
by demand ? Probably, TODO should says about this.
This would definetly be a good
Jeff Davis wrote:
On Mon, 2005-04-18 at 00:20 -0400, Bruce Momjian wrote:
Jeff Davis wrote:
Can you sort of run through the failure case again, and how to prevent
it?
The failure case in the original docs is that you do your
pg_stop_backup(), and then delete all the WAL file
On Mon, 18 Apr 2005, Rob Butler wrote:
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't understand what's the problem to
generate WAL file
by demand ? Probably, TODO should says about this.
This
Oleg Bartunov wrote:
Is there something in the current wording that needs clarification?
I'd say it's very not cool :) It's not we all expected from PITR.
I recall now Simon mentioned about that and have it in his TODO.
Other thing I don't understand what's the problem to generate WAL file
Rob Butler [EMAIL PROTECTED] wrote on 18.04.2005, 15:05:20:
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't understand what's the problem to
generate WAL file
by demand ?
Bruce Momjian pgman@candle.pha.pa.us writes:
I see your point. New text is:
4 Again connect to the database as a superuser, and issue the command
SELECT pg_stop_backup();
This should return successfully.
5 Once the WAL segment
OK, I updated the two current TODO items:
* Allow point-in-time recovery to archive partially filled write-ahead
logs
Currently only full WAL files are archived. This means that the most
recent transactions aren't available for recovery in
Oleg Bartunov wrote:
On Mon, 18 Apr 2005, Rob Butler wrote:
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't understand what's the problem to
generate WAL file
by demand ?
Greg Stark wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I see your point. New text is:
4 Again connect to the database as a superuser, and issue the command
SELECT pg_stop_backup();
This should return successfully.
5 Once
Bruce Momjian pgman@candle.pha.pa.us writes:
You mean don't force the archive copy but just have pg_stop_backup()
hang until the files fill? Yea, we could do that, but there is no way
to know how long the hang might take.
Actually I meant both.
--
greg
---(end of
Bruce Momjian pgman@candle.pha.pa.us writes:
Ragnar Hafstað wrote:
On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
I am not clear on what the backup dump file is? I assume it means
0001123455CD. It is called WAL segment file above. I
will rename that phrase to match the
Bruce Momjian pgman@candle.pha.pa.us writes:
OK, I updated the two current TODO items:
* Automatically force archiving of partially-filled WAL files when
pg_stop_backup() is called or the server is stopped
Is this OK?
Archive on stop is right out. The common reason for a stop
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
OK, I updated the two current TODO items:
* Automatically force archiving of partially-filled WAL files when
pg_stop_backup() is called or the server is stopped
Is this OK?
Archive on stop is right out. The
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Ragnar Hafstað wrote:
On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
I am not clear on what the backup dump file is? I assume it means
0001123455CD. It is called WAL segment file above. I
will rename
Bruce Momjian pgman@candle.pha.pa.us writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
system badckup to do the recovery. Do you have new suggested text?
I think it probably needs to mention
Bruce Momjian pgman@candle.pha.pa.us writes:
Tom Lane wrote:
Archive on stop is right out. The common reason for a stop is that the
system is being shut down, and we don't have time to archive a WAL file
before init will kill -9 us.
Ah, good point. Can we do it for 'smart' shutdown mode,
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
system badckup to do the recovery. Do you have new suggested text?
I think it
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Tom Lane wrote:
Archive on stop is right out. The common reason for a stop is that the
system is being shut down, and we don't have time to archive a WAL file
before init will kill -9 us.
Ah, good point. Can we do it for
On Mon, 2005-04-18 at 16:44 +0200, [EMAIL PROTECTED] wrote:
Rob Butler [EMAIL PROTECTED] wrote on 18.04.2005, 15:05:20:
I'd say it's very not cool :) It's not we all
expected from PITR.
I recall now Simon mentioned about that and have it
in his TODO.
Other thing I don't
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
system badckup to do the
Simon Riggs [EMAIL PROTECTED] writes:
The wal file could be truncated after the log switch record, though I'd
want to make sure that didn't cause other problems.
Which it would: that would break WAL file recycling.
That would be initiated through a single function pg_walfile_switch()
which
On Mon, 2005-04-18 at 19:21 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
The wal file could be truncated after the log switch record, though I'd
want to make sure that didn't cause other problems.
Which it would: that would break WAL file recycling.
Yeh, there's just too
Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
The wal file could be truncated after the log switch record, though I'd
want to make sure that didn't cause other problems.
Which it would: that would break WAL file recycling.
Good point. I don't see non-full WAL archiving as a
Simon Riggs wrote:
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the file
On Mon, 18 Apr 2005, Simon Riggs wrote:
On Mon, 2005-04-18 at 13:41 -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
I guess I didn't see the connection between the file system backup and
the WAL files, when in fact you need the WAL files that go with the
On Tue, 19 Apr 2005, Simon Riggs wrote:
I'd suggest this as a backpatch for 8.0.x, when completed.
Not a chance --- it's a new feature, not a bug fix, and has substantial
risk of breaking things.
No problem for me personally; I only request it, according to users
wishes.
Users wish deterministic
On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
[about backup procedure with PITR documentation
I see in the docs:
To make use of this backup, you will need to keep around all the WAL
segment files generated at or after the starting time of the backup. To
aid you
Ragnar Hafstað wrote:
On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote:
[about backup procedure with PITR documentation
I see in the docs:
To make use of this backup, you will need to keep around all the WAL
segment files generated at or after the starting time of the
Bruce Momjian wrote:
I figured that part of the goal of PITR was that you could recover from
just the tar backup and archived WAL files --- using the pg_xlog
contents is nice, but not something we can require.
I understood the last missing WAL log would cause missing information,
but not
pgman wrote:
I figured that part of the goal of PITR was that you could recover from
just the tar backup and archived WAL files --- using the pg_xlog
contents is nice, but not something we can require.
I understood the last missing WAL log would cause missing information,
but not that it
I could still use a little clarification. It seems sort of like there is
an extra step, like:
(1) start archiving
(2) pg_start_backup()
(3) copy PGDATA directory with tar
(4) pg_stop_backup()
(5) ??
And the text you have at
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
Jeff Davis wrote:
I could still use a little clarification. It seems sort of like there is
an extra step, like:
(1) start archiving
(2) pg_start_backup()
(3) copy PGDATA directory with tar
(4) pg_stop_backup()
(5) ??
And the text you have at
Bruce Momjian pgman@candle.pha.pa.us writes:
The problem is that we don't archive the partially written xlog file,
and in this case that xlog file contains the information needed to make
the tar file consistent.
Is this a known problem? Do we document this? If so, I can't find it.
Yes,
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
The problem is that we don't archive the partially written xlog file,
and in this case that xlog file contains the information needed to make
the tar file consistent.
Is this a known problem? Do we document this? If so, I
49 matches
Mail list logo