postgresql setup - This Dot Life

How to enable remote access to PostgreSQL database server

Once you have your PostgreSQL database server installed, up and running, due to security reasons by default remote access to connect with your database instance is disabled. If you try connecting with your PostgreSQL database server from client machine, you will encounter error. could not connect to server: Connection refused (0x0000274D/10061) Following screenshot displays error I received when trying to connect from a windows client machine using pgAdmin III Following below steps you will be able to enabled remote access to PostgreSQL database server. Before even we start it is important to know that there are two configuration files (and others) which control how your database server works. This configuration files contains settings that needs to be tweaked or changed to make your database instance run as per your needs. postgresql.conf (Used to set various parameters that affect the database) pg_hba.conf (Used to control client authentication, » Read more

Jsinh 03 January 2015

How To Install and Use PostgreSQL on Ubuntu 14.04

Ok so you know the blah blah of how PostgreSQL is awesome relation database (RDBMS) and great for reliable transactions, good for so many things, lots of enterprise features and gives concurrency without read locks and stuffs. If you are not aware of this RDBMS, then I would recommend you search for advantages of using PostgreSQL and what is served in its plate. PostgreSQL is pronounced mostly as "post gray sequel" or "post ge are ee as que el" (I am sounding very dramatic here). Back to the post now, Fire up your Ubuntu 14.04 to start the installation. It would almost follow the same for most of the Ubuntu flavors out there. First step - you know the drill :) sudo apt-get update Next step: sudo apt-get install postgresql postgresql-contrib postgresql installs the core PostgreSQL engine and RDBMS around which everything else is build. The » Read more

Jsinh 02 January 2015