Activities

September 2019
M T W T F S S
« Apr    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

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 […]