[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: [HACKERS] small pg_dump RFE: new --no-prompt (password) option
From: Marc Herbert <Marc.Herbert () continuent ! com>
Date: 2006-11-30 19:52:35
Message-ID: 20061130195235.GD8302 () continuent ! com
[Download RAW message or body]
Hi there,
As discussed recently on the jdbc mailing-list in this "Backup in Java" thread
<http://thread.gmane.org/gmane.comp.db.postgresql.jdbc/12441/focus=12441>
there is a significant interest in doing backups in an
non-interactive, programmatic way. Reminder: AFAIK pg_dump is
currently the very unique reliable way to perform a backup. There is no
documented API or protocol to do this. Any program in any language is
stuck with "scripting" pg_dump.
When we implemented this scripting in Java we faced one major issue:
pg_dump may prompt for a password in a unpredictable way (depending on
the user misconfiguration). Taking care of this is surprisingly
complex. The suggested --no-prompt would make scripting pg_dump
infinitely easier. In case a password is needed, this option would
simply fail and return immediatly with an appropriate error message.
Or even better, with a well-defined return status.
Thanks in advance for considering this new feature!
Sincerely,
Marc.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic