Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Urgent Help Required - Mailing list pgsql-hackers

From shailesh singh
Subject Re: [GENERAL] Urgent Help Required
Date
Msg-id CAAzPmNzrQs7diLsN946g8+du8h5R7U6PWshk_EmQESxdBmvVzg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Urgent Help Required  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: [GENERAL] Urgent Help Required  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-hackers
Tree view
Dear all,
 First of all i wish to share actual error meassge,

Below are the queries i had executed on the terminal on my server


-bash-3.2$ touch fix.sql
-bash-3.2$ echo "VACUUM FULL;" > fix.sql
-bash-3.2$ postgres -D /var/lib/pgsql/data patnadbold < fix.sql
WARNING: database "patnadbold" must be vacuumed within 1000000 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 1000000 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".

PostgreSQL stand-alone backend 8.1.11
backend> WARNING: database "patnadbold" must be vacuumed within 999999 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999998 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999997 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999996 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999995 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999994 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999993 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999992 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999991 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999990 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999989 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999988 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999987 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999986 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999985 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
WARNING: database "patnadbold" must be vacuumed within 999984 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in "patnadbold".
ERROR: could not access status of transaction 33011
DETAIL: could not open file "pg_clog/0000": No such file or directory
exit


After this i am able to stop /start my db server but i am not able to connect to my databases (it tells to run vacuum full first on patnadbold databases)


1)I am using postgres 8.4 version.
2) I had two databases on this server i) patnadbold  ii) patnaonlinedb

For me patnadbold is of no use if at this moment i lost this database that also fine to me.
I wanted to connect patnaonlinedb any how and wanted to perform backup of this , Solution please.


On Tue, Oct 8, 2013 at 6:19 PM, Adrian Klaver <adrian.klaver@gmail.com> 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


--
Adrian Klaver
adrian.klaver@gmail.com



--
  With Regards,
  शैलेश सिंह |Shailesh Singh
 +९१-९६५०३१७५१७ | +91-9650317517


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: GIN improvements part 1: additional information
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Urgent Help Required