Preface

Purpose of this document

This book describes the userlog, an extension of PostgreSQL.

Reader of this book

This document is intended for those who use the userlog feature.

This manual assumes that you have a general knowledge of the following:

PostgreSQL
SQL
Knowledge of Linux

Structure of this document

This document is structured as follows:

Chapter 1 Userlog Feature Overview: Describes the userlog feature.

Chapter 2 Setup: Describes how to set up userlogs.

Chapter 3 Operation: Describes the operation of userlogs.

Chapter 4 Unsetup: Describes unsetting up userlogs.

Chapter 5 How to Insert a Userlog (pgx_emit_userlog Function): Describes how to insert userlogs.

Chapter 6 Messages: Describes the messages in the userlog.

Appendix A Userlog File Format: Describes the format of userlog files.

Appendix B pgx_stat_userlog View: Describes the pgx_stat_userlog view.

Appendix C pgx_userlog_control Command: Describes the pgx_userlog_control command.

Export restrictions

Exportation/release of this document may require necessary procedures in accordance with the regulations of your resident country and/or US export control laws.

Issue date and version

Edition 2.0: March 2025
Edition 1.0: December 2024