permission denied to set parameter "client_min_messages" to "notice"

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

An error has occurred:
ERROR:  permission denied to set parameter "client_min_messages" to "notice"

and

An error has occurred:
Column not found in pgSet: "datlastsysoid"

Hi, did you solve the problem? Have any ideas of the reason? Thanks. — JavaNoScript, Aug 31 '16 at 10:47
Have you tried [SQL Workbench](http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-using-workbench.html)? — Rodrigo Ney, Aug 04 '17 at 19:11

score 19 · Answer 1 · edited May 28 '19 at 16:50

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 -

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.

permission denied to set parameter "client_min_messages" to "notice"

1 Answers1