471,306 Members | 874 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

reset xlog on 7.1 ?


Is there a way to reset the xlog on postgres 7.1 ?
Due to complete & intensive braindamage of sysadmin (=me) the whole
pg_xlog-folder has been emptied on a old 7.1-installation.

pg_resetxlog is not part of 7.1-installation and I wonder if there is any other
way to fire postgres up again. (To make my day complete : there arent backups
available also).

by now I get:

Oct 8 21:26:29 linux postgres[14575]: [2] DEBUG: open(logfile 3 seg 18)
failed: No such file or directory
Oct 8 21:26:29 linux postgres[14575]: [3] DEBUG: Invalid primary checkPoint record
Oct 8 21:26:29 linux postgres[14575]: [4] DEBUG: open(logfile 3 seg 17)
failed: No such file or directory
Oct 8 21:26:29 linux postgres[14575]: [5] DEBUG: Invalid secondary checkPoint
record
Oct 8 21:26:29 linux postgres[14575]: [6] FATAL 2: Unable to locate a valid
CheckPoint record
Oct 8 21:26:29 linux postgres[14575]: [7] DEBUG: proc_exit(2)
Oct 8 21:26:29 linux postgres[14575]: [8] DEBUG: shmem_exit(2)
Oct 8 21:26:29 linux postgres[14575]: [9] DEBUG: exit(2)
thnx,
peter

--
IT-Consulting
mag. peter pilsl
tel:+43-699-1-3574035
fax:+43-699-4-3574035
pi***@goldfisch.at
http://www.goldfisch.at


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #1
1 2262
peter pilsl <pi***@goldfisch.at> writes:
Is there a way to reset the xlog on postgres 7.1 ?


pg_resetxlog exists for 7.1, but it's in contrib not standard.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Ken | last post: by
6 posts views Thread by Ramachandran Subramanian | last post: by
1 post views Thread by NancyASAP | last post: by
reply views Thread by CH | last post: by
2 posts views Thread by Roger Withnell | last post: by
11 posts views Thread by newbie | last post: by
16 posts views Thread by Giovanni D'Ascola | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.