R&D to figure out a way to automate prerequisite steps

[salman-bokhari]

Since prerequisite steps are a little time consuming, we're trying to figure out a way to automate the prerequisite steps Prerequisite steps we're aiming to automate are:

• Installation packages such as openssh-server, git, ansible, python3
• Creating of postgres user and giving it passwordless access
• Creating ssh keypair using ssh-keygen and creating ssh paswordless connection using ssh-copy-id

[salman-bokhari]

One of the solutions we opt for is to create a python script that creates ssh-keypair and then creates passwordless access from pgpool machine to primary and standby nodes. This same script could install all dependencies such as git, ansible, python3 on remote servers. This same script could create postgres user and give it passwordless sudo access.

There would be two limitations to this approach:

• openssh-server would need to exist on all nodes
• passwords along with IPs must be stored somewhere before executing script which could be a security hazard