Thanks Tom - that did the trick
We will be upgrading to 8.2 within the next couple weeks.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008 12:20 PM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] no entry on pg_database for a
"Mark Steben" <[EMAIL PROTECTED]> writes:
> Thanks Tom - that did the trick
In that case, you were missing pg_database and probably other system
catalogs too in your vacuuming.
> We will be upgrading to 8.2 within the next couple weeks.
I'd recommend making sure you have vacuumed all system cata
Hi there,
i have a situation on my sandbox:
pg_xlog directory of cluster was gone at stopped postgres. it was on another
disk
which has broken. in this situation postgres falling to .core at startup with
messages:
---
LOG: could not open file "pg_xlog/000300010058" (log file 1,
seg
Alexander Vysokovskih <[EMAIL PROTECTED]> writes:
> ---
> LOG: could not open file "pg_xlog/000300010058" (log file 1,
> segment 88): No such file or directory
> LOG: invalid primary checkpoint record
> ---
> before that happened postgres was shutdown normally.
If so, pg_resetxlog w
