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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Tue, 22 Feb 2005 18:48:00 -0500
  • Message-id: <421BC4B0(dot)2030802(at)dunslane(dot)net>



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


  • References:

Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group