Re: [GENERAL] mild modification to pg_dump

Поиск
Список
Период
Сортировка
От marcelo
Тема Re: [GENERAL] mild modification to pg_dump
Дата
Msg-id d3705b2a-8b4f-b1e0-6585-466766070e48@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] mild modification to pg_dump  (Scott Mead <scottm@openscg.com>)
Ответы Re: [GENERAL] mild modification to pg_dump  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
Thank you, Scott.
That's happening me because incomplete docs reading.
Truly, I'm catched in a very big app, so I have no time to read all the docs.


On 17/11/17 18:31, Scott Mead wrote:

On Fri, Nov 17, 2017 at 4:06 PM, marcelo <marcelo.nicolet@gmail.com> wrote:
I need to "emulate" the pg_dump code because the password prompt. Years ago I write a program (for the QnX environment) that catched some prompt and emulates the standard input. I don't like to do that again.

pg_dump can use an environment variable "PGPASSWORD" upon execution (actually, all libpq programs can).  You could have a wrapper that sets the environment variable and then executes pg_dump, this would get you around that prompt.  Similarly, you could use the .pgpass file.


--Scott

 


On 17/11/17 17:23, John R Pierce wrote:
On 11/17/2017 12:19 PM, marcelo wrote:
Sorry, I was not exact.
I don't need nor like to change pg_dump. Rather, based on pg_dump code, I need to develop a daemon which can receive a TCP message (from a privileged app) containing some elements: the database to dump, the user under which do that, and his password. (My apps are using that same data, of course, encripted to the common users).


I would just fork pg_dump to do the actual dump rather than try and incorporate its source code into your app.





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
--
Scott Mead
Sr. Architect
OpenSCG

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Mead
Дата:
Сообщение: Re: [GENERAL] mild modification to pg_dump
Следующее
От: marcelo
Дата:
Сообщение: Re: [GENERAL] mild modification to pg_dump