Re: automating backup ?
От | Zlatko Matic |
---|---|
Тема | Re: automating backup ? |
Дата | |
Msg-id | 008e01c57aa5$bd3e81f0$14341dc3@zlatko58zaczpv обсуждение исходный текст |
Ответ на | Win32 users? (Joe <svn@freedomcircle.net>) |
Ответы |
Re: automating backup ?
|
Список | pgsql-general |
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/
В списке pgsql-general по дате отправления: