What is CDS?
CDS is a Postgres Cloud Database Service. With CDS you can launch a PostgreSQL or EDB Postgres Advanced Server in Public cloud within minutes.
How to get started with CDS?
Start by registering for the CDS account. You can spin up micro and small Database Clusters with the free trial service.
What Public Clouds does CDS support?
CDS currently supports the AWS public cloud.
What is the difference between EDB Postgres on EC2 vs. EDB Postgres on CDS?
CDS takes care of much of the administrative overhead associated with hosting Postgres in Cloud and provides a fully managed service; Whereas, EDB Postgres on EC2, you have more control over your Postgres servers with more database administration.
DATABASE AND VERSIONS
What database versions does CDS support?
CDS currently supports PostgreSQL and EDB Postgres version 10 and 11. CDS will soon support PostgreSQL version 12 Beta.
What is the difference between EDB Postgres and PostgreSQL?
EDB Postgres is an enhanced PostgreSQL Database that is compatible with Oracle and has added security features.
When is the new version of PostgreSQL and EDB Postgres released on CDS?
We are one of the significant contributors to the PostgreSQL community. CDS makes the new versions available as soon as they are available on the community repository.
Does CDS provide to the True Postgres Superuser access?
Yes, CDS provides True Superuser access. You can access all the functions and controls of Superuser through pgAdmin.
How do I install an extension to CDS?
For installation of custom extensions, please reach out to the CDS support staff at firstname.lastname@example.org. CDS supports all major Postgres extensions.
Is it possible to use my existing PEM to monitor CDS databases?
Yes. Please connect to PEM using the credentials of your database cluster.
What kind of Notifications does CDS send?
CDS sends notifications:
- New cluster creation.
- If a server stops (or is terminated).
- Replica addition to a cluster
- When memory is scaled up
- Failover initiation on a master or a replica
- Backup failure.
- If the password associated with your user account changes.
How do I create a cluster?
You can launch a free Postgres cluster by login into your CDS account and clicking on Free Trial, then the new cluster button. One can launch larger instance classes using paid clusters, after entering credit card information.
Detailed documentation on how to use CDS can be found here.
How do I connect to a database instance?
You can connect to your database instance using the credentials you created while launching your database instance. If you do not remember or have lost your credentials, please reach out to email@example.com
How do I import data into Database Instance?
Depending upon the data size and application requirement, you can either use logical backup and restore to move your data or can use logical replication to move your existing Postgres data to CDS. You can also use pg_dump to import data.
A user can use free Oracle to Postgres migration portal to migrate oracle schemas to EDB Postgres.
How do I reset the forgotten database password?
If you have lost your password for connecting to the DB instance, please reach out to the support team by sending an email to firstname.lastname@example.org or open a case on customer portal to regenerate the password of your database instance.
What regions are available?
We currently support US East (N. Virginia), US West (N. California), EU (Ireland), EU (Frankfurt), Asia Pacific, (Sydney) and Asia Pacific (Singapore). If you need any additional regions, please get in touch with a Cloud Care specialist at email@example.com.
How do I access my clusters administration?
You can access your clusters by login into your account here and clicking on the region console.
Does CDS have user management?
CDS supports multi-user and roles management. CDS also has predefined user roles which can be used to create teams and have different levels of access for each user.
How do I tune Postgres for better performance?
CDS comes with a pre-build configuration for optimal performance. If you would like to tune the database parameters further, you can use “Alter System” command to change the Postgres parameter settings and restart/reload the database.
How do I upgrade my database version?
There is an Upgrade icon option within CDS that allows you to do a major version upgrade to the latest supported version by CDS for both Postgres and EDB Postgres. The upgrade is done by using pg_upgrade with link option, which is much faster as compared to without hard link option. You can also upgrade your database to the latest minor version available.
How to track performance and diagnostics in CDS
To monitor performance and diagnostic, use Postgres Enterprise Manager(PEM) as a remote monitoring solution. (You can analyze queries running for the selected time frame, any blocking queries and help relate with disk IO usage for each query.) Click here for more details on PEM.
What Is a cluster template?
A cluster template is a pre-build configuration of an instance that the CDS team has created based on years of experience. More details about Templates and their configuration can be found here.
How do I create a cluster using templates?
Login to your CDS account > Click on the region > Click on Launch Cluster > Click Launch from Template.
How many Instances can I create on CDS?
There is no limit on how many Instances you can create on CDS. We are an enterprise Postgres company, and CDS is built to scale.
7 DAY TRIAL
What is a 7 Day free trial?
CDS offers a 7-day free trial. You can launch a Postgres cluster on AWS - US East region with a validity of 7 days. You can test the cluster during this time and reach out to the support team if you have any questions.
What happens to my Data and clusters after 7 Days?
Data associated with the database instance at the end of your trial period are deleted along with the clusters. This situation is only valid for the 7-day trial clusters.
What regions are supported by CDS on the Free trial period?
CDS supports the US East region for the free trial period.
Does my account expire after seven days?
No, your account does not expire. You can keep creating new trial clusters that are valid for 7 days before deletion.
‘What does 1 TB of free storage mean on CDS?
CDS offers 1 TB free storage. A customer using less than 1 TB of storage space does not pay any additional charges for storage.
You will only pay for compute, data transfer, IOPS, and EBS optimized storage charges until the 1 TB threshold is reached.
How is pricing calculated?
There are many factors that affect the actual pricing. However, for the sake of simplicity, the cost is determined based on:
- Data transfer (Within the same region is very minimal and usually cost more for data transfer to other regions than your master instance)
- Type of storage ( SSD is no additional charge)
What is reserved pricing?
EDB Postgres Reserved Instances for Cloud Database Service (CDS) give you an option to reserve Postgres database instances for a one year term and get 25% OFF. All reserved instances are available for PostgreSQL or EDB Postgres Advanced Server database engines.
Can I pause my service any time I want? Will I still be charged?
To pause your cluster, you can create a manual Snapshot of your cluster and delete the cluster. You can restore the database at a later stage from the snapshots.
You do not pay Compute cost after the deletion of the database instance. However, if you create a manual Snapshot, you are charged for the storage.
Does CDS support invoicing as a payment method or is it credit-card only?
Yes, CDS supports invoicing as a payment method. EnterpriseDB supports manual invoicing for those users that do not wish to pay their invoices by credit card. To establish an account, please complete the form provided on the pricing page after creating an account and click the Contact Sales button. Alternatively, you can reach out to the support staff at firstname.lastname@example.org
What is my billing period in CDS?
Your billing cycle starts from the day you create an account with CDS. For example: If you have created an account on August 10th 2019, your bill generates on September-10-2019 (depends on usage).
Can I use a mix of both Reserved CDS instances and On-Demand, Pay-as-you-Go Instances?
Yes, you can specify a cluster when purchasing reserved instances. You can run other clusters in parallel on On-Demand Pricing model.
How to retain backups for the long term?
You can retain manual snapshot or backup of the cluster as long as you want.
Can I automate backups and what is the backup retention time?
A user can either automate the backup process and retain the backups for as long as you want. Automatic retention comes into effect based upon the retention value set for the cluster. See Product Documentation for more details.
Does CDS support PITR and streaming WAL logs?
Yes, CDS supports Point-In-Time-Recovery and steaming WAL logs.
There is no limit on how long you want to retain Streaming WAL Logs. A user can specify and enable PITR retention period in the console after launching the cluster.
HA & SCALING
How does auto-scaling for disk space (storage) works?
After launching a cluster, the user can go to cluster console and set a threshold for auto-scaling. Once the threshold reaches, CDS auto-scales the storage without any downtime and send a notification.
What happens in the event of a Master Node Failure?
In the event a Master Node fails, CDS promotes a read replica to a master and add a new replica in a matter of few minutes.
In the event of a Master failure, CDS will point the application to the new endpoints automatically.
What happens if a Read-Replica fails?
If a Read-Replica fails, CDS spins up another read-replicas. While failover replica is being added, the Master database is used to support read-write operations. There is no downtime.
What attributes of CDS cluster can I scale?
Yes, with CDS, you can scale Storage, Memory, IOPS, Read-Replicas, and Machine type.
Will there be downtime during scaling?
There is no downtime while Scaling your cluster.
What attributes can I scale down?
You can scale down Machine Type, IOPS, Replicas and Memory. You cannot scale down storage.
How many replicas can I have in a Database Cluster?
There is no limit on how many read-replicas you can create. Once your machine scales up to 15 read-replicas, you can only scale 1 read replica at a time.
Does the Free Trial console have the cross-region cluster feature?
No, the cross-region cluster feature is only available with the paid subscription of CDS.
How do I create a replica in a different region other than in the Master Node region?
- In the CDS console when you create a cluster, the dialogs that allow you to create and manage clusters or nodes (for various operations like create, scale, clone, or delete) will make the regions, VPCs, availability zones, and subnets of another remote region available for selection.
- Select the specific remote region which allows the user to create a node in that particular region.
- And, confirm the selection.
How is Failover to remote replica handled in CDS?
Failover to nodes that reside in a different foreign region than the master node is not supported currently (This should be available in the next release). If a master node fails and you do not have a standby Node in the same region as the master node, CDS will create a replacement node in the same region as the original master.
Where can I find the information related to all the cluster nodes in CDS?
All of the resources that reside on federated consoles will be visible on the Clusters tab of all of the different region consoles.
Can the user do multi-region Machine scale operation?
Yes, the user can perform multi-region machine scaling. If the cluster contains nodes running in different regions, then the console that manages the master node will coordinate machine scaling in the remote regions. A new master node is created first on the new machine type, the old master is removed, and then each replica node is replaced.
What cluster operations are permitted from any remote region console for a user?
Following operations are permitted for a cluster from any of the region consoles the CDS user is currently logged in:
- Delete a node or cluster regardless of the region in which the node or cluster resides.
- Initiate a clone operation regardless of the region in which the node resides; the clone operation will be able to create one or more nodes in any region of the federation.
- Initiate a yum update on any node or cluster of the federation (remote or local).
- Add resources and replicas in any region of a federated console during a manual scaling operation.
- Machine scale the cluster.
What extension do we support?
Can EDB help me to migrate an on-premise database to CDS?
Yes, the CDS support team can help you migrate your existing Oracle or Postgres on-premises database to CDS. You can use the EDB Postgres Migration Portal to migrate your Oracle schema directly to a CDS cluster.
How is Advanced support different from Basic support?
Advanced support provides more aggressive SLA and is more suitable for production or business-critical database clusters.
Do CDS provide support for Postgres Tuning?
Yes. Enterprise Support is required to get support for Postgres tuning.
What is Postgres Rocks, and how do I raise a support ticket?
Postgres Rocks is community maintained by EnterpriseDB. Users of CDS can ask questions related to PostgreSQL or EDB Postgres Advanced Server. Additional FAQ, articles, and forums for knowledge sharing for CDS can also be found in the CDS Resource Center on Postgres Rocks
Paid user can raise a support case by sending an email to email@example.com or opening a case through the customer portal.
What is Oracle Compatible Postgres?
With CDS you can run an instance of EDB Postgres Advanced Server. EDB Postgres Advanced server is an enhanced PostgreSQL database with Oracle Compatible features. If you are using Oracle, EDB Postgres is an Open source and cost-effective alternative.
What is the licensing model for the EDB Postgres Advanced Server on CDS?
Software and database licensing costs are included with the CDS pricing, and thus there are no additional licensing charges.
What are the advantages of moving to EDB Postgres Advanced Server on CDS?
CDS cost significantly less than Oracle’s Public cloud offering. EDB Postgres Advanced Server is Oracle compatible and is packed with enterprise security features.