From: | Brian <signal(at)shreve(dot)net> |
---|---|
To: | Rob den Boer <rdboer(at)hrs-rotterdam(dot)nl> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | RE: [GENERAL] vacuuming |
Date: | 1998-06-30 13:46:33 |
Message-ID: | Pine.LNX.3.96.980630084314.19260B-100000@mercury.shreve.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 30 Jun 1998, Rob den Boer wrote:
> Hi,
>
> > -----Original Message-----
> > From: owner-pgsql-general(at)hub(dot)org [mailto:owner-pgsql-general(at)hub(dot)org]On
> > Behalf Of Brian
> > Sent: zondag 28 juni 1998 18:33
> > To: pgsql-general(at)postgreSQL(dot)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(at)shreve(dot)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 -----------------------------/
From | Date | Subject | |
---|---|---|---|
Next Message | Roman Volkoff | 1998-07-01 10:23:49 | unsubscribe |
Previous Message | The Hermit Hacker | 1998-06-30 12:19:56 | RE: [GENERAL] vacuuming |