Adrian Klaver-3 wrote > On 10/08/2013 03:55 AM, shailesh singh wrote: >> I had got this message while running vacuum full from backend . Now My >> database is not starting , Help pls. >> >> backend> vacuum full debug; >> WARNING: database "debug" must be vacuumed within 999999 transactions >> HINT: To avoid a database shutdown, execute a full-database VACUUM in >> "debug". >> ERROR: relation "debug" does not exist > >> >> Now what? > > First some information. > > 1) What version of Postgres are you using? > > 2) Does database debug in fact exist or not? > In other words does it show up with \l in psql? > > Also it not necessary to use FULL with the VACUUM. > >> >> Thanks in advance. >> >> Shailesh Singh >From the documentation: http://www.postgresql.org/docs/9.2/interactive/sql-vacuum.html "With no parameter, VACUUM processes every table in the current database that the current user has permission to vacuum. With a parameter, VACUUM processes only that table." Since you must be connected to a database to issue VACUUM to specify which database would be redundant. Your specification of "debug" in the above command was not taken to be a database but rather a relation/table. The basic steps are: 1) connect to the "debug" database. 2) issue the command "VACUUM" with no parameters The reason for the error is that transaction id wraparound is on the verge of occurring. After having solved the immediate problem by manually vacuuming you should try and describe to us why it is the auto-vacuum service has failed to vacuum the debug database in time to prevent the warning. The immediate solution will work on any version but the cause analysis will require knowing the PostgreSQL versions, its configuration, and basic usage characteristics. Regardless, though, always provide version information when asking for help. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Urgent-Help-Required-tp5773675p5773692.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
