Showing posts from September, 2013

Postgres - pg_hba.conf configuration

pg_hba.conf control the client authentication for Postgres Database.


So, if you encounter error message such as

FATAL: no pg_hba.conf entry for host "fe80::d12f:1a6e:1234:a9cd%20", user "postgres", database "postgres", SSL off
That simply mean your pg_hba.conf does not allow host name fe80::d12f:1a6e:1234:a9cd and user postgres to connect to database name postgres
To allow that, you need to add an entry to pg_hba.conf

Before doing that fe80::d12f:1a6e:1234:a9cd%20is a IPv6 address. Furthermore, fe80 is a link local prefix. Link local address is automatically assigned when no static IP address is assigned to the interface. This is equivalent to for IPv4. You may notice that there is a %20 after the IPv6 address. In general, IPv6 zone format is Address%ZoneID. So, the above address zone id is 20 and this is use to identify the network interface for the address when you have…

Tomcat - Configuration Parameters of Installed Tomcat Windows Service

After working with Tomcat for so many years, I had been either manually updating or reinstalling the Windows service to get my Java parameters updated with Tomcat.

Up till now, I finally realized that there is a tomcatXw.exe in the Tomcat bin directory that allow your to update Tomcat parameters. X refer to the version of Tomcat you had installed (eg, Tomcat 6 has tomcat6w.exe)

You can do the following with respect to Tomcat 6

1. Locate your Tomcat installation folder and go into the respective bin folder. Inside the bin folder, you should see tomcat6w.exe

2. Double click on tomcat6w.exe to open the properties interface

3. Stop the tomcat server if it is running at the General tab

4. Update the parameters that you want to changes. For example, go to Java tab to change Java parameters

5. Click Apply and restart Tomcat service.