pg_start_sql

PostgreSQL extension to execute SQL statements at instance start.

Installation

Compiling

This module can be built using the standard PGXS infrastructure. For this to work, the pg_config program must be available in your $PATH:

git clone https://github.com/pierreforstmann/pg_start_sql.git
cd pg_start_sql
make
make install

PostgreSQL setup

Extension must be loaded:

At server level with shared_preload_libraries parameter:
shared_preload_libraries = 'pg_start_sql'
And following SQL statement should be run:
create extension pg_start_sql;

This extension is installed at instance level: it does not need to be installed in each database.

pg_start_sql has been successfully tested with PostgreSQL 9.5, 9.6, 10, 11, 12, 13, 14, 15 and 16.

Usage

pg_start_sql has 3 GUC parameters:

• pg_start_sql.dbname which is the database name where SQL statements must be run. This parameter is not mandatory : if not specified SQL statement is run in postgres database.
• pg_start_sql.stmt which is the SQL statement to be run.
• pg_start_sql.file which is a file name whose SQL statements are to be run. At least one of the parameterspg_start_sql.stmt or pg_start_sql.file must be specified.

Statements are run with superuser privileges. There is no way to specify another database user to run SQL statements.