Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall from a script - Mailing list pgsql-general

From Raghu Ram
Subject Re: pg_dumpall from a script
Date
Msg-id CALnrrJRRu+WYb2=bSgaRA+82vmYPPVG694u914w4gAy_OWLjag@mail.gmail.com
Whole thread Raw
In response to pg_dumpall from a script  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: pg_dumpall from a script  (James Sewell <james.sewell@lisasoft.com>)
List pgsql-general
Tree view


On Tue, Oct 22, 2013 at 8:07 AM, James Sewell <james.sewell@lisasoft.com> wrote:
Hello,

I need to trigger a database dump from a SQL script (or function, but I think that is even less likely).

I know I can do:

\! pg_dumpall > /mydir/myfile

Which is fine, but I need to use a variable to set the name.

\set myfile 'filename'
\! pg_dumpall > /mydir/:myfile

Doesn't seem to work.

Any ideas?

Below URL provides more information of Automated database Backup's on Linux:



Thanks & Regards
Raghu Ram 

pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: pg_dumpall from a script
Next
From: James Sewell
Date:
Subject: Re: pg_dumpall from a script