Run a Postgres Database for Free in Google Cloud!

Рет қаралды 26,358

Жыл бұрын

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!
GCP free tier docs: cloud.google.com/free/docs/fr...
Docker Engine install docs: docs.docker.com/engine/instal...
Follow me on social media!
Twitter: / scriptbytesio
Instagram: / scriptbytes

Пікірлер: 55

@yasin5603 Жыл бұрын

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

@scriptbytes Жыл бұрын

You’re welcome! I’m glad it helped!

@VastIllumination 24 күн бұрын

Great video! So helpful worked right away.

@lkym2481 10 ай бұрын

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!

@scriptbytes 10 ай бұрын

Oh that’s awesome! I’m glad this helped. Good luck, I hope you get the job!

@pedromoreira1311 Жыл бұрын

Nice tutorial. Thank you!

@scriptbytes Жыл бұрын

Thanks for watching!

@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

@nathanvanveldhuizen7159 Жыл бұрын

Awesome 👍

@nicmantzivis8978 Жыл бұрын

Thank you kind Sir

@scriptbytes Жыл бұрын

You’re welcome, thanks for watching!

@4115steve 2 ай бұрын

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.

@scriptbytes 2 ай бұрын

Great suggestion! Thanks for watching.

Ай бұрын

What would you recommend for production?

@tradergermany5494 10 ай бұрын

excellent

@drkreh 3 ай бұрын

thanks sir

@erreib 3 ай бұрын

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?

@erreib 3 ай бұрын

I ended up solving it by putting all my cloud run components on the same vpc network. Thanks again for the very informative video!

@scriptbytes 3 ай бұрын

Glad you got it working!

@danielvega646 11 ай бұрын

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

@scriptbytes 11 ай бұрын

It should be doable as long as you substitute the correct docker commands

@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?

@scriptbytes Ай бұрын

You have to restart the container after the vm is restarted.

@DARREN_1 Жыл бұрын

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

@scriptbytes Жыл бұрын

Hard to tell without seeing it, might check that the ports are mapped correctly in the docker run command?

@MrLESPERGUER Жыл бұрын

hi! I'm guessing you made the same mistake I did. check the database creation command, you must indicate the port 5432:5432. if you don't, you will get that error. check the video at minute 6:44.

@nhaquyennguyen1289 Жыл бұрын

@@MrLESPERGUER I have same problem how to fix that ? thank

@kubwimanapatrick5425 10 ай бұрын

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

@scriptbytes 10 ай бұрын

You can use the External IP address of the server as the hostname in your connection. So for example in a .Net API, the connection string format would look like this: Host=1.2.3.4;Port=5432;Database=YourDatabaseName;Username=UserName;Password=Password123

@chibuisiamiaka6799 4 ай бұрын

@@scriptbytes I think we will need to setup a local socket sql connection right? We can do that using cloud_sql_proxy. Example, after installing cloud_sql_proxy, run the following command: cloud_sql_proxy -instances=example-project-dev:us-central1:example-db-name=tcp:5432. Then we can include credentials in the app connection string

@user-xk2lq6nq7v 11 ай бұрын

Hi, there is an info that the cost of instance is about $6. So it is not entirely for free?

@scriptbytes 11 ай бұрын

If you only have 1 VM running, and it fits all the criteria, it's free. It shows the cost on the setup screen but it's free if it meets the free tier criteria.

@user-xk2lq6nq7v 11 ай бұрын

@@scriptbytes Cool Thanks for clarification.

@oliverlarsen9388 11 ай бұрын

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?

@oliverlarsen9388 11 ай бұрын

It seems like that it is cloud sql that costs

@scriptbytes 11 ай бұрын

$19 in 4 days sounds like it’s a larger server config. Might check that.

@scriptbytes 11 ай бұрын

Ya if you decide to use cloud sql there is a cost. There’s no free tier for cloud sql unfortunately.

@River-iw1og Жыл бұрын

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

@scriptbytes Жыл бұрын

No reason in particular. Mostly just to show how to do it in case you’d need to go bigger or smaller.

@River-iw1og Жыл бұрын

@@scriptbytes If I set the boot disk setting here too high does that mean I lose out on space for my data? Assuming I want to stay within the 30GB max free tier.

@scriptbytes Жыл бұрын

@@River-iw1og No, the boot disk in this case is the only disk, so it's just the total amount of space available for your server. The higher the setting here the more space you have for everything on the server.

@user-bc2ji6jv8o 8 ай бұрын

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

@scriptbytes 8 ай бұрын

Sorry I dunno how to help with that.

@johnwyb2027 5 ай бұрын

had the same problem. some official postgres docker images have kinsing malware. if you run 'top' command and see kdevtmpfsi

@YukzGaming11 8 ай бұрын

What is the reason why Its not good for production?

@scriptbytes 8 ай бұрын

I should have clarified that better, that's related more to the size of the server. Also you do have to manage backups and server upgrades/updates yourself. Another option would be Cloud SQL, which is a fully managed service on GCP.

@rmcf3972 7 ай бұрын

@@scriptbytes cloud sql is not free?

@scriptbytes 7 ай бұрын

@@rmcf3972 Unfortunately they don't offer a free tier for Cloud SQL. The smallest Postgres database is going to be around $10/mo or so.

@KerptacularGaming 9 ай бұрын

Will I be charged for the external ip address?

@scriptbytes 9 ай бұрын

No, it mentions that in the free tier docs page: cloud.google.com/free/docs/free-cloud-features#compute "Compute Engine free tier does not charge for an external IP address."

@NextGenSellPOS 3 ай бұрын

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

@scriptbytes 3 ай бұрын

All the commands I used were straight from the docker installation docs link in the description. However it does look like things have changed since this video and the commands are different. I would reference the docs for that section of the video and hopefully that will get it working for you.