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@ESI.it