postgresqlHow do I install PostgreSQL on Ubuntu?
-
Download and install the PostgreSQL package:
sudo apt-get install postgresql postgresql-contrib -
Create a new PostgreSQL user:
sudo -u postgres createuser --interactiveThis command will prompt you to create a new user. Type in the name of the user you want to create.
-
Create a new database:
sudo -u postgres createdb [database name] -
Connect to the database:
psql -U [username] -d [database name] -
Set a password for the user:
\password [username] -
Grant privileges to the user:
GRANT ALL PRIVILEGES ON DATABASE [database name] TO [username]; -
Exit the PostgreSQL shell:
\q
Helpful links
More of Postgresql
- How can I troubleshoot zero damaged pages in PostgreSQL?
- How do I use PostgreSQL's XMIN and XMAX features?
- How can I monitor PostgreSQL performance using Zabbix?
- How can I integrate PostgreSQL with Yii2?
- How can I use PostgreSQL with YAML?
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How do I use PostgreSQL UNION to combine the results of two queries?
- How do I decide whether to use PostgreSQL VARCHAR or TEXT data types?
- How do I use PostgreSQL with Qt?
- How can I retrieve data from PostgreSQL for yesterday's date?
See more codes...