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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings