Re: automating backup ?

Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.

----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, June 26, 2005 2:59 PM
Subject: Re: [GENERAL] 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/