1/8/2024 0 Comments Aws postgresql dump in ec2![]() () and accepting TCP/IP connections on port 5432?Ĭannot Connect to Amazon RDS PostgreSQL DB Instance So I'm running this command: pg_dump -h -p 5432 -f dump.sqlĪnd getting this: pg_dump: connection to database "brendan" failed:Ĭould not connect to server: Connection refused I encourage you to check those out too!įinally, we would love to hear from you to see how K10 could be useful in your Kubernetes environment.How can I connect to my RDS instance using pg_dump? In addition to backups and restores for PostgreSQL, K10 also supports backups and restores for a range of other relational databases (e.g., MySQL) and NoSQL systems (e.g., MongoDB or Elastic). I encourage you to also explore the more advanced backup and restore approaches (based on logical dumps and database quiescing) discussed in an upcoming companion blog in this series. This blog has shared steps for backing up and restoring PostgreSQL running on AWS using snapshots as the backup mechanism. Such use cases are described in the K10 documentation. You can also mask data, store it in an object store, and then read it from your local development cluster. K10 can be used to export the entire application stack and its data from production clusters and restore them to a geographically separate DR cluster. The workflow in this blog covers snapshot, backup, and restore in a single EKS cluster. In the screenshot below, we can see that our postgresql application is now compliant with all policies. ![]() When a policy that applies to an application successfully executes a backup, the application’s compliance with the policy is reported in the application card. Following the successful install of PostgreSQL, click on the Applications card on the K10 dashboard to see the discovered PostgreSQL instance. K10 automatically discovers the instance of PostgreSQL. To validate the PostgreSQL install, use the command below in the postgresql namespace to confirm that all PostgreSQL pods display a status of Running within a couple of minutes. $ helm install -namespace postgresql postgres stable/postgresql Use the commands below to create a namespace called postgresql and install PostgreSQL into your EKS cluster. $ kubectl -namespace kasten.io port-forward service/gateway 8080:8000 2. You can now access the K10 dashboard at after running the command below. ![]() $ kubectl get pods -namespace kasten-io -watch T o validate K10 install, use the command below in K10’s namespace (kasten-io, by default) to confirm that all K10 pods display a status of Running within a couple of minutes. $ helm install k10 kasten/k10 -namespace=kasten-io \ You will need to specify your AWS Access Key ID and your AWS Secret Access Key. The Helm commands use Helm v3, but using Helm v2 is also straightforward.Īdd the Kasten Helm charts repository and create the namespace where K10 will be installed using the commands below. Before proceeding with the install, the install prerequisites (Helm package manager and Kasten Helm charts repository) need to be satisfied. In this post a “happy path” install is used for demo purposes. Installing Kasten K10 on Your EKS Clusterĭetailed instructions for installing K10 are available in the K10 documentation. ![]() Backup and restore workflow using Kasten K10ġ.Installing Kasten K10 on your EKS cluster.The instructions in this post are organized in three sections: I assume that you already have an EKS cluster set up (if not, you can follow instructions here to deploy an EKS cluster). Kasten’s K10 data management platform, it is a secure software-only product that has been purpose-built for Kubernetes and provides operations teams an easy-to-use, scalable, and secure system for backup/restore, disaster recovery, and mobility of Kubernetes applications. PostgreSQL (often referred to as Postgres), is an Open Source relational database, popular in the cloud-native community. Further, it uses upstream Kubernetes allowing you to use open source community tools and run standard Kubernetes applications without needing refactoring. This blog assumes the use of Amazon Elastic Kubernetes Service (EKS).ĮKS is a fully managed Kubernetes service with deep integrations with a multitude of Amazon services making it easy to use and manage. In this blog post we will walk through how to use Kasten K10 to backup and restore PostgreSQL databases operating in a Kubernetes environment on AWS. PostgreSQL Backup and Restore on Amazon Web Services using Kasten K10.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |