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 do I use PostgreSQL and ZFS together?
- How do I use PostgreSQL ZonedDateTime to store date and time information?
- How can Zalando use PostgreSQL to improve its software development?
- How can I integrate PostgreSQL with Yii2?
- How can I extract the year from a date in PostgreSQL?
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How can I use PostgreSQL with YAML?
- How can I extract the year from a PostgreSQL timestamp?
See more codes...