Setting Advanced Server Environment Variables v10

The graphical installer provides a script that simplifies the task of setting environment variables for Windows users. The script sets the environment variables for your current shell session; when your shell session ends, the environment variables are destroyed. You may wish to invoke pgplus_env or pg_env from your system-wide shell startup script, so that environment variables are automatically defined for each shell session.

The pgplus_env script is created during the Advanced Server installation process and reflects the choices made during installation. To invoke the script, open a command line and enter:

C:\Program Files\edb\10AS\pgplus_env.bat

As the pgplus_env.bat script executes, it sets the following environment variables:

PATH="C:\Program Files\edb\as10\bin";%PATH%
EDBHOME=C:\Program Files\edb\as10
PGDATA=C:\Program Files\edb\as10\data
PGDATABASE=edb
REM @SET PGUSER=enterprisedb
PGPORT=5444
PGLOCALEDIR=C:\Program Files\edb\as10\share\locale

If you have used an installer created by EnterpriseDB to install PostgreSQL, the pg_env script performs the same function. To invoke the pg_env script, open a command line, and enter:

C:\Progra~1\PostgreSQL\10\pg_env.bat

As the pg_env.bat script executes, it sets the following environment variables:

PATH="C:\Program Files\PostgreSQL\10\bin";%PATH%
PGDATA=C:\Program Files\PostgreSQL\10\data
PGDATABASE=postgres
PGUSER=postgres
PGPORT=5432
PGLOCALEDIR=C:\Program Files\PostgreSQL\10\share\locale