postgresqlamazon-web-servicesamazon-rdspostgresql-9.3
Set character set on Amazon RDS (Postgresql)
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:
- Which field do I need to modify? client_encoding?
- What exactly do I set the field to? Can I specify en_US.UTF-8 or just UTF-8 (or UTF8??)
- I plan on upgrading to 9.4.5, will the answers above remain the same?
Unfortunately, the only other answers I have found are specifically for MySQL.
Solution
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:
- dspace import metadata acknowledges changes doesn't apply them
- Running the Postgres CLI client from a Kubernetes jumpbox
- Problem Restoring PostgreSQL Database in Docker Container with Symfony
- Getting error recursive reference to query must not appear within its non-recursive term in postgres
- Postgres split time ranges into 1 minute slots, without rounding boundaries
- how to store PostgreSQL jsonb using SpringBoot + JPA?
- How to write this SQL query to find each account balance?
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL Formatting a string (name)
- Postgres Query using concat and LIKE
- Autoincrement separately for each foreign key
- error connecting external database with rails
- Forward fill NULL values in multiple columns
- PostgreSQL EXISTS in user-defined function always returning true
- Problem with creating server in pgadmin 4, unable to connect to server
- Oracle JSON_TABLE to PostgreSQL - how to search from the second hierarchical key in a JSON column
- pg_upgrade on Windows cannot write to log file pg_upgrade_internal.log
- SQLAlchemy Many-to-Many using PostgreSQL's on_conflict_do_update doesn't get committed
- Why is my postgres constraint name suffix different from the standard?
- I want to restore the database with a different schema
- Postgres settings to maximize compute resources for a single local connection
- Why does an operation on real and a numeric inputs result in a double precision?
- Typeorm queryBuilder select only a specific key value of a JSONB type column
- How to set `lock_timeout` on a PostgreSQL connection with SQLAlchemy and psycopg2?
- How to calculate DATE Difference in PostgreSQL?
- Missing FROM-clause entry for a table
- PostgreSQL 17: pg_upgrade on Windows Server 2019: could not load library "$libdir/adminpack": No such file or directory
- Displaying binary images on JSP page
- Recursive CTE in Postgresql
- Add missing dates in a table