PostgreSQL database Password management
Follow the procedures given below to manage PostgreSQL database passwords on a zLinux and AIX platform.
Reset PostgreSQL Database connection password procedure using old password
For Connect:Direct Web Services v6.0.0.5 users running zLinux/AIX platform, follow the steps
given below to reset the PostgreSQL password to a new value.
- Connect to the instance where PostgreSQL is installed.
- Login as a PostgreSQL user with root privileges that is,
su – postgres
- Add the following line to the
pg_hba.conf
file to allow a user on the system to connect to local PostgreSQL database.host all postgres 127.0.0.1/32 trust
- Enter the current password used to connect to the PostgreSQL
database.
PGPASSWORD=<current password>
- Issue the following command to connect to the PostgreSQL
database.
./psql -U postgres -p <PostgreSQL PORT>
- Issue the following command to set the password to a new
value.
ALTER USER <postgres_user> WITH PASSWORD <’new_password’>;
- Issue the following command to stop the Web
Services.
./stopWebserviceZLinux.sh in /<Installation_Directory>/bin/ ./stopWebserviceAIX.sh in /<Installation_Directory>/bin/
- Go to /<Installation_Directory>/mftws/BOOT-INF/classes and invoke the
following command to apply password changes to Web
services.
java -jar PasswordEncryption-0.1.jar <new_password>
- Launch Connect:Direct Web Services using the following
utility:
This utility is available in the /<Installation_Directory>/bin/ directory../startWebserviceZLinux.sh ./startWebserviceAIX.sh
Reset PostgreSQL database connection in case of forgotten password
- Connect to the instance where PostgreSQL is installed.
- Login as a PostgreSQL user with root privileges that is,
su – postgres
.- Go to the /var/<FolderName_where_database_initialised > directory where PostgreSQL database is installed.
- Take a backup of the
pg_hba.conf file
that controls the client authentication. Create a backup file with name such as,pg_hbkp.conf
file.
- Add the following line to the
pg_hba.conf
file to allow a user on the system to connect to local PostgreSQL database.host all postgres 127.0.0.1/32 trust
- Go to the bin directory and issue the following commands to restart PostgreSQL
server:
run ./pg_ctl -m fast -D /var/< FolderName_where_database_initialised> stop run ./pg_ctl -D /var/< FolderName_where_database_initialised> start
- Issue the following command to connect to the PostgreSQL database
server:
./psql -U postgres -p <PostgreSQL PORT>
- Issue the following command to change the password of the PostgreSQL
server:
ALTER USER postgres WITH PASSWORD 'very_secure_password';
- Restore the
pg_hba.conf
file, restart the PostgreSQL server, and connect to the PostgreSQL database server with new password. - Invoke
stopWebserviceZLinux.sh/stopWebserviceAIX.sh
utility available in the /<Installation_Directory>/bin/ to stop the Web Services on the machine where it is currently installed. - Go to /<Installation_Directory>/mftws/BOOT-INF/classes and invoke the
following command to apply password changes to Web
services.
java -jar PasswordEncryption-0.1.jar <new_password>
- Launch Connect:Direct Web Services using the following
utility:
./startWebserviceZLinux.sh ./startWebserviceAIX.sh
This utility is available in the /<Installation_Directory>/bin/ directory.