PGSQL File Hierarchy Structure

    The following parameters are related to the PostgreSQL database dir:

    • : Postgres default user’s home dir, default is .
    • pg_bin_dir: Postgres binary dir, defaults to /usr/pgsql/bin/.
    • : Postgres database dir, default is /pg/data.
    • pg_fs_main: Postgres main data disk mount point, default is /export.

    The installation playbook automatically creates a soft link to the currently installed version. For example, if version 14 of Postgres is installed, there are.

    Pigsty assumes at least one primary data disk (pg_fs_main) and an optional backup data disk () on the single node used to deploy the database instance. Usually, the primary data disk is a high-performance SSD, while the backup disk is a high-capacity inexpensive HDD.

    • pgbouncer.ini: the main config file
    • userlist.txt: lists the users in the connection pool
    • pgb_hba.conf: lists the access privileges of the connection pool users
    • : lists the databases in the connection pool