Re: pg_dumpall from a script

[Raghu Ram <raghuchennuru@xxxxxxxxx>]

On Tue, Oct 22, 2013 at 8:07 AM, James Sewell <james.sewell@xxxxxxxxxxxx> 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:

http://wiki.postgresql.org/wiki/Automated_Backup_on_Linux

Thanks & Regards

Raghu Ram