The PoWA team is pleased to announce the release of the version 2.3.0 ofpg_stat_kcache, an extension that gathers statistics about real reads and writes done by the ...
We are very glad to announce the 4.5.0 version of E-Maj. E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database. This version brings the ...
Nordic PGDay will once again return to Copenhagen for a day of PostgreSQL by the sea on March 18 2025. Nordic PGDay is a one-day single track event (with an adjoining sponsor track) focusing on ...
When logging_collector is enabled, this parameter sets the file names of the created log files. The value is treated as a strftime pattern, so %-escapes can be used to specify time-varying file names.
RETURN with an expression terminates the function and returns the value of expression to the caller. This form is used for PL/pgSQL functions that do not return a set. In a function that returns a ...
pg_basebackup is used to take base backups of a running PostgreSQL database cluster. These are taken without affecting other clients to the database, and can be used both for point-in-time recovery ...
If you have pattern matching needs that go beyond this, consider writing a user-defined function in Perl or Tcl. While most regular-expression searches can be executed very quickly, regular ...
pg_restore — restore a PostgreSQL database from an archive file created by pg_dump Restore only the data, not the schema (data definitions). Table data, large objects, and sequence values are restored ...