Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Centralise and simplify your PostgreSQL hot backup management

by jeteve (Pilgrim)
on Oct 12, 2010 at 11:43 UTC ( #864822=perlnews: print w/replies, xml ) Need Help??

After writing the same scripts to perform PostgreSQL hot backup over and over again, I eventually got bored and I decided to write a tool that centralises the whole thing from a central configuration file.

It's still a developer release, but it'd be great if some of you can give it a go and report any major defects.

Here it is: pg_cryobit

Cheers!

  • Comment on Centralise and simplify your PostgreSQL hot backup management

Replies are listed 'Best First'.
Re: Centralise and simplify your PostgreSQL hot backup management
by adamsj (Hermit) on Apr 18, 2012 at 21:32 UTC
    I'm getting ready to give this a whirl. Any advice? I ask because I don't see that anyone else has commented.
    They laughed at Joan of Arc, but she went right ahead and built it. --Gracie Allen

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlnews [id://864822]
help
Chatterbox?
[Corion]: Hmmm. I feel a Meditation coming on. I wrote a module, DBIx::PivotQuery, which returns a table-like set of rows (AoA) but some columns are generated from column values, like in an (Excel) pivot table or a ROLLUP command
[Corion]: My current approach for subtotals involves rerunning the given query, with the hint to the user that they should use a temporary table if they want better performance.
[Corion]: But I could create that temporary table in the module and use it for the improved perfomance directly instead.
[Corion]: And the question is, what would be better/preferred ;-)
[Corion]: Hmm - not exactly like the ROLLUP command. Ah well.

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (8)
As of 2017-02-23 15:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (347 votes). Check out past polls.