This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a demonstration on how to configure your PostgreSQL Database in the free cloud storage.
Basically, this is very useful when you are working on some POC (Proof of Concept) in which you require a small sample database in the cloud so that the application can connect to your sample database.
Today morning, we also got the same requirement to create a one POC for PostgreSQL. For this, POC I require only a little space like 10MB to test the specific item, so I searched around this and found some of the very good cloud storage.
I configured my PostgreSQL database using below two free different Cloud Storages.
Heroku – PostgreSQL
ElephantSQL (use Tiny Turtle plan for free configuration)
These both the cloud storage are very popular for PostgreSQL Database. They are also providing the different paid plan for various requirements.
They have a free plan and you can test your database with around 10 MB to 20 MB free space and 5 to 20 concurrent connections.
Before starting with any of this cloud storage, you have to create your accounts and select your desire plan.
Now choose your free plan and find out free database connection information like, Hostname -> DatabaseName -> UserName -> Password.
Now, open your PGAdmin and create a new server connections with given server detail.
Please do not forget to add ” host all all 0.0.0.0/0 md5 ” into your pg_hba.conf file and also make sure that listen_addresses = *.
Now, your small PostgreSQL database is ready for testing.
