Re: vacuum full for all databases

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Ilia Chipitsine <ilia(at)paramon(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum full for all databases
Date: 2004-09-02 07:59:49
Message-ID: 200409020959.49744.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Donnerstag, 2. September 2004 09:32 schrieb Ilia Chipitsine:
> I'm about to write plpgsql function which will "vacuum full" all existing
> databases. Below is an example how to get list of databases.
>
> What should I write instead of "raise notice" ?

You normally cannot access different databases from one database session. But
you could use dblink from contrib to overcome this restriction.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-09-02 08:03:41 Re: vacuum full for all databases
Previous Message Ilia Chipitsine 2004-09-02 07:32:24 vacuum full for all databases