File: INSTALL

package info (click to toggle)
postgresql-plsh 1.3-3.1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 1,364 kB
  • ctags: 39
  • sloc: sh: 8,849; ansic: 420; makefile: 62; sql: 30
file content (33 lines) | stat: -rw-r--r-- 1,013 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
PL/sh Installation Instructions
===============================

You need to have PostgreSQL 7.4 or later, and you need to have the
server include files installed.

To build and install PL/sh, use this procedure: 

./configure --prefix=YOUR_CHOICE
make
make install

The include files are found using the pg_config program that is
included in the PostgreSQL installation.  To use a different
PostgreSQL installation, point configure to a different pg_config like
so:

./configure ... PG_CONFIG=/else/where/pg_config

Note that generally server-side modules such as this one have to be
recompiled for every major PostgreSQL version (that is, 7.4, 8.0,
...).

To declare the language in a database, use 

psql -d DBNAME -f PREFIX/share/pgplsh/createlang_pgplsh.sql

with a server running.  To drop it, use "droplang plsh", or DROP
FUNCTION plsh_handler(); DROP LANGUAGE plsh; if you want to do it
manually.

If you checked out the source code from CVS, run "autoreconf -i" first
to set up the build infrastructure.