On Tue, 30 Jun 1998, Rob den Boer wrote:
> Hi,
>
> > -----Original Message-----
> > From: owner-pgsql-general@hub.org [mailto:owner-pgsql-general@hub.org]On
> > Behalf Of Brian
> > Sent: zondag 28 juni 1998 18:33
> > To: pgsql-general@postgreSQL.org
> > Subject: [GENERAL] vacuuming
>
> > Is it common practice to setup a cron job to vacuum your databases
> > nightly? Do you just do something like:
>
>
> Every night I dump my database, and vacuum it afterwards.
> One thing to keep in mind that you don't want to do as root
> since pgsql doesn't like this.
> So you have to run cron as a db admin user. (give this user permission to
> use cron)
I have read "pgsql" doesn't like this, but I actually have several
databases that have granted permissions to root. Will it give an error if
you vacuum as root?
>
> regards
> Rob den Boer
>
>
/-------------------------- signal@shreve.net -----------------------------\
| Brian Feeny | USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN & LANs |
| 89 CRX DX w/MPFI, lots of |-=*:Quake:*=-| http://www.shreve.net/ |
| mods/Homepage coming soon |LordSignal/SN| Quake server: 208.206.76.47 |
\-------------------------- 318-222-2638 x109 -----------------------------/