postgres-create-user

oc project kubernauts
 
podname=$(oc get pods | grep postgres-$(oc get dc postgres -o jsonpath='{.status.latestVersion}') | grep -v deploy | grep Running | awk '{print $1}')
oc rsh -c postgres $podname
 
OR
 
oc get pods | grep postgres
oc exec -it postgres-pod-name bash
 
#Please change <user> to your desired name
POSTGRESQL_USER=<user>
POSTGRESQL_DATABASE=<user>
POSTGRESQL_PASSWORD=<user>
 
 
createuser $POSTGRESQL_USER ;
createdb --owner=$POSTGRESQL_USER $POSTGRESQL_DATABASE ;
psql --command "ALTER USER \"${POSTGRESQL_USER}\" WITH ENCRYPTED PASSWORD '${POSTGRESQL_PASSWORD}';"