To create a new user, exit the Postgres shell by executing: \q In this step, you will be creating a new user that will be used to access your Postgres database remotely. You will be shown something similar to this: :~$ psql You can access the Postgres shell by running: psql The server user will be switched from root to postgres. When the process is complete, switch the user to postgres to be able to execute Postgres commands with Postgres default user by running: su - postgres This will install Postgres along with its associated dependencies. When that is done, install Postgres by running: sudo apt-get install postgresql postgresql-contrib Next, update your server packages and dependencies by running: sudo apt-get update Then input your relevant user password or SSH key password if any. Note: server_user is your server user you would like to log in with server_ip is the IP address of your server The first thing to do is SSH into your server by running: ssh _ip In this step, you will be installing Postgres on your server. An Ubuntu server, you can quickly provision one from DigitalOcean or any cloud provider.Familiarity with the command line interface.This article setup will allow Postgres connection from any IP address and will not cover specific/authorized IP connection. In this article, we will be learning how to set up a remote Postgres database server to use for your projects. It is highly scalable and widely popular. Postgres is a powerful relational database management system, it can handle large workloads from a single machine to that of a data center. Setting up a remote Postgres database server on Ubuntu 18.04
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |