Question:
I have a redshift cluster launched and running on aws and the inbound query is authorized by configuring the VPC security group
Then I try to connect to the redshift with pgAdmin and received following error
|
1 2 3 |
An error has occurred: ERROR: permission denied to set parameter "client_min_messages" to "notice" |
and
|
1 2 3 |
An error has occurred: Column not found in pgSet: "datlastsysoid" |
Answer:
PgAdmin is mainly a Postgres client and is not a supported client for redshift. Due to its incompatibility, opening a connection always tries to set client_min_messages, but Redshift refuses to accept such a setting. This causes the error you experienced.
Redshift supports only the below parameters which have to be set at the cluster –
|
1 2 3 4 5 6 7 8 9 10 11 12 |
dev=# show all; name | setting ---------------------------+---------------------- analyze_threshold_percent | 10 datestyle | ISO, MDY extra_float_digits | 0 query_group | default search_path | $user, public, admin statement_timeout | 0 wlm_query_slot_count | 1 (7 rows) |
You can use other clients like psql or SQLWorkbench/J as pgAdmin has deviations and doesn’t support connections to redshift. You can also refer to this where an issue is reported on Github.