On 11/07/2013 11:01 AM, Alvaro Herrera wrote:
> Maybe we could provide a master controller program (pg_backup or
> whatever name we agree on), which could receive commands much like
> pg_ctl.
>
> $ pg_backup --help
> pg_backup is a backup handler program for PostgreSQL.
>
> Usage:
> pg_backup backup [-p PATTERN] DATABASE [...]
> pg_backup restore [-f PATH]
> pg_backup backup_globals
> ...
>
> The "pattern" stuff would let you specify many databases in the command
> line and have it dump each DB on a separate file, and perhaps do
> strftime-style replacements, etc.
>
> Initially we could have this just call pg_dump underneath, but
> eventually it might grow superpowers of its own.
>
+1
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms a rose in the deeps of my heart. - W.B. Yeats