Postgresql Installation and management basics

PostgreSQL or simply postgres is the most advanced, SQL-compliant and open-source objective-RDBMS. Compared to other RDBMSs, PostgreSQL differs itself with its support for reliable transactions, i.e. Atomicity, Consistency, Isolation, Durability (ACID).In This Article, you will learn how to Install, Connect and Manage a postgres database.

Installing & Managing postgresql Database in Debian:

sudo apt-get install postgresql-9.5 libpq-dev
# connecting to databasesudo su
su postgres -c "psql"
# change postgres user passwordALTER USER postgres PASSWORD 'our-new-password';
\q
# modify pg_hba.conf to connect to database with password only.local all postgres peer
local all all peer
change peer to md5 and restart postgresql for changes to take affect.# connecting to database psql -U postgres
# create new database
CREATE DATABASE gondor;
# create new user
CREATE USER elessar WITH PASSWORD '<some-password>'
# grant the user permission to Database
GRANT ALL PRIVILEGES ON DATABASE gondor TO elessar;
# switch to database
connect <database-name>

Using Docker Image:

Installing Docker:

wget -qO- https://get.docker.com/ | s
docker run --name some-postgres -e POSTGRES_PASSWORD=<password-postgres-user> -d postgres
apt-get install postgresql-client-common postgresql-client-9.5
psql -U postgres -h <docker-ip>

The article was originally published at MicroPyramid blog.

Python, Django, Android and IOS, reactjs, react-native, AWS, Salesforce consulting & development company