This is a list of our most frequently asked questions. For more information about ElephantSQL, or if you need any support, please visit our support page.

General questions

Why ElephantSQL

Handle instances

Backup

Integration and availability

Security

Reseller

Payment

GDPR

General questions

What is ElephantSQL

ElephantSQL is managed PostgreSQL servers in the cloud – hosted databases that let you store data in a structured way that can easily be accessed, managed, and updated.

What is PostgreSQL?

PostgreSQL is an open source, object-relational database management system.

What is a database?

Database's primary function is to store data in a structured way. Databases can store very large numbers of records efficiently. The data is stored securely and it is possible for authenticated users to access, manage, delete and update the data. It is possible for multiple persons to access the same database at the same time. All the data can easily be sorted into a chosen way (e.g. by date or alphabetic) when it is accessed/selected from the database.

What is a connection?

A connection is a TCP connection between your application and the PostgreSQL database.

Why should we use databases and ElephantSQL?

A database will help you structure your data in a good way. It is very quick and easy to find information from a database, perform a search in the database and it is easy to add new data and to edit or delete old data. ElephantSQL provides hosting of PostgreSQL databases, meaning that ElephantSQL mange and maintaining the servers. Our monitoring tool will detect unhealty nodes and we automatically restart nodes if they become unavailable. We do daily backups of your data, it is easy to set up followers to your database and we keep a "write ahead log" of all changes to your database and stores the logs in multiple data centers.

What is a database?

Database's primary function is to store data in a structured way. Databases can store very large numbers of records efficiently. The data is stored securely and it is possible for authenticated users to access, manage, delete and update the data. It is possible for multiple persons to access the same database at the same time. All the data can easily be sorted into a chosen way (e.g. by date or alphabetic) when it is accessed/selected from the database.

What is a connection?

A connection is a TCP connection between your application and the PostgreSQL database.

Why should we use databases and ElephantSQL?

A database will help you structure your data in a good way. It is very quick and easy to find information from a database, perform a search in the database and it is easy to add new data and to edit or delete old data. ElephantSQL provides hosting of PostgreSQL databases, meaning that ElephantSQL mange and maintaining the servers. Our monitoring tool will detect unhealty nodes and we automatically restart nodes if they become unavailable. We do daily backups of your data, it is easy to set up followers to your database and we keep a "write ahead log" of all changes to your database and stores the logs in multiple data centers. ElephantSQL has been running PostgreSQL servers for a long time. You can always trust us to know what to do if you run into problems. We also have extensive experience in monitoring of PostgreSQL servers.

What are the benefits of a cloud-based database

A cloud-based database will increase the speed of getting the application to the market. Developers can focus on the core part of their applications, instead of managing and maintaining servers and handling backups.

What kind of customers is using ElephantSQL?

Our customers are usually developers who want to focus on the core part of their applications, instead of managing and maintaining servers.

We have customers in a range from large enterprise business and startups to individual hobby developers.

Handle instances

How do I connect to my database?

When you have created a new instance you will get a new database. Look into the details page for the instance to find the hostname such as horton.elephantsql.com, password and username. We have guides for various programming languages under the Documentation tab. You can also connect to the host using psql, pgadmin, the ElephantSQL browser or any other Postgres-compatible client.

Can I migrate between plans?

You have some migration options between plans in ElephantSQL.
Fork: Easiest is to fork your database to a new server. This can also be done for plans with followers.
Backup and restore: Another option is to set up a new instance, take a backup of the old one and import your data into the new instance.
Pipe data: You also pipe your data to a new database: pg_dump postgres://user:pass@host/db | psql postgres://user:pass@host2/newdb

How do I delete an instance?

You can delete an instance from the instances list page. If you remove an instance, all your databases, users, data and backup will be deleted and we will not be able to restore them.

Can I have multiple databases for one instance?

You can create multiple databases on a dedicated server, Happy Hippo or Enormous Elephant.

I can not manage users or databases, what is wrong?

It is only possible to manage databases and users on dedicated plans. Our dedicated plans are Happy Hippo and Enormous Elephant.

What are followers and how can I set up followers to my database?

A follower to your database is another database that has a read-only copy of the master database. The follower will stay up-to-date with the master database data. All modification of the data, write/update/deletes are committed to the master database and the changes are streamed to the follower database.

