Thread: autovacuum daemon

On 21/01/2009 07:47, Abdul Rahman wrote:

> I have set postgresql.conf for autovacuum and need to know weather
> the process is running/working or not.

ps ax | grep postgres


Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On 21/01/2009 14:57, Raymond O'Donnell wrote:
> On 21/01/2009 07:47, Abdul Rahman wrote:
>
>> I have set postgresql.conf for autovacuum and need to know weather
>> the process is running/working or not.
>
> ps ax | grep postgres

Also, in psql:

postgres=# show autovacuum;
 autovacuum
------------
 on
(1 row)

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Abdul Rahman schrieb:
> Deal All,
>
> I have set postgresql.conf for autovacuum and need to know weather the
> process is running/working or not.

Hi Abdul,

1. you could check the log file

2. select setting from pg_settings where name = 'autovacuum';

Cheers

Andy

- -- Andreas Wenk St.Pauli - Hamburg - Germany

> Regards,
> Avdul Rehman.
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdzk6Va7znmSP9AwRAk2nAJ9eeGtXGZbyMoPFZwukmg0T/4sWtgCg28iN
B6m0nEgLALvIv2ZGZt9syvs=
=4zR5
-----END PGP SIGNATURE-----

select * from pg_autovacuum;




--
GJ

  [ Grzegorz, please include some context ]

On Wed, Jan 21, 2009 at 03:01:39PM +0000, Grzegorz Jaaakiewicz wrote:
> Avdul Rehman wrote:
> > I have set postgresql.conf for autovacuum and need to know weather
> > the process is running/working or not.
>
> select * from pg_autovacuum;

This won't do what the OP was asking for; pg_autovacuum only records
non-default autovacuum parameters where they have been set by the
user/admin.  More details here:

  http://www.postgresql.org/docs/current/static/catalog-pg-autovacuum.html

--
  Sam  http://samason.me.uk/

On 22/01/2009 07:15, Abdul Rahman wrote:

> Your solution of using ps command is for Linux but I am using WinXp.
> That is why it confused me.

No problem! :-) It occurred to me after I sent the email that you might
not be on Linux....

It's a good idea, when posting questions, to include as much background
detail as you can - platform, PG version, etc etc - it helps you get an
answer to your specific problem more quickly, as it saves back-and-forth
questions about this stuff.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Abdul Rahman wrote on 22.01.2009 07:06:
> Now, kindly let me know the detail about the solution send by Ray, i.e.
>
> ps ax | grep postgres

For WindowsXP the above command can be written as:

tasklist /v /fi "imagename eq postgres.exe"

Thomas

On 25/01/2009 13:37, Thomas Kellerer wrote:
> Abdul Rahman wrote on 22.01.2009 07:06:
>> Now, kindly let me know the detail about the solution send by Ray, i.e.
>>
>> ps ax | grep postgres
>
> For WindowsXP the above command can be written as:
>
> tasklist /v /fi "imagename eq postgres.exe"

Cool! I didn't know that one. Must R some more FMs.... :-)

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Raymond O'Donnell wrote on 25.01.2009 19:28:
>> For WindowsXP the above command can be written as:
>>
>> tasklist /v /fi "imagename eq postgres.exe"
>
> Cool! I didn't know that one. Must R some more FMs.... :-)

No need for manuals :)

Just enter "takslist /?"

Regards
Thomas