Re: Backup of a big DB with a lot of large objects
От | Richard Broersma Jr |
---|---|
Тема | Re: Backup of a big DB with a lot of large objects |
Дата | |
Msg-id | 4617.40027.qm@web31812.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Re: Backup of a big DB with a lot of large objects ("Milen A. Radev" <milen@radev.net>) |
Ответы |
Re: Backup of a big DB with a lot of large objects
|
Список | pgsql-admin |
> > Replicate it??? > > I'm hesitant about replacing backup with replication. It seems to me > like trying to shoot a mosquito with a cannon. One some threads that I've read, some posters mention that once their databases reach a certain size threshold, backups times become so large that replication seems to be the better perhaps only choice. I suppose that if replication is used, one of their child read-only servers can be dedicated the task of backing up the database thereby relieving that load off of the parent read/write server. But this doesn't solve the problem increasing back-up times. Of course, equipping yourself with a cannon now will really help after your mosquito grows in to an albatross. :o) Regards, Richard Broersma Jr.
В списке pgsql-admin по дате отправления: