Connecting

Login using postgres user

$ ssh -l postgres 200.34.22.75 [email protected]'s password: Linux localhost 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1 (2019-04-12) x86_64Copy

// Login as PostgreSQL superuser “postgres” on remote PostgreSQL server using ssh (Linux)

root@localhost:~# su - postgres Copy

// Login as PostgreSQL superuser “postgres” (Linux)

Enter postgres terminal

postgres@localhost:~$ psql psql (9.6.12)Type "help" for help.postgres=#Copy

// Enter PostgreSQL Command Line via “psql” client (psql)

Connect database

\c test You are now connected to database "test" as user "postgres".Copy

// Connect to a PostgreSQL database “test” as “postgres” user (psql)

Check psql client version

$ psql -V psql (PostgreSQL) 9.6.12 Copy

// Check psql client version (psql)

Check Postgres server version

select version(); version ----------------------------------------------------------------------------------------------------------- PostgreSQL 9.6.12 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit (1 row)Copy

// Check Postgres server version (SQL)