You can use followers when you want to spread selects across multiple servers. Or you want to have a hot-standby ready to take over if you main database crashes.

Followers work by using PostgreSQL's built-in replication strategy.

On ElephantSQL is it easy to setup followers to your database. Go to the console page and press the follower tab and follow the instructions.

What kind of server metrics are available for the instances?

ElephantSQL offers server metrics for dedicated instances. The server metrics includes diagrams for CPU and Memory usage over time.

How many individual databases can I create on my server?

(Dedicated server) You can create as many individual databases as you like on your server. The servers are not artificially limited in any way, it is only up to the limits of the underlying hardware. Exact number of databases that a server can support depends on server size and how much load you have on your databases.

Is postGIS enabled?

PostGIS is enabled on all dedicated plans. PostGIS adds support for geographic objects allowing location queries to be run in SQL.

Is vacuum enabled?

Auto-vacuum is enabled by default but not full vacuum. On dedicated plans, you can control the auto vacuum too, we can help you configure it for you.

Backup

Does ElephantSQL take backups of the database?

Automated backups are performed every day on all plans (pg_dump). These are stored in a cloud file storage so they are always accessible to you (same cloud as your instance). The backup is saved for 30 days. The last month backup files can be found and downloaded in the ElephanSQL Control Panel.

The backups are compressed with lzop, to restore the data you can usually use the following: lzop -cd "$FILE_NAME" | psql "$DATABASE_NAME"

Full server backups (base backup) are performed once a week, rolling WAL backups are performed every second minute.

Integration and availability

How do I get started with ElephantSQL

If you are new to databases, we recommend you to read our beginner guide. It can be found here.

Another getting started guide can be found here. Once you have created your account you can get started querying and processing data by using any of the guides, depending on platform and language. These tutorials cover the basics of connecting your applications using ElephantSQL.

Handle instances

How do I connect to my database?

When you have created a new instance you will get a new database. Look into the details page for the instance to find the hostname such as horton.elephantsql.com, password and username. We have guides for various programming languages under the Documentation tab. You can also connect to the host using psql, pgadmin, the ElephantSQL browser or any other Postgres-compatible client.

Can I migrate between plans?

You have some migration options between plans in ElephantSQL.
Fork: Easiest is to fork your database to a new server. This can also be done for plans with followers.
Backup and restore: Another option is to set up a new instance, take a backup of the old one and import your data into the new instance.
Pipe data: You also pipe your data to a new database: pg_dump postgres://user:pass@host/db | psql postgres://user:pass@host2/newdb

How do I delete an instance?

You can delete an instance from the instances list page. If you remove an instance, all your databases, users, data and backup will be deleted and we will not be able to restore them.

Can I have multiple databases for one instance?

You can create multiple databases on a dedicated server, Happy Hippo or Enormous Elephant.

I can not manage users or databases, what is wrong?

It is only possible to manage databases and users on dedicated plans. Our dedicated plans are Happy Hippo and Enormous Elephant.

What are followers and how can I set up followers to my database?

A follower to your database is another database that has a read-only copy of the master database. The follower will stay up-to-date with the master database data. All modification of the data, write/update/deletes are committed to the master database and the changes are streamed to the follower database.

You can use followers when you want to spread selects across multiple servers. Or you want to have a hot-standby ready to take over if you main database crashes.

Followers work by using PostgreSQL's built-in replication strategy.

On ElephantSQL is it easy to setup followers to your database. Go to the console page and press the follower tab and follow the instructions.

What kind of server metrics are available for the instances?

ElephantSQL offers server metrics for dedicated instances. The server metrics includes diagrams for CPU and Memory usage over time.

How many individual databases can I create on my server?

(Dedicated server) You can create as many individual databases as you like on your server. The servers are not artificially limited in any way, it is only up to the limits of the underlying hardware. Exact number of databases that a server can support depends on server size and how much load you have on your databases.

Is postGIS enabled?

PostGIS is enabled on all dedicated plans. PostGIS adds support for geographic objects allowing location queries to be run in SQL.

Backup

Does ElephantSQL take backups of the database?

