PostgreSQL: Difference between revisions

From Rixort Wiki
Jump to navigation Jump to search
(Created page with "== Links == * [https://wiki.postgresql.org/wiki/Don't_Do_This Don't Do This] - list of things not to do in PostgreSQL, with explanations.")
 
No edit summary
Line 1: Line 1:
== Ubuntu installation ==
Install PostgreSQL and its contrib package:
sudo apt install postgresql postgresql-contrib
Create a new user (with the same username as your Linux login):
sudo -u postgres createuser --interactive
Create a database:
createdb my_test_db
Connect via psql:
psql -d my_test_db
== Links ==
== Links ==


* [https://wiki.postgresql.org/wiki/Don't_Do_This Don't Do This] - list of things not to do in PostgreSQL, with explanations.
* [https://wiki.postgresql.org/wiki/Don't_Do_This Don't Do This] - list of things not to do in PostgreSQL, with explanations.

Revision as of 08:48, 6 January 2022

Ubuntu installation

Install PostgreSQL and its contrib package:

sudo apt install postgresql postgresql-contrib

Create a new user (with the same username as your Linux login):

sudo -u postgres createuser --interactive

Create a database:

createdb my_test_db

Connect via psql:

psql -d my_test_db

Links

  • Don't Do This - list of things not to do in PostgreSQL, with explanations.