New Pega 7.1.9 PVS database connection details
Please kindly give the database connection details (user name/password, other connection details) for the new Pega 7.1.9 PVS, used for the Lead Systems Architect 7.1 course.
Pegasystems Inc.
US
Database Information
Pega Academy recommends PGAdmin (opens in a new window) as the preferred tool for database administration.
- Database: PostgreSQL 9.2
- User Name: postgres
- Password: postgres
Bill Rathert
Pega Academy Support
Ai4Process
GB
Hi,
On the top of these information that you can find on http://IP_ADDRESS:9080
You need to tell the DB to listen to your address and grant access.
- login as root/install
- vi /etc/postgresql/9.1/main/postgresql.conf
- Change the line from listen_addresses=’localhost’ to listen_addresses=’*’ (uncomment as well)
- vi /etc/postgresql/9.1/main/pg_hba.conf
- add a line under: local all postgres peer
- host all all Proprietary information hidden/0 trust
- add a line under: local all postgres peer
- /etc/init.d/postgresql restart
Damien
Computer Science Corporation
IN
Thanks Damien, I was searching for it and finally :) !!! Actually it is quite helpful/needed for every one who want to see end to end picture.
Just few correction as it has worked for different configurations for me.
Conf files are located here :
1. /var/lib/pgsql/9.3/data/postgresql.conf
2. /var/lib/pgsql/9.3/data/pg_hba.conf
And for db details tomcat context.xml file under /opt/tomcat/conf, finally the user/uname/password is as simple as pega/pega/pega to access all the schema.
Cheers!!! I am connected now.
Thanks Again Damien.
Toyota Financial Services
AU
Your file locations and comments are very helpful @Prasanna
Now, I am able to connect to the DB using PGAdmin
Thanks
Sandeep P V
Virtusa Corp.
US
Thanks Bill and Damien.
To edit the conf files, I used the following:
vi /var/lib/pgsql/9.3/data/postgresql.conf
vi /var/lib/pgsql/9.3/data/pg_hba.conf
Now I can connect to the DB.
Infosys
US
when i am trying to use comman to edit the postgresql.conf file, it says No such file or directory.
Also i tried making above changes in the file directly. But i am not able to connect to mentioned database and getting below error:
could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host " Proprietary information hidden" and accepting TCP/IP connections on port 9080?
can anyone help me with exact steps to connect to database for VM system?
Pegasystems Inc.
US
Tomcat's port is 9080. Tomcat is a web server.
Postgres is a database so uses a different port.
To find information about any database, not just Postgres, that Tomcat configures as a Resource for other webapps, such as prweb, to use look at: /opt/tomcat/conf/context.xml.
Cognizant
US
I have modified the below items and restarted the postgresql.
1. /var/lib/pgsql/9.3/data/postgresql.conf
2. /var/lib/pgsql/9.3/data/pg_hba.conf
However when i try to connect using pgAdmin, i am getting 'password authentication failed for user "postgres' .
I checked the 'Context.XML' and i don't see the db details. Can you let me know what to update in 'Context.xml'.