pg_autovacuum (8.0.4) as Windows service ?
When installing pg_autovacuum as Windows service, should user that makes connection be the service account or a superuser ?
For example, I have service account "postgres_service" and database superuser "postgres". Which one should be used in following script:
@echo off
set TARGET_DISC=C:
echo target disc is %TARGET_DISC%
cd %TARGET_DISC%\Program Files\PostgreSQL\8.0\bin
pg_autovacuum.exe pgsql-8.0.4 -I -U user -P password
pause
Thanks,
Zlatko
When installing pg_autovacuum as Windows service, should user
that makes connection be the service account or a superuser ?
For example, I have service account "postgres_service" and
database superuser "postgres". Which one should be used in
following script:
@echo off
set TARGET_DISC=C:
echo target disc is %TARGET_DISC%
cd %TARGET_DISC%\Program Files\PostgreSQL\8.0\bin
pg_autovacuum.exe pgsql-8.0.4 -I -U user -P password pause
Database superuser.
//Magnus
Import Notes
Resolved by subject fallback