Why can't I stop RDS instance?
I spun up two RDS instances in the same VPC. Both are postgresql.
While the m4.xlarge one has multi-AZ enabled and is encrypted. The t2.micro has either. That is the only difference between the two instances. It is strange that t2.micro instance can be stopped but m4.xlarge can't. The "stop" option is grayed out for m4.xlarge.
Why can't I stop this one? Does it have to do with the multi-AZ thing?
Solution
You can't stop a DB instance that is in a Multi-AZ deployment.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html
Modify the instance so that it is no longer Multi-AZ. After this modification is complete, you should be able to stop it. You can switch it back to being Multi-AZ after it is restarted.
- How to return JSON objects without explicit aliasing in postgresql
- Postgresql + psycopg: Bulk Insert large data with POSTGRESQL function call
- Better way to insert a very large data into PostgreSQL tables
- Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`
- pgadmin4 : postgresql application server could not be contacted
- How can I specify the migrations directory for typeorm CLI?
- SQL full outer join, default value to column in other table
- PostgreSQL database not connecting to spring-boot application
- Setting auto increment id in Postgres with Navicat
- Dropping all views in postgreSql
- Where does PostgreSQL store configuration/conf files?
- Query produces "function unnest(unknown) is not unique error", but is executed fine by the application
- SQL statement evaluation order
- Execute multiple queries as one dblink transaction
- Spring Data R2DBC PostgreSQL not saving new record with UUID @Id
- PostgreSQL Stack Builder Installation Certificate verification problem on Windows
- How do you connect to postgres running in a Docker container on OSx?
- Order by the oldest relation Postgres
- How to create a role in postgress db which supports the CRUD operations but doesn't allow to drop the database and tables with that role
- Error calling procedure in posgres "No procedure matches the given name and argument types. You might need to add explicit type casts."
- How To Import a Big .csv(~2GB) Into a PostgreSQL Table
- Rails trying to connect to postgresql on port 5432, but it's configured for 5433
- Power BI, Postgres, and materialized views
- How do you name the PostgreSQL indexes when using Haystack's PgvectorDocumentStore?
- Postgresql showing only one decimal, Grafana showing 2
- Django Postgresql ORM optimisation
- "could not identify an equality operator for type json" when using distinct
- Syntax error at end of input in PostgreSQL
- How to increase the connection limit for the Google Cloud SQL Postgres database?
- postgresql timestamptz conversion to localtime issue