Activities

February 2020
M T W T F S S
« Apr    
 12
3456789
10111213141516
17181920212223
242526272829  

PostgreSQL installation, Configuration and Administration

PostgreSQL is an open source database released under the PostgreSQL license. This license allows for the free use and distribution of the PostgreSQL software for any reason. After few years back, I got a chance to setup a PostgreSQL server (one enterprise-class open source database) for an upcoming Rails project. I had worked with PostgreSQL7 […]

Useful PostgreSQL Commands

This scripts will create postgres database with specified owner and resore a sql dump in to it

#The super user postgres login along woth the password ‘admin’ in psql console

$psql -h localhost -p 5432 <postgres> “admin”

#creating a database named ‘testdb’

postgres=# CREATE USER testuser;

postgres=# ALTER USER testuser PASSWORD ‘letmein’;

#create a database […]