| From: | peter pilsl <pilsl(at)goldfisch(dot)at> |
|---|---|
| To: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | reset xlog on 7.1 ? |
| Date: | 2003-10-08 19:52:48 |
| Message-ID: | 1065642768.3f846b1086484@www.goldfisch.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
pilsl(at)goldfisch(dot)at
http://www.goldfisch.at
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2003-10-08 19:58:03 | Re: PostgreSQL vs. MySQL |
| Previous Message | Vivek Khera | 2003-10-08 19:28:59 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |