Discussion8Replies2483Views VITHIYAS Member since 2007 2 posts Virtusa Corp. Posted: 4 years agoLast activity: 3 years 4 months ago Closed New Pega 7.1.9 PVS database connection detailsPlease 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. Pega Academy ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion. Posted: 4 years agoRATHW PEGA replied to VITHIYASDatabase 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 Posted: 4 years agoDamien PEGA replied to VITHIYASHi, 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 0.0.0.0/0 trust /etc/init.d/postgresql restart Damien Posted: 3 years agoPrasannaK5695 Computer Science Corporation replied to DamienThanks 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. Posted: 3 years agoSandeepKumarP_Incess Incessant Technologies replied to PrasannaK5695Your file locations and comments are very helpful @Prasanna Now, I am able to connect to the DB using PGAdmin Thanks Sandeep P V Posted: 4 years agoVITHIYAS Virtusa Corp. replied to VITHIYASThanks 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. Posted: 3 years agoMandarK6 Infosys replied to VITHIYASwhen 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 "192.168.2.29" and accepting TCP/IP connections on port 9080? can anyone help me with exact steps to connect to database for VM system? Posted: 3 years agopedel PEGA replied to VITHIYASTomcat'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. Posted: 3 years agoGBG00001 Cognizant replied to pedelI 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'.