Skip to content

Latest commit

 

History

History
87 lines (59 loc) · 2.44 KB

synapse_port_db.ronn

File metadata and controls

87 lines (59 loc) · 2.44 KB
Raw

synapse_port_db(1) -- A script to port an existing synapse SQLite database to a new PostgreSQL database.

SYNOPSIS

synapse_port_db [-v] --sqlite-database= --postgres-config= [--curses] [--batch-size=]

DESCRIPTION

synapse_port_db ports an existing synapse SQLite database to a new PostgreSQL database.

SQLite database is specified with --sqlite-database option and PostgreSQL configuration required to connect to PostgreSQL database is provided using --postgres-config configuration. The configuration is specified in YAML format.

OPTIONS

  • -v: Print log messages in debug level instead of info level.

  • --sqlite-database: The snapshot of the SQLite database file. This must not be currently used by a running synapse server.

  • --postgres-config: The database config file for the PostgreSQL database.

  • --curses: Display a curses based progress UI.

CONFIG FILE

The postgres configuration file must be a valid YAML file with the following options.

  • database: Database configuration section. This section header can be ignored and the options below may be specified as top level keys.

    • name: Connector to use when connecting to the database. This value must be psycopg2.

    • args: DB API 2.0 compatible arguments to send to the psycopg2 module.

      • dbname - the database name

      • user - user name used to authenticate

      • password - password used to authenticate

      • host - database host address (defaults to UNIX socket if not provided)

      • port - connection port number (defaults to 5432 if not provided)

    • synchronous_commit: Optional. Default is True. If the value is False, enable asynchronous commit and don't wait for the server to call fsync before ending the transaction. See: https://www.postgresql.org/docs/current/static/wal-async-commit.html

Following example illustrates the configuration file format.

database:
  name: psycopg2
  args:
    dbname: synapsedb
    user: synapseuser
    password: ORohmi9Eet=ohphi
    host: localhost
  synchronous_commit: false

COPYRIGHT

This man page was written by Sunil Mohan Adapa <[email protected]> for Debian GNU/Linux distribution.

SEE ALSO

synctl(1), hash_password(1), register_new_matrix_user(1)