Share cloud database (Postgresql)?

Question

You can 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.

It is possible on any cloud service, as I should proceed to do?

Is there any free cloud service database for Postgresql?

Thanks in advance !

Answer 1

A file storage and sharing service like Google Drive and Dropbox is not enough, as Postgresql itself is a server. It needs to be running on a machine that accepts customers' access at 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 the pg_dump and share this file via Dropbox or Google Drive to be uploaded by others in their particular Postgresql.

Is there any free cloud service database for Postgresql?

Try the Elephantsql, they offer a free plan for small bases and with few competing accesses.

All major cloud computing services, such as Amazon AWS, Microsoft Azure, and Google Cloud also offer Postgres servers. As in the @Shura16 response, I would also like to quote the Heroku, mainly because they contribute a lot in the development of Postgresql.

Answer 2

The database itself does not, usually the databases are restricted to local access. But if you create an API (for example REST) by using services such as Heroku.