A far cry - but here's hoping - PostgreSQL Replicator

[Psychopsam]

Now I realise this might be out of scope for this forum, but maybe someone knows the answer.

I've just started setting up a test PostgreSQL Replicator set of db's and when I run this command...

select pgr_replica_tab le ('customers');

I get the following error - and yes pgrd (the daemon is running)

ERROR: function pgr_replica_tab le("unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.

It's like postgresql replicator isn't even there, if though it says it's running...

Anyone know why I might be getting this error?

[Psychopsam]

Well I solved that problem by using this command to load pltcl.so.

yum -y install postgresql postgresql-server postgresql-devel postgresql-tcl postgresql-pl

Now I have a new problem. It get these errors when I try to createdbr...

I'm seeing similar errors on forums around the 'net without responses and I'm starting to think people may have abandoned PostreSQL Replicator in favour of a better product perhaps?

Andy H.

psql:/home/replicator/pgreplica/bin/Rlayout/create_RST.sql: 23: ERROR: type "datetime" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/create_RST.sql: 36: ERROR: type "datetime" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/create_RST.sql: 107: ERROR: type "datetime" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:1: ERROR: relation "pgr_monito r" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:4: ERROR: relation "pgr_monito r" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:16: ERROR: relation "pgr_monito r" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:17: ERROR: relation "pgr_monito r" does not exist

[Psychopsam]

So I replaced datetime with timestamp and it compiled okay. Just updating this as I go to help others.

[Psychopsam]

I got stuck on this error...

function pgr_gxid_f (integer, biginteger) unknown

...when running the command

select pgr_replica_tab le ('customers');

...but fixed it by changing this...

This is fixed by changing the second parameter to int8 in pgr_gxid_f.sql like this...
pgr_gxid_f (int4, int8)

save, restart postgresql, recreate your database going back to the ./creatdbr command.

[Psychopsam]

Now when I run the command ./pgr -sync <dbname> it can't connect...

pgr - postgreSQL replicator
Version: 1.1.0
17:44:17 trying to connect to database on localhost (port 5432)
17:44:20 trying to connect to database on localhost (port 5432)
17:44:23 trying to connect to database on localhost (port 5432)
invalid command name "pg_connect "

So this is where I'm stuck. I can ping both computers and they are listening for pgr on port 5430 and postgres on 5432 but there is not connection happening.

I would appreciate any help any can offer.

[ramesh1210]

Is the PostgreSQL Replicator working for postgre7.3 or postgre7.4 or any other higher versions.If you have the answer please reply me.You said that you are working on PostgreSQL Replicator.plea se tell me which version of the replicator you are using and from where should i download it.Please reply me.I will be thankfull for your help

[Psychopsam]

I'm using this

http://pgreplicator.sourceforge.net/...ator-1.1.0.tgz

ontop of Postgres 8.1 installed using yum...

yum -y install postgresql postgresql-server postgresql-devel postgresql-tcl postgresql-pl