Add Notice Handling for PostgreSQL in ProxySQL

[rahim-kanji]

Description

ProxySQL currently does not handle PostgreSQL notices. This feature request is to implement notice handling for PostgreSQL connections. Notices are non-critical informational messages sent by the PostgreSQL server to the client. They can be used to convey important runtime information, warnings, or other system events that don’t necessarily require immediate action but are valuable for understanding the state of the system.

Adding support for notices would enhance ProxySQL’s capability to fully integrate with PostgreSQL, ensuring all client-server communication is appropriately handled.

What are Notices in PostgreSQL?

Notices in PostgreSQL are server-generated messages that provide additional context or information. These messages are sent asynchronously to the client and typically do not interrupt normal query execution. They are often used for:

• Logging runtime information.
• Providing warnings about potentially problematic behavior.
• Informing clients about system changes or issues.

Notices are distinct from errors and do not cause transactions to fail.

Why is Notice Handling Important?

1. Enhanced Monitoring and Debugging: Notices can help track runtime warnings or additional information that may be critical for debugging or monitoring purposes.
2. Seamless Client Communication: Clients interacting with PostgreSQL through ProxySQL should receive notices as expected for transparency and consistency.
3. Improved Compatibility: Handling notices aligns ProxySQL’s behavior more closely with native PostgreSQL clients.

References

PostgreSQL Documentation on Notices: https://www.postgresql.org/docs/current/libpq-notice-processing.html