pg_enc - AES256 password encryption utility

pg_enc AES256 password encryption utility.

       Here is an example output:

               pg_enc -p
               db password: [your password]

       or

              ./pg_enc foo
              trying to read key from file /home/pgpool/.pgpoolkey

              jglid1QRgiCl/vfhHUDyVA==
              pool_passwd string: AESjglid1QRgiCl/vfhHUDyVA==

       pg_enc can be used for pool_passwd passwords with:

               pg_enc -m -f /path/to/pgpool.conf -u username -p
               db password: [your password]

       which will add an entry for username with the password given.

       To avoid password prompt or password in command parameter, pg_enc can read user name:password pairs from
       file. It will add all user names and encrypted password to pool_passwd authentication file.

               $ cat users.txt
               username1:secretpassword1
               username2:secretpassword2

               $ pg_enc -m -f /path/to/pgpool.conf -i users.txt
               trying to read key from file /home/pgpool/.pgpoolkey
               trying to read user:password pairs from file users.text

               $ cat /path/to/pool_passwd
               username1:AESrx5QdpGyW/+4CB80KWtwhg==
               username2:AESUAdohy7nCUhWliRI9WiYQA==

pgpool-II 4.6.0                                       2023                                             PG_ENC(1)

       pg_enc - AES256 password encryption utility

-kKEY_FILE--key-file=KEY_FILE
           Set the path to the encryption key file. Default is the .pgpoolkey file located in the users home
           directory, which can be overridden by the environment variable PGPOOLKEYFILE.

       -KENCRYPTION_KEY--enc-key=ENCRYPTION_KEY
           Encryption key to be used for encrypting database passwords.

       -fCONFIG_FILE--config-file=CONFIG_FILE
           Specifies the pgpool.conf file.

       -iINPUT_FILE--input-file=INPUT_FILE
           Specifies file containing username and password pairs.

       -p--prompt
           Prompt for database password using standard input.

       -P--prompt-for-key
           Prompt for encryption key using standard input.

       -m--update-pass
           Create encrypted password entry in the pool_passwd file.

       -uyour_username--username=your_username
           Creates the pool_passwd entry for the database user called your_username.

       -h--help
           Prints the help for pg_enc.

           Note

           If you are providing the password as an argument to pg_enc and the password contains a "$" character,
           you must escape it.

           For example, if you want to use "ABC$123" as password,

               pg_enc -m -f /path/to/pgpool.conf -u username ABC\$123

pg_enc [option...] -ppg_enc [option...] password