Changing the Repository Password

After installation you might periodically need to change your TDV or Business Directory repository password.

In these instructions, <install_dir> means <BD_install_dir> or <TDV_install_dir>.

To change the repository password

1. Stop the repository.

2. Locate and open the ph_hba.conf file. The file is typically at:

<install_dir>\repository\data\pg_hba.conf

3. Find and change all lines with "password" to "trust" for the METHOD column. For example:

TYPE DATABASE USER ADDRESS METHOD

"local" is for Unix domain socket connections only

local all all password

IPv4 local connections:

host all all 127.0.0.1/32 password

IPv6 local connections:

host all all ::1/128 password

4. Start the repository. For example, on Windows:

composite.bat repo start

5. Login to the PostgreSQL database using one of the following commands:

Platform	Command	Notes
Windows	./bin/psql -hlocalhost -p9508 -Uroot -dpostgres
UNIX	cd <install_dir>/repository; export LD_LIBRARY_PATH=<install_dir>/repository/lib; ./bin/psql -hlocalhost -p9508 -Uroot -dpostgres	Use SHLIB for HPUX and LIBPATH for AIX platforms instead of LD_LIBRARY_PATH, which is only for Linux platforms.

6. Run the psql ALTER USER command.

postgres=# ALTER USER root with password '<NEW_DBA_PASSWORD>';

postgres=# \q

7. Stop the repository.

8. Locate and open the ph_hba.conf file. The file is typically at:

<install_dir>\repository\data\pg_hba.conf

9. Find and change all lines with "trust" to "password"for the METHOD column.

10. Start the repository.

11. Log in to the PostgreSQL database with the new password.