Re: [pgadmin-support] Vacuum full hanging

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:ml-node+s1045698n5856838...@n5.nabble.com] Sent: Tuesday, July 07, 2015 5:27 AM To: Batra, Neelam Subject: Re: Vacuum full hangin

Re: [pgadmin-support] pgagent errors on application_name

Hi Josh, On Mon, Jul 6, 2015 at 11:55 PM, Josh Berkus wrote: > To wit: > > postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgres > user=postgres application_name=pgagent > ERROR: Primary connection string is not valid! > 18:15:15: Debug: In file ../src/unix/threadpsx.cpp at line 261

Re: [pgadmin-support] 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 i

Re: [pgadmin-support] pgagent hangs forever in "r" state

On 07/06/2015 10:26 AM, Josh Berkus wrote: > All, > > On the same server with the SQL errors (sequences are cleaned up now), > we're having pgagent start all jobs in the "r" state, log the first step > in each job in the "r" state, and then hang forever (or, at least for > three days). At this po

[pgadmin-support] pgagent errors on application_name

To wit: postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgres user=postgres application_name=pgagent ERROR: Primary connection string is not valid! 18:15:15: Debug: In file ../src/unix/threadpsx.cpp at line 261: 'pthread_mutex_destroy()' failed with error 0x0010 (Device or resourc

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

On 07/05/2015 10:27 PM, Josh Berkus wrote: > On 07/05/2015 01:38 PM, Christoph Berg wrote: >> pgagent had not been rebuilt for quite a while which is why it didn't >> have 9.4 (and jessie) support yet. Fixed now: > > Thanks! Oh, also, tested and verified. New packages work with 9.4. -- Josh Be

[pgadmin-support] pgagent hangs forever in "r" state

All, On the same server with the SQL errors (sequences are cleaned up now), we're having pgagent start all jobs in the "r" state, log the first step in each job in the "r" state, and then hang forever (or, at least for three days). At this point, 8 different jobs are in "r" state. In pg_stat_act

[pgadmin-support] Please unsubscribe me from the site. I am no working for this company

Please unsubscribe me from the site. I am no working for this company *Khangelani Gama * DBA Office: +27 (0)11 712-1565 Email: kg...@argility.com *www.argility.com* *"**Plan ahead.It