Start->Control Panel->Scheduled Tasks > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Zlatko Matic > Sent: Monday, 27 June 2005 9:21 AM > To: Michael Fuhr > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: automating backup ? > > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
