postgres

Learn how to install postgresql 9.4 on Ubuntu server

In this tutorial we will learn How to set user postgres password in postgresql 9.1 and force to prompt for password. When you freshly install Postgresql and after using command psql it will allow you to login into postgresql server without prompting or asking for password. Here we will first of all reset the password…

Show running process in postgres I mostly use the MySQL server and very much familiar with its commands and how it works. Today I was checking How to check the running process in Postgresql. In MySQL we use show processlist; command. In Postgresql,to show running process in postgres use below given command Step 1: Login…