Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I create a PostgreSQL db-f1-micro instance?

In the Cloud SQL for PostgreSQL pricing examples, I see that I should be able to create a db-f1-micro instance, using a shared CPU and 0.6 GB of RAM, at the price of $9/month.

However, when I try to actually create such an instance, I don't see that option. The UI only allows me to create a custom machine type with at least 1 vCPU and 3.75 GB of RAM, which would cost $51/month:

Screenshot of Cloud Console creating a PostgreSQL instance

Interestingly, for MySQL, I do get the option to create a db-f1-micro instance. But I can't use MySQL for this project.

Are the docs in error here? Or is there a trick to actually creating a budget db-f1-micro instance using PostgreSQL?

like image 725
Thomas Avatar asked Dec 17 '18 11:12

Thomas


2 Answers

Aha, I was missing a trick: the Cores slider isn't all the way on the left! Dragging it down sets it to "1 shared vCPU" and changes the memory settings to my satisfaction:

Screenshot of vCPU setting

like image 192
Thomas Avatar answered Sep 21 '22 12:09

Thomas


Also you can change it with CLI via gcloud:

gcloud sql instances patch <instance name here> --tier db-f1-micro
like image 34
Alexey Leshchenko Avatar answered Sep 22 '22 12:09

Alexey Leshchenko