Re: automating backup ?

Start->Control Panel->Scheduled Tasks

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Zlatko Matic
> Sent: Monday, 27 June 2005 9:21 AM
> To: Michael Fuhr
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] 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/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>