filippo wrote: > On 14 Feb, 08:33, [EMAIL PROTECTED] (Ron Johnson) wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > There's almost definitely a better way to do what you want to do. > > > > What benefit are you trying to obtain by creating 720 almost > > identical databases per month? > > I only need the last 24, overwriting each day. In my case 8 are enough > (8am to 24pm, one every 2 hours). The important thing is to be able to > open each very simply (read only) without restore anything. Just tell > my application (written be me), to point the basckup database instead > of latest one.
I wonder if you could have a PITR warm standby instead, and every hour stop it and backup that. This is very hand-wavy, you're expected to fill in the details :-) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