Automated backups are performed every day on all plans (pg_dump). These are stored in a cloud file storage so they are always accessible to you (same cloud as your instance). The backup is saved for 30 days. The last month backup files can be found and downloaded in the ElephanSQL Control Panel.

The backups are compressed with lzop, to restore the data you can usually use the following: lzop -cd "$FILE_NAME" | psql "$DATABASE_NAME"

Full server backups (base backup) are performed once a week, rolling WAL backups are performed every second minute.

Integration and availability

How do I get started with ElephantSQL

If you are new to databases, we recommend you to read our beginner guide. It can be found here.

Another getting started guide can be found here. Once you have created your account you can get started querying and processing data by using any of the guides, depending on platform and language. These tutorials cover the basics of connecting your applications using ElephantSQL.

Do all clusters have nodes in multiple availability zones?

All clusters have nodes in multiple availability zones.

What will happen if one node goes down?

If one node goes down will our monitoring tools detect that and bring the node back up again. It is possible to set up followers/replicas to maximize the uptime of your database.

What application platforms are ElephantSQL fully integrated with?

ElephantSQL is fully integrated with following platforms:

What clouds/data centers and regions are ElephantSQL available in?

ElephantSQL is available in following clouds and regions

* Regions that are available for our shared instances, Tiny Turtle and Pretty Panda.

  • Amazon web services

    AP NorthEast 1 (Tokyo) *, AP Northeast 2 (Seoul), AP South 1 (Mumbai), AP Southeast 1 (Singapore), AP Southeast 2 (Sydney), CA Central 1 (Canada), EU Central 1 (Frankfurt), EU West 1 (Ireland) *, EU West 2 (London), EU West 3 (Paris), SA East 1 (Sao Paulo), US East 1 (Northern Virginia) *, US East 2 (Ohio) *, US West 1 (Northern California) *, US West 2 (Oregon)

  • Google Compute Engine

    Asia East 1 (Taiwan), Asia Northeast 1 (Tokyo), Asia South 1 (Mumbai), Asia Southeast 1 (Singapore), Australia Southeast 1 (Sydney), Europe West 1 (Belgium), Europe West 2 (London), Europe West 3 (Frankfurt), South America East 1' (São Paulo), US Central *, US East 1 (South Carolina), US East 4 (North Virginia), US West 1 (Oregon)

  • Softlayer

    AMS01 - Amsterdam, Western Europe, DAL05 - Dallas, Central United States *, DAL06 - Dallas, Central United States, HKG02 - Hong Kong, Asia, HOU02 - Houston, Central United States, LON02 - London, Western Europe *, MEL01 - Melbourne 1, Australia, SEA01 - Seattle, West Coast United States, SJC01 - San Jose, West Coast United States, SNG01 - Singapore, Southeast Asia, TOR01 - Toronto 1, Canada, WDC01 - Washington DC, East Coast United States

  • Azure

    Australia East, Australia Southeast, Brazil South, Canada Central, Central India, Central US * , East Asia, East US, East US 2, Japan East, Japan West, North Central US, North Central US, North Europe, South Central US, South India, Southeast Asia, UK South, UK West, West Central US, West Europe, West Europe *, West India, West US, West US 2

pgAdmin - Fail to connect to the database with pgAdmin, what is wrong?

You probably left the default 'postgres' in the 'Maintenance DB' field. Change it to the database name. More information about pgAdmin set up can be found here.

Security

Does ElephantSQL support TLS/SSL?

We do support TLS (SSL). In most clients it is easy to use TLS by adding ?ssl=true to the connection URL. More information can be found here: PostgreSQL JDBC Driver Chapter 4. Using SSL

How do I authenticate your server's identity?

Our servers certificate is signed by one of the common trusted root CAs, Comodo, most OSes/browsers come with the Comodo cert built in. If you don't have a trust store you can download the AddTrust/Comodo root cert here: https://support.comodo.com/index.php?/Default/Knowledgebase/Article/View/979/108/domain-validation-sha-2

Reseller

Do you offer any reseller discounts?

No. We don’t provide any reseller discounts at this moment.

Are there any shipping costs?

No. There is no shipping cost since the service is shipped electronically.

Is the service returnable?

No. The service is non-returnable.

What payment options and terms do you offer?

