Friday 12 August 2016

Solution for Arrow keys to function properly in sqlplus on Ubuntu

The arrow keys were not functioning properly in Sqlplus in Ubuntu terminal. I installed rlwrap and it worked for me by

rlwrap sqlplus

Monday 1 August 2016

Solution to PostgreSQL not starting

I installed postgresql9.5 on ubuntu 16.04, using "apt-get install" everything was running fine, until I installed MySQL.
PostgreSQL was not starting, in-spite of making all the required changes n pg_hba.conf and postgresql.cof files.

Finally I found the following solution :

1-sudo mkdir -p /usr/local/pgsql/data
2-s-udo chown -R postgres:postgres /usr/local/pgsql/

(Login as postgresql user)


3-sudo -u postgres -i
4-cd /usr/lib/postgresql/9.5/bin
5-./initdb -D /usr/local/pgsql/data
6-./postgres -D /usr/local/pgsql/data/ (Keep it running)


Thanks to https://ubuntuforums.org/showthread.php?t=869080