Discussion8Replies2525Views×Close popoverVithiyashankar Selvaratnam (VITHIYAS) Virtusa Corp. Virtusa Corp. US View ProfileSend Message VITHIYAS Member since 2007 2 posts Virtusa Corp. Posted: February 24, 2016Last activity: May 14, 2017Posted: 24 Feb 2016 3:27 ESTLast activity: 14 May 2017 19:23 EDT 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: 5 years agoPosted: 24 Feb 2016 10:44 EST×Close popoverBill Rathert (rathw) PEGA Principal Instructor Pegasystems Inc. US View ProfileSend Messagerathw 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: 5 years agoPosted: 24 Feb 2016 10:49 EST×Close popoverDamien Renier (Damien) PEGA Principal Instructor Pegasystems Inc. GB View ProfileSend MessageDamien 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 agoPosted: 14 Apr 2017 9:25 EDT×Close popoverPrasanna Kumar (PrasannaK5695) Computer Science Corporation Computer Science Corporation IN View ProfileSend MessagePrasannaK5695 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 agoPosted: 25 Apr 2017 5:43 EDT×Close popoverVenkata Sandeep Kumar Pamidamarri (SandeepKumarP_Incess) Incessant Technologies Senior Technical Lead Incessant Technologies AU View ProfileSend MessageSandeepKumarP_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: 5 years agoPosted: 24 Feb 2016 17:04 EST×Close popoverVithiyashankar Selvaratnam (VITHIYAS) Virtusa Corp. Virtusa Corp. US View ProfileSend MessageVITHIYAS 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: 4 years agoPosted: 28 Oct 2016 4:23 EDT×Close popoverMandar Kulkarni (MandarK6) Infosys Infosys US View ProfileSend MessageMandarK6 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: 4 years agoPosted: 31 Oct 2016 8:37 EDT×Close popoverLee Pederson (pedel) PEGA Principal Instructor Pegasystems Inc. US View ProfileSend Messagepedel 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 agoPosted: 14 May 2017 19:23 EDT×Close popoverGuruprasad Basave Gowda (GBG00001) Cognizant Cognizant US View ProfileSend MessageGBG00001 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'.