postgresql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| postgresql [2026/06/14 12:35] – [Installation] jhagstrand | postgresql [2026/06/14 12:36] (current) – [Installation] jhagstrand | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ===== Installation ===== | ===== Installation ===== | ||
| - | <pre> | ||
| - | sudo apt update | ||
| - | sudo apt install postgresql postgresql-contrib postgis postgresql-16-postgis-3 | ||
| - | sudo -u postgres psql | + | sudo apt update |
| - | CREATE USER devuser WITH PASSWORD ' | + | sudo apt install postgresql postgresql-contrib postgis postgresql-16-postgis-3 |
| - | CREATE DATABASE myapp OWNER devuser; | + | |
| - | \c myapp | + | |
| - | CREATE EXTENSION postgis; | + | CREATE USER devuser WITH PASSWORD ' |
| + | CREATE DATABASE myapp OWNER devuser; | ||
| + | \c myapp | ||
| + | CREATE EXTENSION postgis; | ||
| - | < | ||
postgresql.1781454937.txt.gz · Last modified: 2026/06/14 12:35 by jhagstrand