Remote access to a PostgreSQL Database (DigitalOcean)

Step by Step on how to remote into a PostgreSQL database.

Software used:
PgAdmin 4
PostgreSQL 9.5
DigitalOcean

List of commands used:

sudo apt update
apt install postgresql postgresql-contrib
update-rc.d postgresql enable
service postgresql startcd ../etc/postgresql/9.5/main

service postgresql restart

[sheriffcrandy]

Thank you brother! Just what I was looking for.
2:23 if anyone wants to secure their db with a password instead of using trust. Put 'password' there and then when you finish editing the file.

Log into your postgresql CLI in the terminal:
sudo -u postgres psql

Change password:
postgres=# ALTER USER postgres PASSWORD 'yourpassword';


logout:
\q

log back in:
psql -U postgres -h localhost

and enter your password
Password for user postgres: yourpassword

Then follow the steps in pg_admin and under the connection tab, enter 'yourpassword'

[MaxJacobson]

This video was a lifesaver! Thank-you!!!

[FabioSilva-optn]

Thank you! Smoothly added a new server thanks to you! Subscribed

[SemereTalegngeta]

How to like this video a million times. Thank you

[mrudavshukla]

Thanks a lot for making this video! It helped a lot.

[nextsin]

Thanks for making this video it really helped!

[lpaddikt]

Working on this for hours and finally saw your video, THANK YOU!

[ngidoc]

thank you brother, cz i'm new on postgresql.. your video is very useful!!

[deepakrkm]

Helped me ...Thank You very much Juan

[sathishkumarcisco]

Thanks @JuanNadal This is what i exactly needed. Thanks 1bn

[alexcomputleleco]

thanks a lot . Você é dera demais .. me ajudou muito abraço

[bullmirra]

Hi there! is there anyway to do it from other network, its only working for me if both pc(server) and other pc(user) are on the same network.

[nostrajara]

Hola Juan... I would like to know how to make this connection more secure. which doc I can follow?

[nostrajara]

thanks again... I am now accessing the database... but how can we set up PostgreSQL in a more secure way?

[ppakpahan]

do you have video how to install postgres on mac ?

[aleksatanasov]

How to connect your Kubernetes cluster to Digital Ocean Database cluster?

[saifalikhan]

what to use instead of trust for better security?

[risteltechnologies]

i need to access my database using public ip..how can we do that

[arzdrummer]

thanks! but I have a problem, when I stop using the database for a hour o more, the server failed, and I have to manually restart postgres since the droplet. Anyone knows how fix it?

[riwajchalise]

Incase its not working. It could be a fire wall issue


sudo ufw allow 5432/tcp;