pgtoolkit.conf.example
author Radek Brich <radek.brich@devl.cz>
Wed, 26 Sep 2012 16:28:28 +0200
changeset 44 4fe39c59c515
parent 6 4ab077c93b2d
child 49 08e4dfe1b0cb
permissions -rw-r--r--
Update longqueries tool: add client IP, waiting attributes.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
2
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     1
### named connections
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     2
databases = {
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     3
  'test' : 'host=127.0.0.1 user=test password=test dbname=test'
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     4
}
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     5
44
4fe39c59c515 Update longqueries tool: add client IP, waiting attributes.
Radek Brich <radek.brich@devl.cz>
parents: 6
diff changeset
     6
### meta database (contains connection parameters for other databases)
2
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     7
meta_db = 'host=10.8.0.1 dbname=central'
44
4fe39c59c515 Update longqueries tool: add client IP, waiting attributes.
Radek Brich <radek.brich@devl.cz>
parents: 6
diff changeset
     8
# query for connection parameters, input is database name (will be placed instead of %s)
2
efee419b7a2d Fix pgmanager exceptions.
Radek Brich <radek.brich@devl.cz>
parents:
diff changeset
     9
meta_query = '''SELECT host, port, dbname, user, password FROM config.databases WHERE name = %s LIMIT 1'''