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
|
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: |
|
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
|
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. |