Re: [ADMIN] DB Structure Recovery

2008-03-21 Thread Simon Riggs
On Wed, 2008-03-19 at 16:56 +0200, veejar wrote: > My filesystem (UFS-FreeBSD) was crashed and I have lost files from > PGSQL DATA DIR FOLDER after fsck-utility. > > I have lost files from directory "pg_xlog" > I reset my pg_xlog. > > And now have such error by starting pgsql-server: > > LOG:

Re: [ADMIN] DB Structure Recovery

2008-03-20 Thread veejar
2008/3/19, Achilleas Mantzios <[EMAIL PROTECTED]>: > Στις Wednesday 19 March 2008 16:56:19 ο/η veejar έγραψε: > > > Hello! > > > > My filesystem (UFS-FreeBSD) was crashed and I have lost files from > > PGSQL DATA DIR FOLDER after fsck-utility. > > > > I have lost files from directory "pg_xlog"

Re: [ADMIN] DB Structure Recovery

2008-03-19 Thread Achilleas Mantzios
Στις Wednesday 19 March 2008 16:56:19 ο/η veejar έγραψε: > Hello! > > My filesystem (UFS-FreeBSD) was crashed and I have lost files from > PGSQL DATA DIR FOLDER after fsck-utility. > > I have lost files from directory "pg_xlog" > I reset my pg_xlog. > > And now have such error by starting pgsql-

[ADMIN] DB Structure Recovery

2008-03-19 Thread veejar
Hello! My filesystem (UFS-FreeBSD) was crashed and I have lost files from PGSQL DATA DIR FOLDER after fsck-utility. I have lost files from directory "pg_xlog" I reset my pg_xlog. And now have such error by starting pgsql-server: LOG: database system was interrupted at 2008-03-18 22:29:48 EET L