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.sewell@lisasoft.com> wrote:
Oh I missed that, I skimmed and thought it was the same as \setTurns out it's not and it's exactly what I want!Thanks!______________________________________
James Sewell,
PostgreSQL Team Lead / Solutions Architect
On Wed, Oct 23, 2013 at 11:48 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:On 10/22/2013 03:41 PM, James Sewell wrote:Lucas' \setenv method won't work for you?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?--Cheers,
James Sewell,
PostgreSQL Team Lead / Solutions Architect
Adrian Klaver
adrian.klaver@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.
В списке pgsql-general по дате отправления:
Предыдущее
От: Patrick DungДата:
Сообщение: Re: (collation) Building postgresql on FreeBSD, the pros and cons of icu