X-Original-To: pgsql-sql@postgresql.org Received: from shield.pirmabanka.lv (unknown [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 1380B47617F for ; Wed, 19 Mar 2003 03:37:55 -0500 (EST) Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14]) by shield.pirmabanka.lv (8.12.8/8.9.3) with SMTP id h2J8bstw003712 for ; Wed, 19 Mar 2003 10:37:54 +0200 Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Wed, 19 Mar 2003 10:37:53 +0200 (EET) Received: from pc311x1.pirmabanka.lv (localhost.localdomain [127.0.0.1]) by pirmabanka.lv (8.11.6/8.11.6) with SMTP id h2J8bqI09603 for ; Wed, 19 Mar 2003 10:37:53 +0200 Received: (qmail 14833 invoked by uid 100); 19 Mar 2003 08:38:46 -0000 Date: Wed, 19 Mar 2003 10:38:46 +0200 From: "Victor Yegorov" To: "Postgres SQL" Subject: vacuum all but system tables Message-ID: <20030319083846.GB14195@pirmabanka.lv> Mail-Followup-To: "Postgres SQL" Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="zhXaljGHf11kAtnf" Content-Disposition: inline User-Agent: Mutt/1.4i X-Archive-Number: 200303/450 X-Sequence-Number: 12489 --zhXaljGHf11kAtnf Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello. I'd like to make a script to automatically vacuum all my DBs nightly. And I'd like to skip system tables, starting with pg_*. I've seen in the list archives somebody's solution using regexps, something like: $> vacuum analyze !~ ^pg_; It doesn't work for me, and I cannot find the original post I've seen some time ago. I'm running: `PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.95.3'. Maybe someone came across with this and could help? --=20 Victor Yegorov --zhXaljGHf11kAtnf Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+eCyW2RKGLEykUDYRAqzDAKC95RWGgHX75OyVDrOS3tYcAvRfkwCfZfai UVkAjVfTGAyDoMDn1cc36LI= =qW/g -----END PGP SIGNATURE----- --zhXaljGHf11kAtnf--