On Mon, 07 Oct 2013 13:53:19 +0200 Ingeborg Hellemo ingeborg.hellemo@uit.no wrote:
morten.brekkevold@uninett.no said:
- New program enables streamlined dumping and reloading, with optional filtering, of the NAV PostgreSQL database. This simplifies beta testing of new NAV versions by copying the production database to a test server.
What is the name of the program, where is it documented and can I use it _before_ I upgrade to 3.15?
Documentation is coming, we're writing a howto.
You only need it to migrate pre-3.15-data if you need to _filter_ stuff from your production database, otherwise a regular `pg_dump` will suffice as input to 3.15's `navsyncdb` command (see its --help option).
The `navpgdump` program has dependencies in NAV 3.15 libraries, so you cannot run it without first installing those new dependencies in your pre-3.15 installations.
From the lib/python/nav directory you need the modules `pgdump.py`,
`pgsync.py`, `colors.py` and hopefully nothing else.
When installed (and given the NAV Python libraries are available on Python's search path), the program can be invoked with "python -m nav.pgdump". NAV 3.15 has the binary shortcut command "navpgdump" for this.
$ navpgdump --help Usage: navpgdump [options]
Dumps the NAV PostgreSQL database as plain-text SQL to stdout, with optional data filtering.
Options: --version show program's version number and exit -h, --help show this help message and exit -e TABLE, --exclude=TABLE Exclude TABLE data from dump -c, --only-open-cam Only dump open CAM records -a, --only-open-arp Only dump open ARP records -f FILTER, --filter=FILTER Filter a table's contents. FILTER must match <tablename>=<SQL where clause>
The output of the program can be inserted into an empty PostgreSQL database using the psql program.