Installing PostgreSQL under Debian and creating sample user and database

Published: 30 March 2018
on channel: Javed Akhtar

143

Installing PostgreSQL under Debian
First update your installation with(Make sure you are logged in as root)
apt-get update

then install PostgreSQL with the command bellow
apt-get install -y postgresql libpq-dev

to make the PostgreSQL start at system start use the command bellow
systemctl start postgresql
systemctl enable postgresql

to run first time without password
sudo -u postgres psql

To create a database
CREATE DATABASE netbox;

Now create a user "Replace the quoted text with password of your choice"
CREATE USER netbox WITH PASSWORD 'Your Password Here';

Grant the new user privilege for the database
GRANT ALL PRIVILEGES ON DATABASE netbox TO netbox;

to quit
\q

On this page of the site you can watch the video online Installing PostgreSQL under Debian and creating sample user and database with a duration of hours minute second in good quality, which was uploaded by the user Javed Akhtar 30 March 2018, share the link with friends and acquaintances, this video has already been watched 143 times on youtube and it was liked by 4 viewers. Enjoy your viewing!

4,705

151