Re: [GENERAL] Urgent Help Required

Поиск
Список
Период
Сортировка
От shailesh singh
Тема Re: [GENERAL] Urgent Help Required
Дата
Msg-id CAAzPmNzrQs7diLsN946g8+du8h5R7U6PWshk_EmQESxdBmvVzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Urgent Help Required  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: [GENERAL] Urgent Help Required  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: GIN improvements part 1: additional information
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Urgent Help Required