summary refs log blame commit diff
path: root/debian/synapse_port_db.ronn
blob: fcb32ebd0df80a8492e8dcd568597e08bc0c77d3 (plain) (tree)





















































































                                                                                                                       
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=<dbfile> --postgres-config=<yamlconfig> [--curses] [--batch-size=<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 <<sunil@medhas.org>> for
Debian GNU/Linux distribution.

## SEE ALSO

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