pg_start_sql 0.0.1

This Release
pg_start_sql 0.0.1
Date
Status
Testing
Abstract
runs SQL statement at instance start
Released By
pifor
License
PostgreSQL
Resources
Special Files
Tags

Extensions

pg_start_sql 0.0.1
runs SQL statement at instance start

README

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 and 13.

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.