Discussion 8 Replies 2528 Views × Close popover Vithiyashankar Selvaratnam (VITHIYAS) Virtusa Corp. Virtusa Corp. US View Profile Send Message VITHIYAS Member since 2007 2 posts Virtusa Corp. Posted: February 24, 2016 Last activity: May 14, 2017 Posted: 24 Feb 2016 3:27 EST Last activity: 14 May 2017 19:23 EDT Closed 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. Pega Academy × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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: 5 years ago Posted: 24 Feb 2016 10:44 EST × Close popover Bill Rathert (rathw) PEGA Global Tech Enablement, Principal Instructor Pegasystems Inc. US View Profile Send Message rathw PEGA replied to VITHIYAS 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 Posted: 5 years ago Posted: 24 Feb 2016 10:49 EST × Close popover Damien Renier (Damien) PEGA Global Tech Enablement, Principal Instructor Pegasystems Inc. GB View Profile Send Message Damien PEGA replied to VITHIYAS 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 0.0.0.0/0 trust /etc/init.d/postgresql restart Damien Posted: 4 years ago Posted: 14 Apr 2017 9:25 EDT × Close popover Prasanna Kumar (PrasannaK5695) Computer Science Corporation Computer Science Corporation IN View Profile Send Message PrasannaK5695 Computer Science Corporation replied to Damien 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. Posted: 4 years ago Posted: 25 Apr 2017 5:43 EDT × Close popover Venkata Sandeep Kumar Pamidamarri (SandeepKumarP_Incess) Incessant Technologies Senior Technical Lead Incessant Technologies AU View Profile Send Message SandeepKumarP_Incess Incessant Technologies replied to PrasannaK5695 Your file locations and comments are very helpful @Prasanna Now, I am able to connect to the DB using PGAdmin Thanks Sandeep P V Posted: 5 years ago Posted: 24 Feb 2016 17:04 EST × Close popover Vithiyashankar Selvaratnam (VITHIYAS) Virtusa Corp. Virtusa Corp. US View Profile Send Message VITHIYAS Virtusa Corp. replied to VITHIYAS 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. Posted: 4 years ago Posted: 28 Oct 2016 4:23 EDT × Close popover Mandar Kulkarni (MandarK6) Infosys Infosys US View Profile Send Message MandarK6 Infosys replied to VITHIYAS 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 "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: 4 years ago Posted: 31 Oct 2016 8:37 EDT × Close popover Lee Pederson (pedel) PEGA Global Tech Enablement, Principal Instructor - LSA Pegasystems Inc. US View Profile Send Message pedel PEGA replied to VITHIYAS 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. Posted: 3 years ago Posted: 14 May 2017 19:23 EDT × Close popover Guruprasad Basave Gowda (GBG00001) Cognizant Cognizant US View Profile Send Message GBG00001 Cognizant replied to pedel 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'.