Installation Manual: PostgreSQL (2025)

Operating Systems¶

• Windows 2000/XP/2003/Vista/2008 (32-bit and 64-bit)

• Linux (all modern distributions, 32-bit and 64-bit)

• Mac OS X (10.5 Leopard and 10.6 Snow Leopard 64 bit)

Database Servers¶

• PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4

Tested Configurations¶

Bingo has been successfully tested on the following configurations:

All Systems¶

The shared buffer parameter in the PostgreSQL database configurationfile (postgresql.conf) should be increased. For the optimal performanceit is recommended to increase the value .

shared_buffers=128MB

Linux¶

The Bingo engine requires a lot of shared memory. For linux systems our teamrecommends to change kernel.shmmax and kernel.shmall

Add the following line to /etc/sysctl.conf file:

kernel.shmmax=<value>kernel.shmall=<value>

The recommended value is appr. 50% of the RAM (in bytes)

Execute (with the root privileges)

sysctl -p /etc/sysctl.conf

All Systems¶

Download and unzip the cartridge archive. The Bingo library is locatedin the ‘bin’ directory (bingo_postgres.dll for WINDOWS, orbingo_postgres.so for LINUX, or bingo_postgres.dylib for MacOSX). TheBingo library is built with specific PostgreSQL headers, so there is noneed to run the building procedure. You can simply run the pre-generatedSQL script with specified path to the Bingo library.

1. Copy the library file to a desired directory. The library can becopied into the PostgreSQL package directory ({POSTGRES_HOME}/libby default). In the second case the -pglibdir option should beadded to the SQL-gen script (see the full options list below)

2. Run SQL-gen script (specific for an OS). The script generates two SQLscripts:

   bingo_install.sql

   bingo_uninstall.sql

The bingo_install.sql installs all the functions and proceduresrelated to the Bingo cartridge.

1. Execute the script from the database. Usually it can be done by thefollowing command:

   psql -U $admin -d $database -f bingo_install.sql

There are several important notes below.

Note: The installation can be done only to an existing database.

Note: You must have an admin role to install bingo cartridge on yourdatabase.

Note: The installation script creates a new schema (usuallybingo),with the default tablespace. Please consider, that thespecifying schema will be deleted while calling the uninstall script,thus the installer checks for a schema name and will raise an error if aschema already exists.

Note: You cannot install Bingo on top of the existing installation.You have to drop the cartridge schema (usually bingo) of theexisting installation.

Note: You cannot install Bingo on a different PostgreSQL version,say, if you have PostgreSQL 9.1 and the Bingo library for the version9.0 then you can get unexpected crashes.

Linux¶

Run the bingo-pg-install.sh file located in the root folder of theBingo installation file set. The help message from the script is thefollowing:

Usage: bingo-pg-install.sh [parameters]Parameters:-?, -help Print this help message-libdir path Target directory with the installed bingo_postgres.so (defaut {CURRENT_DIR}/bin/).-schema name Postgres schema name (default "bingo").-pglibdir Use PostgreSQL $libdir option (default "false") Notice: bingo_postgres.so must be placed in the package library directory-y Process default options (default "false")

Execute bingo_install.sql for your database.

Windows¶

Run the bingo-pg-install.bat file located in the root folder of theBingo installation file set. The help message from the script is thefollowing:

Usage: bingo-pg-install.bat [parameters]Parameters:-?, -help Print this help message-libdir path Target directory with the installed bingo_postgres.dll (defaut {CURRENT_DIR}/bin/).-schema name Postgres schema name (default "bingo").-pglibdir Use PostgreSQL $libdir option (default "false") Notice: bingo_postgres.dll must be placed in the package library directory-y Process default options (default "false")

Execute bingo_install.sql for your database.

Mac OS X¶

Run the bingo-pg-install.sh file located in the root folder of theBingo installation file set. The help message from the script is thefollowing:

Usage: bingo-pg-install.sh [parameters]Parameters:-?, -help Print this help message-libdir path Target directory with the installed bingo_postgres.dylib (defaut {CURRENT_DIR}/bin/).-schema name Postgres schema name (default "bingo").-pglibdir Use PostgreSQL $libdir option (default "false") Notice: bingo_postgres.dylib must be placed in the package library directory-y Process default options (default "false")

Execute bingo_install.sql for your database.

Examples¶

For the most simple installation, the defaults are taken:CURRENT_DIR/bin directory for binary, bingo for the schema name,test for the database name and postgres for the admin user.

bingo-pg-install.shpsql -U postgres -d test -f bingo_install.sql

If you have copied the library to the directory ‘/home/myself/’:

bingo-pg-install.sh -libdir /home/myselfpsql -U postgres -d test -f bingo_install.sql

If you have copied the library to the PostgreSQL package directory‘/usr/lib/postgresql/9.0/lib/’ and want to create another bingo2schema for storing the procedures :

bingo-pg-install.sh -pglibdir -schema bingo2psql -U postgres -d test -f bingo_install.sql

Checking the Installation¶

To check that the shared library file is loaded properly by Postgres,you can try this simple query:

SELECT Bingo.GetVersion();