If you want a specific version, use postgresql-12 or similar instead of postgresql: sudo apt -y install postgresql-12 Verify PostgreSQL 12 Installation on Ubuntu Install the latest version of PostgreSQL. Update the package lists apt a.k.a Advanced Packaging Tool by running the following command sudo apt update Import the repository signing key by running the following command wget -quiet -O - | sudo apt-key add. Run the following command to create the file repository configuration: sudo sh -c 'echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list' Once you are able to successfully access the terminal, run the following commands to install postgresql-12. Or you should be able to SSH to the Ubuntu OS.įor production facing deployments the GUI is not enabled as it is not required, so you at least should be able to SSH in to the box as a SUDO user. Knowledge of shell scripting command (not mandatory)įirst of all you need to be able to access the OS either via GUI by logging in as a SUDO user.SSH access to Command Terminal via Putty of the Ubuntu OS in case of remote VM.User with sudo privileges to access Ubuntu OS.Connect and Query to PostgreSQL Database from Python.Consuming the PostgreSQL server database in to Python3 Application.Grant User all the privileges on Database in PostgreSQL server.Create an User role in PostgreSQL Server.Create a database in PostgreSQL Server.Configure PostgreSQL 12 Database Server on Ubuntu.Verify PostgreSQL 12 Installation on Ubuntu.Install PostgreSQL On Ubuntu – TutLinks Table of Contents We will cover installation, configuration and create a user and grant privileges on a newly created database. In this tutorial, we will see how to install PostgreSQL 12 on Ubuntu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |