ElephantSQL is a PostgreSQL database hosting service. ElephantSQL will manage administrative tasks of PostgreSQL, such as installation, upgrades to latest stable version and backup handling.

ElephantSQL is also integrated to several cloud application platforms (also known as PaaS). With a click of a button your database is provisioned in the same data center as your application is hosted, and is ready to be used immediately. ElephantSQL is currently integrated with AppHarbor.

Getting started

To get started you need to sign up for a customer plan. What plan you want to use depend of your needs. We offer five different service plans, three dedicated clusters and two shared clusters.

You can try ElephantSQL for free with the plan Tiny Turtle. All other plans are billed by the second, so you can try out even the largest instance types for mere pennies. Billing occurs at the end of each month, and you're only charged for the time an instance has been available to you.

It is easy to get started with ElephantSQL. Press the Log in button in the top right corner or press at any chosen plan from the plan page. Sign up by entering your email address and a password and press "Sign up".

An email will be sent to you with email address confirmation information. You need to confirm your email and add some additional information like billing information before you are able to create a paid plan.

Create a new instance

If you would like to create plan Pretty Panda or larger, you need to start by adding a credit card or PayPal account to you ElephantSQL account.

Press create to create a new instance.

  • Name: The name of the instance. This name should be a name that helps you identify which application the instance is used by.
  • Data center: Choose the datacenter and region of where your instance will be located. Choose the datacenter that's closest to the servers of your application - you want the latency to be as low as possible. Datacenters that are available for shared plans are marked with an asterisk *.
  • Plan: The plan you would like to have.

Immediately after the instance is created it will be provisioned to you. The instance details, such as connection URL, statistics, connections and your slow queries can be seen at the details pages. From here will you also be able to restore backups and rotate your password. If you are on a dedicated plan (Happy Hippo or larger) you will be able to view server metrics, you can set up followers and you can view information for all your databases.

Connection URL format: postgres://username:password@hostname/databasename

Details

Once you have created your account you can get started using your PostgreSQL database by using any of the guides listed, depending on platform and language. These tutorials cover the basics of how to get started with ElephantSQL.

The database instance can be tested and used via different tools, e.g the ElephantSQL SQL browser, pgAdmin or psql. A link to ElephantSQL SQL browser page can be found from the management console for your instance. From that page you can execute sql queries from your web browser. psql is an interactive terminal for work with Postgres and pgAdmin is a graphical administration client for PostgreSQL. Details Details

More information about ElephantSQL, tool, monitoring and backups can be found under the Product Overview.

Add Follower, Create Fork and Point in time recovery

Press edit on your instance and you will see the options to add a follower, to create a fork or to do a point in time recovery. You can also find the option to add a follower from the control panel of your instance.

Follower setup