Versions Compared

    Key

    • This line was added.
    • This line was removed.
    • Formatting was changed.

    ...

    • 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:

    Backup:

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


    Restore:

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

     

    For more details, consult: https://www.postgresql.org/docs/9.6/static/backup-dump.html