New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Postgres DB hosting
faultyservers
Member
in Requests
Hi.
I'm looking for some nice PostgreSQL hosting for a project under $10/month. I have a relatively low traffic database, under 2GB. I'm looking for something with backups and failover would be nice. US location is preferred.
Comments
We used to host PostgreSQL, not any more as it's no interest in it from our clients.
try the following providers:
http://www.postgresql.org/support/professional_hosting/northamerica/
heroku.com blend nicely with postgres
You should pick one near where your project is hosted because the farther it is, the longer every query takes.
I'm looking for something similar to the Heroku and Amazon RDS solutions. Any ideas?
openshift
@faultyservers If you are going to host Both the DB and project there it would be ideal
I no expert in DB but Heroku and Amazon RDS will be quick with ur query If not it will take longer as @doghouch said below
But if not there are some providers who can offload the DB if u have service with them
@faultyservers for $10/month u can host yourself in DO (digital Ocean) they can be fast and u can use master to master replication or slave to master replication You can spin up two instance in different zones then u can replicate
just some links
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps
https://www.digitalocean.com/community/tutorials/how-to-choose-a-redundancy-plan-to-ensure-high-availability
disclaimer:if this is Not production server and just my opinion
Thanks, I think I will do that.