public inbox for [email protected]
help / color / mirror / Atom feedFrom: zam bak <[email protected]>
To: Bo Peng <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: pg_enc --input-file ability to read from stdin
Date: Fri, 20 Feb 2026 19:23:32 -0500
Message-ID: <CAEy4EGWaBY-baKq3GBL+NFt7rVG_eFr9rZP00v5JG3ox6AfFtg@mail.gmail.com> (raw)
In-Reply-To: <TYWP286MB26336ABAF0DDD2A7DE072652F26BA@TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM>
References: <CAEy4EGV7+UEkDmn4CmO3hcTXnbZYXqkk5tXqDYORs8oPAyqFGw@mail.gmail.com>
<TYWP286MB26336ABAF0DDD2A7DE072652F26BA@TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM>
On Wed, Feb 18, 2026 at 9:21 PM Bo Peng <[email protected]> wrote:
>
> hi,
>
> > P.S.
> > Documentation also does not mention if colon ':' needs to be escaped
> > (and how) when password contains colon??
>
> As far as I understand, a colon ':' in the password does not need to be escaped.
> Could you clarify what kind of case you are referring to?
For the case where credentials are being read in from the file,
documentation states that the format should be
username1:secretpassword1
username2:secretpassword2
So I was wondering if the colon - if it is a part of the password has
to be escaped (because its also a separator between the username and
the password)
I did try this, for example:
username1:secret:password1
username2:secret:password2
...and it seems to work fine - is this expected? no escaping is needed?
>
> ________________________________________
> 差出人: zam bak <[email protected]>
> 送信: 2026 年 2 月 18 日 (水曜日) 1:36
> 宛先: [email protected] <[email protected]>
> 件名: pg_enc --input-file ability to read from stdin
>
>
> Hello
>
> Is it possible to pipe stdin output to pg_end --input-file option by
> using dash '-' as a placeholder for stdin?
> https://www.pgpool.net/docs/latest/en/html/pg-enc.html
>
> I tried both "echo" and "cat" and am not able to do it.
>
> Example 1:
> cat <<'EOF' | pg_enc --update-pass --key-file
> /etc/pgpool-II/.pgpoolkey --config-file /etc/pgpool-II/pgpool.conf
> --input-file -
> username1:secretpassword1
> username2:secretpassword2
> EOF
> trying to read key from file /etc/pgpool-II/.pgpoolkey
> trying to read username:password pairs from file -
> failed to open input_file "-" (No such file or directory)
>
> Example 2:
> echo '
> username1:secretpassword1
> username2:secretpassword2
> ' | pg_enc --update-pass --key-file /etc/pgpool-II/.pgpoolkey
> --config-file /etc/pgpool-II/pgpool.conf --input-file -
> trying to read key from file /etc/pgpool-II/.pgpoolkey
> trying to read username:password pairs from file -
> failed to open input_file "-" (No such file or directory)
>
>
> The reason for asking about this is:
> * to be able to use pg_enc in scripting setups
> * to be able to provide list of usernames/passwords without having to
> actually create a file
> * to be able to reduce escaping when autogenerated passwords contain
> special characters (by echoing literals)
>
>
> P.S.
> Documentation also does not mention if colon ':' needs to be escaped
> (and how) when password contains colon??
>
>
>
> Thanks
> Z...
>
>
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: pg_enc --input-file ability to read from stdin
In-Reply-To: <CAEy4EGWaBY-baKq3GBL+NFt7rVG_eFr9rZP00v5JG3ox6AfFtg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox