Skip to main content

PGWire Settings

AtScale supports the following settings for configuring PGWire.

pgwire.ignore.drop.table.queries​

  • Default: false
  • Restart: No

Determines whether the Queries page displays error messages for failed DROP queries from BI tools that use the PostgreSQL driver.

BI tools that use the PostgreSQL driver (for example, Tableau) attempt to clean up temporary tables by issuing DROP statements to AtScale. AtScale does not support these statements, so the queries fail, and errors appear on the Queries page in Design Center. (Note that the temporary tables are cleaned up automatically at the end of the session.)

If you wish to prevent these errors from appearing in Design Center, you can set this setting to true, and AtScale will ignore the DROP statements.

pgwire.maxMessageLength​

  • Default: 10485760
  • Restart: Yes

The maximum message length in bytes that the PGWire server will accept. Messages that exceed the defined length will be dropped and their connection will be closed.

pgwire.ssl.enabled​

  • Default: false
  • Restart: Yes

Whether or not SSL is enabled for PGWire specifically.