Re: pg_dump

Jamie Deppeler wrote:

> is there a way i can execute a dump inside postgresql rather than 
> executing an file such as pg_dump or pg_dumpall as i plan to have my 
> application trigger the backup
>
>

The only way I can think of is to write a function in an untrusted 
language (C, plperlu, etc) to kick off the dump. Be careful you don't 
hang the postgres process when doing so unless that's what you really 
want (so a call to system() is probably not the way to do it).

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq