Postgresql server connectivity configurations from other clients or servers

Problem: When i am trying to read the data of postgresql from other server (XHQ Connection Group), got the below error. To fix this i have done the below step. 

 Error Connecting to database FATAL : no pg_hba.conf entry for host"18.142.0.78", user"postgres", database"UNLSH_WB_COLLECTIONS". 


Solution: To fix this problem i have added below line under "# IPv4 local connections:" in "pg_hba.conf" file in postgresql server and also opened postgresql port "5432" at firewall level (both inbound and outbound). 

 host    all         all         52.77.217.218/24     trust
File "pg_hba.conf" will be available in postgresql data folder. To find the data folder, we have to run the sql command "SHOW data_directory;" in postgresql database.


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