viewvc.cgi/rserv/README

RServ improved by community version 0.3-pre2

https://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
doc/rserv-design.txt    design notes for version 0.3
doc/rserv-explained.pod explanation of RServ working (use perldoc to view)
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
misc/regress.sh         original regress script
misc/slave.sql          database schema for slave (changed)
misc/rserv_test.pl      bulk inserter for populating database
misc/rep-demo.sql       test database for regression test
misc/qa.sh              regression test script
misc/rserv_init.pl      init master and slave database automatically
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	RServ improved by community version 0.3-pre2
2
3	https://www.rot13.org/~dpavlin/projects/rserv/
4	http://gborg.postgresql.org/project/rservimp/projdisplay.php
5
6	RServ offers replication capabilities for PostgreSQL. This is improved
7	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	changes made by Nélio Alves Pereira Filho and Dobrica Pavlinusic and
12	contributions from Grant McLean.
13
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	doc/rserv-design.txt design notes for version 0.3
33	doc/rserv-explained.pod explanation of RServ working (use perldoc to view)
34	lib/ contains C source code for rserv.so used by trigger
35	in RServ
36	misc/master.sql database schema of RServ specific part in master
37	database with comments
38	misc/regress.sh original regress script
39	misc/slave.sql database schema for slave (changed)
40	misc/rserv_test.pl bulk inserter for populating database
41	misc/rep-demo.sql test database for regression test
42	misc/qa.sh regression test script
43	misc/rserv_init.pl init master and slave database automatically
44	share/RServ.pm perl module used by utilities in bin/
45
46	Nice accompanying project is pgdiff (also from Dobrica Pavlinusic) available at
47	http://gborg.postgresql.org/project/pgdiff/projdisplay.php
48	compares the structures and data of two PostgreSQL databases (master and
49	slave) and returns the differences as a sequence of SQL commands which can
50	be fed to psql on slave to transform the structure and data from master to
51	slave.
52	It can be used to make regression testing of RServ replication (that's why I
53	originally written it).
54