---
name: "londiste"
section: "5"
platform: "linux"
package: "skytools"
version: "2.1.13-2"
release: "Debian 7 (Wheezy)"
platforms: ["linux"]
url: "https://new.carta.tech/londiste/5"
---

# londiste(5)

PostgreSQL replication engine written in python

## NAME

londiste - PostgreSQL replication engine written in python

## SYNOPSIS

```
[londiste]
job_name = asd
```

## DESCRIPTION

The londiste configuration file follow the famous .INI syntax. It contains only one section named londiste.

Most defaults values are reasonable ones. That means you can only edit provider\_db, subscriber\_db and pgq\_queue\_name and be done with londiste configuration.

## OPTIONS

You can configure the following options into the londiste section.

job\_name

Each Skytools daemon process must have a unique job\_name. Londiste uses it also as consumer name when subscribing to queue.

provider\_db

Provider database connection string (DSN).

subscriber\_db

Subscriber database connection string (DSN).

pgq\_queue\_name

Name of the queue to read from. Several subscribers can read from same queue.

logfile

Where to log londiste activity.

pidfile

Where to store the pid of the main londiste process, the replay one.

lock\_timeout

Few operations take lock on provider (provider add/remove, compare, repair). This parameter specifies timeout in seconds (float) how long a lock can be held. New in version 2.1.8. Default: 10

loop\_delay

How often to poll events from provider. In seconds (float). Default: 1.

pgq\_lazy\_fetch

How many events to fetch at a time when processing a batch. Useful when you know a single transaction (maintenance UPDATE command, e.g.) will produce a lot of events in a single batch. When lazily fetching, a cursor is used so as to still process a single batch in a single transaction. Default: 0, always fetch all events of the batch, not using a cursor.

log\_count

Number of log files to keep. Default: 3

log\_size

Max size for one log file. File is rotated if max size is reached. Default: 10485760 (10M)

use\_skylog

If set, search for \[./skylog.ini, ~/.skylog.ini, /etc/skylog.ini\]. If found then the file is used as config file for Pythons logging module. It allows setting up fully customizable logging setup. Default: 0

## EXAMPLE

```
[londiste]
job_name = test_to_subcriber
```

```
provider_db = dbname=provider port=6000 host=127.0.0.1
subscriber_db = dbname=subscriber port=6000 host=127.0.0.1
```

```
# it will be used as sql ident so no dots/spaces
pgq_queue_name = londiste.replika
```

```
logfile = /tmp/%(job_name)s.log
pidfile = /tmp/%(job_name)s.pid
```

## SEE ALSO

[londiste(1)](/londiste/1.md)