You could write a plperlul function that runs a shell script to back up your database, you can even pass it parameters and put a call to that in a trigger.
BUT, this could result in multiple backups running at the same time and become a performance drag. -- Mike Nolan On Tue, Oct 22, 2013 at 9:19 PM, James Sewell <james.sew...@lisasoft.com>wrote: > Oh I missed that, I skimmed and thought it was the same as \set > > Turns out it's not and it's exactly what I want! > > Thanks! > > > James Sewell, > PostgreSQL Team Lead / Solutions Architect > ______________________________________ > > > Level 2, 50 Queen St, Melbourne VIC 3000 > > *P *(+61) 3 8370 8000 * **W* www.lisasoft.com *F *(+61) 3 8370 8099 > > > > On Wed, Oct 23, 2013 at 11:48 AM, Adrian Klaver > <adrian.kla...@gmail.com>wrote: > >> On 10/22/2013 03:41 PM, James Sewell wrote: >> >>> Hello All, >>> >>> Thanks for the replies.Sorry I must have been a bit unclear, I realise I >>> *could* do this from the shell level, but can I do it from a PSQL >>> session somehow? >>> >> >> Lucas' \setenv method won't work for you? >> >> >> >> Cheers, >>> >>> >>> James Sewell, >>> PostgreSQL Team Lead / Solutions Architect >>> >> >> >> -- >> Adrian Klaver >> adrian.kla...@gmail.com >> > > > ------------------------------ > The contents of this email are confidential and may be subject to legal or > professional privilege and copyright. No representation is made that this > email is free of viruses or other defects. If you have received this > communication in error, you may not copy or distribute any part of it or > otherwise disclose its contents to anyone. Please advise the sender of your > incorrect receipt of this correspondence. > >