From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | 8.2.15 pitr/00000001.history |
Date: | 2010-03-24 17:10:31 |
Message-ID: | 20100324171031.GA13674@cns.vt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
While testing an 8.2.15 pitr procedure I see this postmaster log entry on startup of the
recovered cluster:
2010-03-24 12:38:36.357 EDT,,3,,, LOG: restore_command = "cp /home/postgresql/fms/wals/%f %p"
cp: cannot stat `/home/postgresql/fms/wals/00000001.history': No such file or directory
pg goes on to restore from other wal segments, but I wonder if someone could explain
the significance of this history file? Should I have such a file?
Also, are there objects I can query to check the current cluster status compared to the
beginning of the recovery for such things as next transaction ID, next OID, checkpoint record,
and redo record?
2010-03-24 12:38:36.438 EDT,,6,,, LOG: checkpoint record is at 28/D9000020
2010-03-24 12:38:36.438 EDT,,7,,, LOG: redo record is at 28/D9000020; undo record is at 0/0; shutdown FALSE
2010-03-24 12:38:36.438 EDT,,8,,, LOG: next transaction ID: 0/9160987; next OID: 16874
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2010-03-24 19:09:18 | Re: How to use an alias name in the current select |
Previous Message | Guy Deleeuw | 2010-03-24 16:42:10 | How to use an alias name in the current select |