F: #optraining --forum--postgresql

Hello again, now i will teach you how to install PostgreSQL in your debian OS.

But first i start with what PostgreSQL is and what's used for.
Relational databases are the cornerstone of data organization for a multitude of needs.
They power everything from online shopping to rocket launches.
A database that is both venerable but very much still in the game is PostgreSQL. PostgreSQL follows most of the SQL standard,

So now you have a background what is it used for, now lets us install it on your DEBIAN OS,
Open up terminal and
sudo apt-get update && sudo apt-get install postgresql postgresql-client
To check if the installation was successfully you can run "ps -ef | grep postgre"

now for accessing what you just installd you run
su - postgres
You now should be logged as postgres. To start the PostgreSQL console type "psql"

if you successful you get
"psql (9.4.2)
Type "help" for help.

postgres=#"

To exit the psql console just use the command \q.





BY LiTeRs50