| From: | Antonello Piemonte <ap(at)cyberlab(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | dbmirror install |
| Date: | 2002-10-10 15:07:38 |
| Message-ID: | 200210101507.g9AF7eZ26136@gg.cyberlab.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
hello,
if anyone has experience with dbmirror.pl please advise:
I am installing dbmirror (from contrib tree): I compiled it under
the source tree of postgresql-7.3b2 and everything went fine:
since I need to test it on a postgres-7.1.3 installation (which does not
include dbmirror) I then copied the pending.so (is the result of the "make"
issued in postgresql-7.3b2/contrib/dbmirror) to the test server in
/usr/lib/pgsql/contrib/dbmirror/pending.so and made a simlink as follows:
$ ls -l /usr/local/pgsql/lib/pending.so
lrwxrwxrwx 1 root root 42 Oct 10 16:03
/usr/local/pgsql/lib/pending.so -> /usr/lib/pgsql/contrib/dbmirror/pending.so
(note that I use redhat7.2 on both machines) then I get this error:
$ psql mydb < MirrorSetup.sql
ERROR: parser: parse error at or near "trigger"
where the first lines of MirrorSetup.sql are:
bash-2.05$ cat MirrorSetup.sql
CREATE FUNCTION "recordchange" () RETURNS trigger AS
'/usr/local/pgsql/lib/pending.so', 'recordchange' LANGUAGE 'C';
........
I have also set PL/pgSQL
$ createlang -l mydb
Procedural languages
Name | Trusted? | Compiler
---------+----------+----------
plpgsql | t | PL/pgSQL
(1 row)
what have I missed?
thx
antonello
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Langille | 2002-10-10 15:11:11 | Re: Upgrade to new version |
| Previous Message | Bruce Momjian | 2002-10-10 14:33:54 | Re: Upgrade to new version |