Skip site navigation (1) Skip section navigation (2)

Re: pg_dump

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: "'pgsql-hackers-win32(at)postgresql(dot)org'" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: pg_dump
Date: 2005-02-22 23:48:00
Message-ID: 421BC4B0.2030802@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers-win32

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

In response to

  • pg_dump at 2005-02-22 22:45:57 from Jamie Deppeler

pgsql-hackers-win32 by date

Next:From: Andreas PflugDate: 2005-02-23 15:35:38
Subject: Slony under win32
Previous:From: Jamie DeppelerDate: 2005-02-22 22:45:57
Subject: pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group