psql

How Do I Connect To Local PostgreSQL?

by

How Do I Connect To Local PostgreSQL? psql. sudo –login –user=postgres. psql. sudo –login –user=postgres psql. How do I login as a different user in PostgreSQL? We will use this user credential to log in as another user in pgAdmin. CREATE ROLE mydev LOGIN PASSWORD ‘password’ SUPERUSER. Then, we use mydev to log in instead

How Do I Enable Remote Access To Postgresql Server?

by

How Do I Enable Remote Access To Postgresql Server? Connect to the PostgreSQL server via SSH. Get location of postgresql.conf file by executing the command (it should be something like /var/lib/pgsql/data/postgresql.conf ): … Open postgresql.conf file and add the following line to the end: … Get the location of pg_hba.conf file: Can’t connect to remote