Re: automating backup ?

On Sun, Jun 26, 2005 at 11:18:31AM +0200, Zlatko Matic wrote:
>
> How to automate backup, so that Postgres automatically backups, for
> example, once in a week ?

Using the operating system's mechanism for scheduling jobs to run
periodically. For example, cron on Unix-like systems.

> The same question about vacuum ?

Same answer as above. See also contrib/pg_autovacuum.

> Concerning backup, how to prevent that someone makes a copy (for example
> pg_dumpall) of a database, 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 ?

All what restrictions? If you've granted users permission to select
certain data, then they can copy that data to somewhere else and
do whatever they like with it; but with the original data they can
do only what you grant them permission to do. If you don't want
users to copy data then don't grant them select privilege on it,
and make sure they don't have database superuser or operating system
superuser (administrator) privileges on the database server.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/