You can choose to pay through credit card (due on charge date) or via wire transfers (NET15). If you would like us to enable manual invoicing via wire transfer - send us an email once you have added all information and we will enable it for you. Please note that we don’t accept checks.

We need an official quote, how do we get that?

Email sales@elephantsql.com to receive an official quote. Include what plan you want, if the quote should include VPC or not, and the subscription period.

Will your service be provided on- or off-premise?

The service will be provided off-premise in a data center and region chosen on behalf of the customer. The data centers and regions currently provided can be found at the bottom of this page: https://www.elephantsql.com/plans.html.

How does your billing work?

Our billing is pro-rated, which means that our customers only pay for the time the service has been available to them and that the payment is done the month after delivery. Thus, you won’t receive your first invoice when the account has been created, you will receive it in the beginning of the upcoming month.

Our PO is set up for a year, could we get an annual invoice?

No. It’s very common that our customers change their plan while they are using our service, therefore it’s not convenient to pay for a year upfront. However, we do provide the possibility to make prepayments with credits. More information can be found here: https://www.elephantsql.com/blog/2017-11-01-prepayment-as-a-payment-option-is-now-available-at-elephantsql.html.

Please advise if any documents with signatures will be required in addition to the PO we would submit in the event a PO is executed.

No. We don’t need any documents with signatures from you.

Can you confirm that the service will not have an automatic renewal once the current subscription on the PO expires?

No. Our active subscriptions are running until they are deleted. The reason for this is that we don’t want to delete our customer’s data when they have an active subscription. So for example, if you’re a reseller and has provided us with a PO that concerns two months usage of our Happy Hippo plan, then you’re responsible for deleting the plan after the two months have passed. Otherwise, we will charge you for the upcoming months.

We have a customer using your service with an active subscription and PO. Now it wants to create one more subscription. Should we extend the current PO or issue a new one?

It’s best to extend the current PO. If you need to have two separate PO’s for the subscriptions, you need to open a new account in order to make the subscriptions be billed separately.

I’m a reseller and want to set up an account, how do I do that?

  1. Go to https://customer.elephantsql.com/login and enter your email address. Fill out all your information in the billing section, such as billing address etc, billing email etc. Please note that it’s important that we have your billing information registered and not the end-customers information, since you are our direct customer and not the end-customer.

  2. The PO number can be specified in the billing section under “billing notes”. Or send it to us, and we will add it for you.

  3. You are free to create and delete instances once the billing information is set up. It’s up to you and the end-customer to decide who of you that will create the subscription specified in the PO.

  4. Invite the end-customer to the account via https://customer.elephantsql.com/team so that he/she can start using the service.

  5. Change the role of the person that created your account to “Billing Manager”. By doing so, you can access all invoices of the account and update the billing information. But you will not be able to edit the customer's subscription. See more information here: https://www.elephantsql.com/blog/2017-12-15-manage_elephantsql_instance_access_permissions_with_acl.html.

Payment

How and when will I get billed?

All plans are billed by the second, you can try out even the largest instance types for mere pennies. As soon as you delete the instance you won't be charged for it anymore, i.e. if you had a Happy Hippo (for $99/month) running for 15 days, then you will only be charged $49.50.

Billing occurs at the end of each month, and you are only charged for the time an instance has been available to you.

What are my payment options?

You can pay with Paypal, VISA, Mastercard or by Invoice/transfer. We do also accept Amex through PayPal. Contact us at contact@elephantsql.com if you require invoicing. Payment options can be found under Billing information in the Control Panel.

Is CloudAMQP GDPR-compliant?

Yes. You can read more here

Can we sign a DPA with CloudAMQP?

Yes, you can sign a DPA with CloudAMQP. You access the DPA in the “Agreements”-section of the control panel.

How do you make a subject access request to 84codes AB?

You have the right to see what personal information 84codes AB holds about you. You are entitled to be given a description of the information, what we use it for, who we might pass it onto, and any information we might have about the source of the information.

A subject access requests should be made via email to compliance@84codes.com

Where is my data located?

You as data controller decide for yourself where you want to host your data by choosing data center and region of the data center. The data will not leave that region, unless you choose to move it. In CloudAMQP’s role as data controller, we may collect and store contact information, such as email address, and physical address, when customers sign up for our services or seek support help.

Your personal customer data (email and billing information) is stored in US.