Configure postgresql ubuntu server12/9/2023 ![]() ![]() You can also open the Postgres shell without switching accounts. Then enter the following command to open the interactive Postgres shell. You have to log on to that account to connect and access the working shell of the PostgreSQL server. The output will be similar as shown in the image below.īy default, PostgreSQL creates a user account postgres during the installation process. You can verify it using the following command. sudo apt install postgresql postgresql-contrib Step 2: Check the PostgreSQL serviceĪfter completing the installation, the PostgreSQL service should be active by default. Next, run this command to install the latest version of PostgreSQL along with a contrib package that provides additional tools and functionalities for PostgreSQL. It helps to get information about updated packages and their dependencies. ![]() Step 1: Install PostgreSQL on Ubuntuīefore getting started, update your package information using the below command. ![]() The following step-by-step guide uses Ubuntu 20.04 system to demonstrate the installation and configuration of PostgreSQL on Ubuntu. Prerequisitesįor this tutorial, you will need a Ubuntu system having a non-root user with sudo privileges. This tutorial will teach you how to install and set up PostgreSQL on the Ubuntu system. It is compatible with all major operating systems including Windows, Linux/UNIX, Mac OS, IRIX, Solaris, etc. It allows you to create your own data types, define custom functions, and write different programming language codes without recompiling your database. With over 30 years of active development, it has gained a solid reputation for its reliability, data integrity, extensibility, ACID compliance, and robust features. PostgreSQL is a free and open-source relational database management system that allows both SQL and JSON querying. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |