permission denied to set parameter “client_min_messages” to “notice”


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



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 –

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.

Leave a Reply