| From: | BladeOfLight16 <bladeoflight16(at)gmail(dot)com> |
|---|---|
| To: | James Sewell <james(dot)sewell(at)lisasoft(dot)com> |
| Cc: | Raghu Ram <raghuchennuru(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dumpall from a script |
| Date: | 2013-10-22 06:07:44 |
| Message-ID: | CA+=1U=VTbZpqjVr61PMdPrx_fZL5hT0JuECEzoq77P3kOHprZA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 22, 2013 at 1:20 AM, James Sewell <james(dot)sewell(at)lisasoft(dot)com>wrote:
> That looks great, but it doesn't really help with my problem unless I'm
> missing something (very possible!)
>
> I need a way to backup either from SQL in PSQL (possibly \!) or from a
> PG/PLSQL function to a file with a name set from a :variable.
>
> This would be triggered by a certain action in the database (applying a
> patch).
>
I don't understand. To use psql, you would have to launch it with a command
line, as far as I know. If psql is a viable option for you, then you should
be able to execute other commands as well. That would make a bash script a
viable option. How do you intend to launch psql?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2013-10-22 06:41:34 | Re: pg_dumpall from a script |
| Previous Message | James Sewell | 2013-10-22 05:20:03 | Re: pg_dumpall from a script |