2 Respostas
- Mais recentes
- Mais votos
- Mais comentários
1
Hello.
If it is a Lightsail managed database, you should be able to change the parameters using the following command.
https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-updating-database-parameters
If you are using RDS, you can change the parameter group to a custom parameter group by following the steps in the document below.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithDBInstanceParamGroups.html
1
Hi,
Please contact AWS Support under the free support plan to get the issue looked into and allow you to update the database parameter.
Thanks.
Conteúdo relevante
- AWS OFICIALAtualizada há 4 anos
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 3 meses
It is a lightsail managed DB and i already tried the update parameter solution it worked well with all the instances except one, failed with the following error message: (InvalidInputException) when calling the UpdateRelationalDatabaseParameters operation: Cannot modify a default parameter group.
Based on this documentation, it seems that Lightsail managed databases are configured with a custom parameter group when they are created. https://repost.aws/knowledge-center/lightsail-update-database-parameter
There is a possibility that this is a bug, so we recommend that you open a case with AWS Support under "Account and billing". Inquiries under "Account and billing" can be made free of charge. https://docs.aws.amazon.com/awssupport/latest/user/case-management.html