PSQL process to connect databases XHQ, XHQCACHE and XHQHist in XHQ 6.0

XHQ 6.0 back end database was changed from ORACLE to POSTGRESQL. Below is the process to connecting the XHQ, XHQCACHE and XHQHIST databases in XHQ 6.0. 
Password used in below images is "XHQ99qhx!". (No double quotes.).

 Connecting XHQ Database through PSQL. 





Connecting XHQ Database through PSQL. 


Connecting XHQ Database through PSQL.  


 Connecting/Adding XHQ Database through PGADMIN4.

PGAdmin is a GUI tool used to manage POSTGRESQL databases. Below is the process to add XHQ database to PGADMIN. 
1. Below is Path for the PGADMIN in XHQ server, once after instillation. Double click on the ""PgAdmin4" which was highlighted in below image.



2. Double click had opened this page. 

3. We have to add XHQ database to PGADMIN. Below is the process. Right Click on "Servers" then mouse over on "create" then click on "Server...". 


4. Above process was opened the below popup. Here in General tab, give name as "xhq".




5. Then in Connection tab provide the details as below and click on save. 


6. Then we can see the database xhq under the Servers. Then extend the xhq to see the list of objects in it. 




 Connecting/Adding XHQCache Database through PGADMIN4.







Connecting/Adding XHQHist Database through PGADMIN4.



Comments

Post a Comment

Popular posts from this blog

How to connect postgresql database through ODBC driver in excel

Image
Postgresql has ODBC driver " psqlodbc " which will be used to connect to postgresql databases. In this post, we are connecting to postgresql from excel using ODBC driver.  Step1: Verifying the existing ODBC driver in windows (both 32 and 64 bit driver) for availability of postgresql driver.  32-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). 64-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text).  Step2: Checking the current postgresql server version, to get the corresponding psqlodbc driver. As per below screen shot, current version is " 10.10 ". i will try to get and install psqlodbc of 10.10 version. Step3: When check the psqlodbc driver ( https://www.postgresql.org/ftp/odbc/versions/msi/ ), i have found the, psqlodbc_10_3 is the last version that was a...
Read more

Postgresql System files and their uses

Image
The postmaster.opts File This postmaster.opts file sets the default invocation options for the postmaster program, which is the main PostgreSQL program. Typically, it will contain the full path to the postmaster program, a -D option to set the full path to the principal data directory, and optionally, a -i flag to enable network connections. The postmaster.opts options are listed in Table 11-5.  Table 11-5. postmaster Options Option   Description  -B          nbufs Sets the number of shared memory buffers to nbufs. -d           level Sets the level of debug information (level should be a number 1 through 5)               written to the server log. -D dir      Sets the database directory (/data) to dir. There is no default value. If no    ...
Read more