Pgagroal Versions Save

High-performance connection pool for PostgreSQL

1.6.0

3 months ago

This is a feature release.

Features

Support for CLI/JSON output
Support for client certificates (Experimental)
Introduce subcommand config-get
Introduce subcommand config-set
Add a max_connection_age setting
Mac OS X support

Enhancements

Improve error messages for configuration
Detect invalid pgagroal_users.conf file
Better handling of pgagroal_databases.conf

Bugs

Fix exit code handling in pgagroal_cli
Fix Prometheus output for certain metrics

Thanks to

@fluca1978: #209, #253, #328, #329, #330, #334, #337, #339, #340, #355, #356, #381, #382, #385, #386, #390, #399, #401
@SudeepRed: #190, #312
@2010YOUY01: #325
@ashu3103: #393
@hao-tian-xu: #361
@nikitabugrovsky: #366

1.5.1

1 year ago

This is an enhancement and bug fix release.

Enhancements

#347 Link to libatomic on Linux

Bugs

#327 Invalidate Prometheus cache upon reset
#343 Make limits mandatory for the transaction pipeline

1.5.0

1 year ago

This is a feature release.

The release was driven by Luca Ferrari with a focus on production level usability.

Features

#44 Log formatting support
#45 Log rotation support
#208 Tell the user where the master key is stored
#219 Provide Prometheus metrics cache
#244 Allows spaces and comments in configuration parameters
#271 Tutorial: Install
#272 Tutorial: Prefill
#273 Tutorial: Remote management
#274 Tutorial: Prometheus
#277 Tutorial: Split security
#285 Introduce update_process_title setting
#291 Shell completions for pgagroal-cli and pgagroal-admin

Enhancements

#19 Integrate uncrustify
#205 Improve error messages when the limits exceed the number of max_connections
#206 Remove is_valid_password function and provide better messages
#210 Understand all 'debug' levels for log_level
#214 Flush the old primary in case of a failover
#215 Process title length
#217 Return 400 Bad Request for any method except GET
#224 Prefill when doing a switch-to or primary change
#234 pgagroal-cli reload transfer also log_rotation settings
#235 Do not emit "restart" messages when adding a new server
#240 Cleanup pgagroal_read_configuration()
#254 Document pgagroal-cli commands that work on all databases
#257 Refactoring of the configuration age and size parsing
#259 Omit configuration warnings when running cli
#263 Use a macro to perform the process-sleep
#265 HTML validation and cleanup
#275 pgagraol-cli gives priority to remote options when specified
#280 Improve tutorial
#280 Reduce code duplication while reading configuration
#292 Make the version number comparable
#297 Improve configuration error management
#303 Allows for 'B' suffix in multiletter size specification
#306 Remove atoi() in as_logging_level()
#316 Use err()
#322 OpenBSD and FreeBSD configuration files

Bugs

#198 Guard PID file creation
#204 Guard against drivers with protocol violations
#221 Fix broken link to sample configuration file
#230 Correctly read last line of configuration file if no new-line
#231 No warning messages about pid file when configuration reloads
#232 Keep the same state for the same server during a reload
#245 Fix warnings about server sections

Thanks to

@fluca1978: #44, #45, #198, #205, #206, #208, #210, #215, #219, #221, #224, #230, #231, #232, #235, #240, #244, #245, #254, #257, #259, #263, #265, #278, #280, #282, #285, #287, #291, #292, #297, #298, #299, #301, #303, #306, #308, #309, #311, #313, #316, #318, #319
@nikitabugrovsky: #217

1.4.2

2 years ago

This is an enhancement and bug fix release.

The pgagroal community welcomes Nikita Bugrovsky (@nikitabugrovsky) with his contribution !

Enhancements

#19 Integrate uncrustify
#217 Return 400 Bad Request for any method except 'GET'
#224 Prefill when doing a switch-to
#228 No warning messages about pid file when configuration reloads
#230 Correctly read last line of configuration file if no new-line
#235 Do not emit "restart" messages when adding a new server

Bug fixes

#221 Fix broken link to sample configuration file
#232 Keep the same state for the same server during a reload

Thanks to

@fluca1978: #221, #224, #228, #230, #232 and #235
@nikitabugrovsky: #217

1.4.1

2 years ago

This is an enhancement and bug fix release.

The pgagroal community welcomes Luca Ferrari (@fluca1978) with his contributions !

Enhancements

#205 Improve error messages when the limits exceed the number of max_connections
#206 Remove is_valid_password function and provide better messages
#208 Tell the user where the master key is stored
#210 Understand all 'debug' levels for log_level
#214 Flush the old primary in case of a failover

Bug fixes

#198 Guard PID file creation
#204 Guard against drivers with protocol violations

Thanks to

@fluca1978: #198, #205, #206, #208 and #210

1.4.0

2 years ago

This is a feature release.

Features

#70 TLS support: pgagroal - PostgreSQL
#187 Add log_mode setting
#188 Tracker: Add events for sockets
#189 Flush: Optional database argument

Enhancements

#186 Send CancelRequest when terminating a client

1.3.3

2 years ago

This is an enhancement release.

Enhancements

#184 Support Unix Domain Socket as a PostgreSQL connection
#185 Remove socket descriptor in sub-processes for killed connections v2

1.3.2

2 years ago

This is an enhancement and bug fix release.

Enhancements

#179 Check unix_socket_dir upon startup

Bug fixes

#180 Do not link shared library parts with -pie -fPIE as it breaks LTO
#181 Sub processes has open listen ports

Thanks to

@darix Reporting #180

1.3.1

2 years ago

This is an enhancement and bug fix release.

Enhancements

#172 Improve empty line parsing
#174 Account for MESSAGE_STATUS_ZERO from some clients
#175 Change non_blocking to off
#176 Add disconnect_client_force setting
#177 CLI: Add socket descriptor to details

Bug fixes

#173 Buffer for pgagroal_log_mem is too small
#178 Remove socket descriptor in sub-processes for killed connections

1.3.0

2 years ago

This is a feature release.

This release was driven by @An-DJ and his Google Summer of Code project to enhance monitoring and metrics of pgagroal.

Features

Grafana 8 dashboard
#158 Add client metrics
#159 Add pool metrics
#163 Add internal metrics

Enhancements

#153 Split the struct Prometheus from struct Configuration
#156 Add client metrics

Thanks to

@An-DJ For implementing #153, #156, #158, #159 and #163