RE: [GENERAL] vacuuming - Mailing list pgsql-general

From Rob den Boer
Subject RE: [GENERAL] vacuuming
Date
Msg-id 000101bda4ec$26863a50$67032e9f@hrs_nt.hrs
Whole thread Raw
In response to RE: [GENERAL] vacuuming  (Brian <signal@shreve.net>)
List pgsql-general

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

When I installed pgsql I read that it was not advisable to use root, so
I have a admin user with full privileges on the database, and I 'su' to
that user.

Also, I push the compressed dumpfile onto another server, and this is easier
done as a normal user rather than root. Most machines (Linux) don't like
root ftp or rcp even when you have host equivelance.

regards
Rob den Boer


pgsql-general by date:

Previous
From: Brian
Date:
Subject: RE: [GENERAL] vacuuming
Next
From: "Rob den Boer"
Date:
Subject: RE: [GENERAL] vacuuming