Re: pg_dumpall from a script

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(dot)sewell(at)lisasoft(dot)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(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)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.
>
>