Postgres Pro
Downloads
Home   >   mailing lists

Thread: reset xlog on 7.1 ?

reset xlog on 7.1 ?

From
peter pilsl
Date:
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@goldfisch.at
http://www.goldfisch.at

Re: reset xlog on 7.1 ?

From
Tom Lane
Date:
peter pilsl <pilsl@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