Connect to the default database with user postgres : sudo -u postgres psql template1   Set the password for user postgres, then exit psql (Ctrl-D) : ALTER USER postgres with encrypted password 'xxxxxxx';   Edit the pg_hba.conf file:sud...

Snippet

How to configure postgresql for the first time?

Introduction PostgreSQL 9.4 was released on 12/18/2014. More information about the release is available on the official PostgreSQL documentation.This article is written to provide an easy migration solution from PostgreSQL 9.3 to 9.4 for Debian s...

Snippet

Migrating from PostgreSQL 9.3 to 9.4

Connecting for the first time sudo -u postgres psql Set the password \password postgres Logging in psql -h localhost -p <port no> -U <username> <database name> Commands list \h help on SQL commands \? help on psql com...

Snippet

PostgreSQL psql console commands

Install the rbenv and Ruby dependencies sudo apt-get install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties l...

Snippet

Create and Deploy a Ruby on Rails 4 App with Postgre...