viewvc.cgi/rserv/README

RServ improved by community version 0.3-pre2

http://www.rot13.org/~dpavlin/projects/rserv/
http://gborg.postgresql.org/project/rservimp/projdisplay.php

RServ offers replication capabilities for PostgreSQL. This is improved
version of original code by PostgreSQL Inc. included in contrib part of
distribution.

Originally written by Vadim Mikheev from PostgreSQL Inc., it also include
changes made by Nélio Alves Pereira Filho and Dobrica Pavlinusic and
contributions from Grant McLean.

Main goals are secure remote replication using ssh, ease of installation and
documentation. We aim to create stable and easy to use replication until
PGReplication is included in official PostgreSQL. However, it's not planned
to discontinue project at that time. You will just have choice of two
replication mechanisms.

This project is released under the Berkeley/BSD license. 


FILES

This is my attempt to describe files in this distribution.

bin/                    mostly perl utilities which are required for RServ
doc/                    contains documentation about RServ collected from various sources
doc/README.rserv        original README for RServ 0.1
doc/eRserver.ChangeLog  non-english ChangeLog from Nélio
doc/eRserver.HOWTO      not quite accurate HOWTO from Sekar Gopi
lib/                    contains C source code for rserv.so used by trigger in RServ
misc/master.sql         database schema of RServ specific part in master database
                        with comments for RServ 0.1 (changed by now)
misc/regress.sh         original regress script
misc/slave.sql          database schema for slave (changed)
misc/rserv_test.pl      bulk inserter for populating database
share/RServ.pm          perl module used by utilities in bin/


Nice accompanying project is pgdiff (also from Dobrica Pavlinusic) available at
http://gborg.postgresql.org/project/pgdiff/projdisplay.php
compares the structures and data of two PostgreSQL databases (master and
slave) and returns the differences as a sequence of SQL commands which can
be fed to psql on slave to transform the structure and data from master to
slave.
It can be used to make regression testing of RServ replication (that's why I
originally written it).

1	dpavlin	1.3	RServ improved by community version 0.3-pre2
2	dpavlin	1.1
3			http://www.rot13.org/~dpavlin/projects/rserv/
4			http://gborg.postgresql.org/project/rservimp/projdisplay.php
5
6	dpavlin	1.2	RServ offers replication capabilities for PostgreSQL. This is improved
7	dpavlin	1.1	version of original code by PostgreSQL Inc. included in contrib part of
8			distribution.
9
10			Originally written by Vadim Mikheev from PostgreSQL Inc., it also include
11	dpavlin	1.4	changes made by Nélio Alves Pereira Filho and Dobrica Pavlinusic and
12			contributions from Grant McLean.
13	dpavlin	1.1
14			Main goals are secure remote replication using ssh, ease of installation and
15			documentation. We aim to create stable and easy to use replication until
16			PGReplication is included in official PostgreSQL. However, it's not planned
17			to discontinue project at that time. You will just have choice of two
18			replication mechanisms.
19
20			This project is released under the Berkeley/BSD license.
21
22
23			FILES
24
25			This is my attempt to describe files in this distribution.
26
27			bin/ mostly perl utilities which are required for RServ
28			doc/ contains documentation about RServ collected from various sources
29			doc/README.rserv original README for RServ 0.1
30			doc/eRserver.ChangeLog non-english ChangeLog from Nélio
31			doc/eRserver.HOWTO not quite accurate HOWTO from Sekar Gopi
32			lib/ contains C source code for rserv.so used by trigger in RServ
33			misc/master.sql database schema of RServ specific part in master database
34			with comments for RServ 0.1 (changed by now)
35			misc/regress.sh original regress script
36			misc/slave.sql database schema for slave (changed)
37			misc/rserv_test.pl bulk inserter for populating database
38			share/RServ.pm perl module used by utilities in bin/
39	dpavlin	1.3
40
41	dpavlin	1.5	Nice accompanying project is pgdiff (also from Dobrica Pavlinusic) available at
42			http://gborg.postgresql.org/project/pgdiff/projdisplay.php
43			compares the structures and data of two PostgreSQL databases (master and
44			slave) and returns the differences as a sequence of SQL commands which can
45			be fed to psql on slave to transform the structure and data from master to
46			slave.
47			It can be used to make regression testing of RServ replication (that's why I
48			originally written it).
49