Menu
I've provisioned an RDS instance using Postgresql 9.3.1 and my application requires en_US.UTF-8. When postgres was locally installed, I would have to create the cluster using "--locale=en_US.UTF-8".
Now with RDS, my understanding is I need to create a custom parameter group, however my questions are:
Unfortunately, the only other answers I have found are specifically for MySQL.
399
The character set support in PostgreSQL allows you to store text in a variety of character sets (also called encodings), including single-byte character sets such as the ISO 8859 series and multiple-byte character sets such as EUC (Extended Unix Code), UTF-8, and Mule internal code.
To modify an RDS DB instance configuration, follow these steps: Create a DB parameter group. View the parameter values for a DB parameter group to confirm that the Is Modifiable property is true. Modify the parameters in a DB parameter group.
Amazon RDS now supports Storage Auto Scaling and it automatically scales your storage capacity for database workloads, with no downtime. This new feature makes it easy for customers, all you need to do is set your own maximum storage limit and the Storage Auto Scaling does the rest of the work for you.
This is set with the client_encoding option in the parameter groups. This information is buried in an appendix of AWS's documentation.
Here's what it looks like:
87
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
