Thread: pg_autovacuum

pg_autovacuum

From
Zlatko Matić
Date:
How to use pg_autovacuum ?

Re: pg_autovacuum

From
Tom Lane
Date:
=?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr> writes:
> How to use pg_autovacuum ?

Read the README file for it.

            regards, tom lane

Re: pg_autovacuum, vacuumdb on Windows XP

From
Zlatko Matić
Date:
Hello.

I have found README file, and tried to install pg_autovacuum as Windows
service, by a batch file:
@echo off
set ODREDISTE=C:
echo target disc is %ODREDISTE%
cd %ODREDISTE%\Program Files\PostgreSQL\8.0\bin
pg_autovacuum.exe pgsql-8.0.4 -I -N postgres_service -W postgres_service

"postgres_service" was both "service" username and password during
installation of postgreSQL...
But, an error apeared regarding username and password. Then I tried with
Windows administrator username and password, also unsuccessfully.
Finally I removed -N and -W parameters and then there was a message on
console that it is successfully installed as service.
The final batch file was:
@echo off
set ODREDISTE=C:
echo target disc is %ODREDISTE%
cd %ODREDISTE%\Program Files\PostgreSQL\8.0\bin
pg_autovacuum.exe pgsql-8.0.4 -I

My questions are the following:

1. Is pg_autovacuum now really active and how can I be sure ?
2. Is it allowed to use pg_autovacuum -I without specifying parameters -N
and -W ?
3. Why I was unable to pass username and password to parameters -N and -W?
4. Should -N be Windows administrator or postgres service username ?
5. If -N is postrges service name and -W password of that service, and both
are entered as plain text in the batch file, how can it reflect to security
of database? In fact, what can do service username postgres (or
postgres_service in my case) ?

I'm sorry for bothering you,

Zlatko


----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, October 09, 2005 5:37 PM
Subject: Re: [GENERAL] pg_autovacuum


> =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr> writes:
>> How to use pg_autovacuum ?
>
> Read the README file for it.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend