Обсуждение: Vacuum full hanging

Поиск
Список
Период
Сортировка

Vacuum full hanging

От
neelam
Дата:
Hi,

I am using Postgres version 9.0.18 in my application.When I run the command
"vacuum full" it hangs and after long time it returns with exit code 2.
I tried running it in verbose mode but didn't get any useful information, in
that mode as well it hangs after printing few lines.
Vacuum run fine.

Let me know how can I debug it further.

Regards
Neelam 



--
View this message in context: http://postgresql.nabble.com/Vacuum-full-hanging-tp5856683.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Re: Vacuum full hanging

От
Josh Berkus
Дата:
On 07/05/2015 10:46 PM, neelam wrote:
> Hi,
> 
> I am using Postgres version 9.0.18 in my application.When I run the command
> "vacuum full" it hangs and after long time it returns with exit code 2.
> I tried running it in verbose mode but didn't get any useful information, in
> that mode as well it hangs after printing few lines.

Can you give us the output?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Re: Vacuum full hanging

От
neelam
Дата:

No output it just hangs , see below:

 

voyencedb=# vacuum full verbose;

INFO:  vacuuming "pg_catalog.pg_class"

 

Regards

Neelam

From: Josh Berkus [via PostgreSQL] [mailto:[hidden email]]
Sent: Tuesday, July 07, 2015 5:27 AM
To: Batra, Neelam
Subject: Re: Vacuum full hanging

 

On 07/05/2015 10:46 PM, neelam wrote:
> Hi,
>
> I am using Postgres version 9.0.18 in my application.When I run the command
> "vacuum full" it hangs and after long time it returns with exit code 2.
> I tried running it in verbose mode but didn't get any useful information, in
> that mode as well it hangs after printing few lines.

Can you give us the output?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


--
Sent via pgadmin-support mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

If you reply to this email, your message will be added to the discussion below:

http://postgresql.nabble.com/Vacuum-full-hanging-tp5856683p5856838.html

To unsubscribe from Vacuum full hanging, click here.
NAML


View this message in context: RE: Vacuum full hanging
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.