Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
----- Original Message -----
From: "Michael Fuhr" <mike@xxxxxxxx>
To: "Zlatko Matic" <zlatko.matic1@xxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Sunday, June 26, 2005 2:59 PM
Subject: 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/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
