[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    RE: [GENERAL] vacuuming
From:       Brian <signal () shreve ! net>
Date:       1998-06-30 13:46:33
[Download RAW message or body]

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 -----------------------------/

[prev in list] [next in list] [prev in thread] [next in thread]