Location of PostgreSQL Files in an LCE Installation

File Location Notes
Data files tracelogs directory/postgresql None.
Persistent configuration tracelogs directory/postgresql Primary config file is postgresql.conf.
Tracelog tracelogs directory/postgresql


Expect two tracelog files: startup.log and server.log.

Binaries /opt/lce/postgresql/bin  
Dynamic libraries /opt/lce/postgresql/lib To run any of the PostgreSQL binaries (see directly above), your LD_LIBRARY_PATH environment variable must include this directory. The source-for-psql-shortcuts.sh script will do this for you. For more information, see Shortcuts for Running SQL Commands and Scripts.
Setup scripts, timezone rule files, text-search (TS) support files /opt/lce/postgresql/share None.