Run a Postgres Database for Free in Google Cloud!

Learn how to run a Postgres Database in Google Cloud for free using a Virtual Machine in Compute Engine. In this video I show how to run the database using Docker, making it quick and easy to stand up the database.

This is intended only for small test projects or proof of concepts. Anything bigger should use Cloud SQL or a much larger VM.

Be sure to always check Google Cloud's Free tier docs to make sure nothing has changed and the VM is still free!

Follow me on social media!

[lkym]

Thank you so much, man. I used your video to host my first ever Docker container for a job interview challenge. Hopefully they'll think it's pretty cool!

[steve]

You might consider a playlist series "GCP for beginner", it's difficult to find any decent content to learn GCP as a beginner. Thanks for this video.

[yasin]

God Bless you sir! I've been trying to do it for 4 days. I did it thanks to you! Thank you a lot :)

[packalacky]

Thank you. For reference, the order in which you type the docker flag commands is important, ie putting the port after postgres will throw an error

[vmdcortes]

Hey, thanks for that, this is pretty useful, specially to do POC and stuff. Thanks again!

[faisalahamedrahat]

Can i run other containers as well, alongside the PostgreSQL container. Like node app, redis etc.?....

What would you recommend for production?

[YukzGaming]

What is the reason why Its not good for production?

[Glorpin]

After stopping and starting my VM instance, i get the "Connection to refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."
Was working fine before I stopped my instance last night, any solutions?
Edit: If i setup a new docker container it allows the connection through. Do I have to setup a new container everytime?

[erreib]

Thanks so much for this tutorial. I've created the 5432 firewall rule, added the appropriate network tag to the VM, and started the postgres docker with port 5432 forwarded from the docker to the vm. The connection times out whenever I try to connect. Do you have any suggestions for where I should start troubleshooting?

[diaconescutiberiu]

I did everything listed in the video, but i cannot connect to the db via dbeaver client (i'm getting request time out).
I tried checking stuff with chatgpt (all settings are correct, i can ping the external ip, i can connect to the db via GC's shell .. but not from dbeaver. I'm on Mac (drivers were installed). I'm stuck

[oliverlarsen]

Hey sir.

I've had my database up and running for 4 days now i think.
When i go to billing it says it has costed me 19 usd now.

Am i doing anything wrong?

[ВладиславКоновалов-сс]

It works! Thanks. But i have an issue. Google cloud has blocked my postgres db by two times :( They've said that my project doing crypto mining.
I've tried to do like in a video

[River-iwog]

Why did you make boot disk 20GB? Why not the bare minimum or the maximum?

[danielvega]

Is it possible to do all of this same process but with mySQL?

[DARREN_]

getting this error when i try to connect

Connection to refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Connection refused: connect
Connection refused: connect

[VastIllumination]

Great video! So helpful worked right away.

[NextGenSellPOS]

postgres-db:~$ sudo apt-get install lab-release
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package lab-release

I cant find lab-release. please help . and also please share the commands that you did afterwards

[kubwimanapatrick]

Hey... How can I use the this IP address to connect with a backend on on my laptop ... I want to set this up in the .env and use the remote postgres database

[KerptacularGaming]

Will I be charged for the external ip address?