public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bo Peng <[email protected]>
To: zam bak <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: pg_enc --input-file ability to read from stdin
Date: Thu, 19 Feb 2026 00:39:12 +0000
Message-ID: <TYWP286MB2633D4F816346B87BA1435F6F26BA@TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAEy4EGV7+UEkDmn4CmO3hcTXnbZYXqkk5tXqDYORs8oPAyqFGw@mail.gmail.com>
References: <CAEy4EGV7+UEkDmn4CmO3hcTXnbZYXqkk5tXqDYORs8oPAyqFGw@mail.gmail.com>

Hi,

Could you try using "--input-file /dev/stdin"?

For example:
cat <<'EOF' | pg_enc --update-pass   --config-file etc/pgpool.conf   --input-file /dev/stdin
username1:secretpassword1
username2:secretpassword2
EOF

---
Bo Peng <[email protected]>
SRA OSS K.K.
URL: https://www.sraoss.co.jp/


________________________________________
差出人: 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: <TYWP286MB2633D4F816346B87BA1435F6F26BA@TYWP286MB2633.JPNP286.PROD.OUTLOOK.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