![]() ![]() Uncomment it and replace localhost with * so that it looks like this: listen_addresses = '*' Locate this line: #listen_addresses = 'localhost' (it should be under the ‘connections and authentication’ section). Let’s configure it to listen on all IP addresses available on the server and allow connections from remote IPs.Įdit the main PostgreSQL configuration file: vi /etc/postgresql/11/main/nf In order to start the postgreSQL service, use the following command: sudo systemctl start rviceīy default, PostgreSQL is listening on localhost only. Now we can install PostgreSQL 11 using the following command: sudo apt-get install postgresql-11 Then fetch the metadata from the newly created repository: sudo apt update Import the repository signing key: cd /optĪdd the repository to the server: sudo sh -c 'echo "deb $(lsb_release -sc)-pgdg main" > /etc/apt//postgresql.list' Install the required packages: sudo apt install wget ca-certificates We can do this by running the following commands: sudo apt-get update sudo apt-get upgrade Install PostgreSQL 11 Update OS packagesīefore we can start with the installation, we have to make sure that all Ubuntu OS packages installed on the server are up to date. To connect to the server via SSH as the root user, use the following command: ssh _ADDRESS -p PORT_NUMBERĪnd replace IP_ADDRESS and PORT_NUMBER with the actual server IP address and SSH port number. Other performance improvements, like command line improvements, improved statistics and more…. ![]() Just-in-Time (JIT) compilation of SQL Statements.Enhanced Capabilities for Query Parallelism which allows faster query execution.It comes packed with several advanced features and enhancements which include: The latest version of PostgreSQL, PostgreSQL 11, focuses on performance improvements. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |