

Template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + Postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |


Name | Owner | Encoding | Collate | Ctype | Access privileges – To list all the databaes on your PostgreSQL database server just run one of the following commands: postgres=# \list – To change the password of postgres role you can use: postgres=# \password postgres You are connected to database "postgres" as user "postgres" via socket in "/var/run/postgresql" at port "5432". – To check log info use the below comand: postgres=# \conninfo – To connect to the PostgreSQL database server, use the following commands: ~# su -l postgres – After installing PostgreSQL 11 database server, by default PostgreSQL, will create a system account user named postgres with role postgres. – The below commands can be used to stop, start, enable and check its status Step 2: Install PostgreSQL # sudo apt-get update – Import the repository signing key, and update the package lists # wget -quiet -O - | sudo apt-key add. – Add PostgreSQL apt repository # sudo sh -c 'echo "deb $(lsb_release -sc)-pgdg main" > /etc/apt//PostgreSQL.list' In this article, we are going to show you how to install PostgreSQL 11 database on Ubuntu 18.04 LTS or Ubuntu 16.04 LTS. Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data types, aggregate functions, data type conversion character, and other various database objects through the SQL function. PostgreSQLis a powerful, open source object-relational database system ( ORDBMS ).
