Installing PL/pgSQL on Linux

After you install PostgreSQL, initialize a database cluster, and create a database, sde user, and sde schema, you can install the PL/pgSQL language. This component is required for you to use the database with ArcSDE.

Steps:

1. Log into psql, connecting to your new database as the sde user.

   psql agency sde
   

2. Execute the following command:

   CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler 
   VALIDATOR plpgsql_validator;