pg_enc --input-file ability to read from stdin

From: zam bak <zam6ak(at)gmail(dot)com>
To: pgpool-general(at)lists(dot)postgresql(dot)org
Subject: pg_enc --input-file ability to read from stdin
Date: 2026-02-17 16:36:58
Message-ID: CAEy4EGV7+UEkDmn4CmO3hcTXnbZYXqkk5tXqDYORs8oPAyqFGw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-general

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...

Responses

Browse pgpool-general by date

  From Date Subject
Next Message Bo Peng 2026-02-19 00:39:12 Re: pg_enc --input-file ability to read from stdin
Previous Message zam bak 2026-02-15 16:50:39 RPM packages for "aarch64" platform