Is it possible to share a database (PostgreSQL) in the cloud, such as Dropbox, Google Drive?
I want to share my database, initially to access from different environments, just to start a new application.
Is it possible in any cloud service, how should I go about it?
Is there a free cloud service database for PostgreSQL?
Thank you in advance!
A file-sharing and storage service such as Google Drive and Dropbox is not enough because PostgreSQL itself is a server. It needs to be running on a machine that accepts clients' accesses on port 5432 (by default).
The most you can do in this case is to generate a file with the contents of your PostgreSQL database with a dump tool like pg_dump and share this file via Dropbox or Google Drive so that it is loaded by others in your particular PostgreSQL.
Is there a free cloud service database for PostgreSQL?
Try the ElephantSQL , they offer a free plan for small bases with few concurrent accesses.
All major cloud computing services, such as Amazon AWS , Microsoft Azure , and Google Cloud also offer Postgres servers. As in the reply from @ Shura16, I would also like to quote Heroku , mainly because they contribute a lot in the development of PostgreSQL.
The database itself is not, usually the databases are restricted for local access. But if you create an API (for example REST) by using services like Heroku .
