Re: automating backup ?

On Sun, 2005-06-26 at 11:18 +0200, Zlatko Matic wrote:
> How to automate backup, so that Postgres automatically backups, for example,
> once in a week ?
> The same question about vacuum ?
>
> Concerning backup, how to prevent that someone makes a copy (for example
> pg_dumpall) of a database,

pg_dumpall is no special case. It just runs some SQL queries. Your users
are subject to the normal permission checking.

> then installs new instance of Postgres, create
> the same user acount that was the original owner and then restore the
> database. In that case all restrictions would be overriden, right ?

No, because pg_dumpall doesn't override any restriction.

Of course, if someone puts his hands on _your_ backups (made with full
permissions), he can access everything, unless you encrypted it.

.TM.
--
____/ ____/ /
/ / / Marco Colombo
___/ ___ / / Technical Manager
/ / / ESI s.r.l.
_____/ _____/ _/ Colombo(at)ESI(dot)it