Hello, On Fri, 21 Mar 2008 21:50:57 +0100 Markus Wollny wrote: > My database cluster has just stopped working. I get the following message: > psql: FATAL: Datenbank nimmt keine Befehle an, um Datenverlust in Datenbank »postgres« wegen Transaktionsnummernüberlauf zu vermeiden > TIP: Halten Sie den Postmaster an und verwenden Sie ein Standalone-Backend, um VACUUM in der Datenbank »postgres« auszuführen. First of all, it would help you and most of the readers on this list, if you have the error messages in english. There is a german mailinglist too, if you want to ask in german. > That's what I just did, but the problem persists. Whenever I issue a 'vacuum', the number of transactions simply decreases. vacuum all databases, add the VERBOSE option to see, what actually happens. > I am absolutely lost about what to do now - and it's a puzzle how this could have happened in the first place. I have configured autovaccum AND I run a vacuum verbose analyze over all databases every single night. What do I do now? Is there some alternative to reinit and going back to the last dump? Are you using the database 'postgres' at all? And are you sure, that you include all databases? Any error messages in the vacuum output? Oh, and by the way: why do you have autovacuum and a manual vacuum run every night plus the vacuum run with verbose? > Urgent help would be very much appreciated. That's a bit late here ;-) Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
