Versions Compared


    • This line was added.
    • This line was removed.
    • Formatting was changed.
    Comment: Published by Scroll Versions from this space and version 7.0-2


    • supervisor_logfile: /var/spool/supelog
    • supervisor_logpath: /var/spool/qube
    • qb_directory: /usr/local/pfx/qube
    • /etc/my.conf/etc/qb.conf
    • /etc/qbwrk.conf
    • /etc/init.d/supervisor
    • MySQL data_dir: /var/lib/mysql
    • PostgreSQL data directory:
      • /usr/local/pfx/pgsql/data (Linux)
      • /Applications/pfx/pgsql/data (Mac)
      • C:\Program Files\pfx\pgsql\data (Windows)

    To back up the PostgreSQL database, you can make a copy of the data directory as listed above, or use PostgreSQL's pg_dump and/or pg_dumpall tool

    The pg_dump tool can be found in /usr/local/pfx/pgsql/bin (Linux), /Applications/pfx/pgsql/bin (Mac), C:\Program Files\pfx\pgsql\bin (Windows).


    Following are examples for Linux:


    Code Block
    pg_dumpall -p 50055 -U pfx > /some/path/to/backup.dump


    Code Block
    /usr/local/pfx/qube/utils/pgsql/ --erase
    /usr/local/pfx/pgsql/bin/psql -p 50055 -U postgres -d pfx -f /some/path/to/backup.dump


    For more details, consult: