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 |
dpavlin |
1.6 |
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 |
dpavlin |
1.1 |
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 |
dpavlin |
1.6 |
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 |
dpavlin |
1.1 |
share/RServ.pm perl module used by utilities in bin/ |
45 |
dpavlin |
1.3 |
|
46 |
dpavlin |
1.5 |
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 |
|
|
|