| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | ahmed soua <ahmed(dot)soua(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to disable autovaccum |
| Date: | 2009-04-14 14:01:35 |
| Message-ID: | 20090414140135.GP7709@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
ahmed soua escribió:
> Hi everybody,
>
> When I was working with Postgis , I had the following error:
> *failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou
> d'une chaîne
> contenant plusieurs commandes* ( VACUUM cannot be executed from a function
> or from a chain containing several commands)
> *Error occurred, cleaning up.
> *I had disabled the parameter autocavcum in the file* postgresql.conf* but i
> still have the same error.
The error did not come from autovacuum, so by disabling it you have not
fixed anything. I suggest you turn it back on (unless you have a good
plan for vacuuming), and fix your application code instead.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kynn Jones | 2009-04-14 14:57:26 | Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'... |
| Previous Message | Lincoln Yeoh | 2009-04-14 12:57:16 | Re: Is it bad sorting in UTF ?? |