Re: mild modification to pg_dump

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 
> <mailto: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.
>
> https://www.postgresql.org/docs/9.5/static/libpq-envars.html
> https://www.postgresql.org/docs/9.5/static/libpq-pgpass.html
>
> --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
>     <mailto:pgsql-general@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-general
>     <http://www.postgresql.org/mailpref/pgsql-general>
>
>
>
>
> -- 
> --
> Scott Mead
> Sr. Architect
> /OpenSCG <http://openscg.com>/
> http://openscg.com