Re: [BUGS] Version 7.2.3 unrecoverable crash on missing pg_clog

2003-01-09 Thread Tom Lane
Andy Osborne [EMAIL PROTECTED] writes: One of our databases crashed yesterday with a bug that looks a lot like the non superuser vacuum issue that 7.2.3 was intended to fix, although we do our vacuum with a user that has usesuper=t in pg_user so I guess it's not that simple. FATAL 2: open

Re: [BUGS] Version 7.2.3 unrecoverable crash on missing pg_clog

2003-01-09 Thread Andy Osborne
Tom Lane wrote: Andy Osborne [EMAIL PROTECTED] writes: One of our databases crashed yesterday with a bug that looks a lot like the non superuser vacuum issue that 7.2.3 was intended to fix, although we do our vacuum with a user that has usesuper=t in pg_user so I guess it's not that simple.

Re: [BUGS] Version 7.2.3 unrecoverable crash on missing pg_clog

2003-01-09 Thread Tom Lane
Andy Osborne [EMAIL PROTECTED] writes: Tom Lane wrote: FATAL 2: open of /u0/pgdata/pg_clog/0726 failed: No such file or directory What range of file names do you actually see in pg_clog? Currently to 00D6. I don't know what it was last night. Not any greater, for sure. (FYI, each