By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 901 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

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

Psychopsam
P: 10
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_table ('customers');

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

ERROR: function pgr_replica_table("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?
Jul 30 '07 #1
Share this Question
Share on Google+
6 Replies


Psychopsam
P: 10
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_monitor" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:4: ERROR: relation "pgr_monitor" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:16: ERROR: relation "pgr_monitor" does not exist
psql:/home/replicator/pgreplica/bin/Rlayout/grant-revoke.sql:17: ERROR: relation "pgr_monitor" does not exist
Jul 30 '07 #2

Psychopsam
P: 10
So I replaced datetime with timestamp and it compiled okay. Just updating this as I go to help others.
Jul 31 '07 #3

Psychopsam
P: 10
I got stuck on this error...

function pgr_gxid_f (integer, biginteger) unknown

...when running the command

select pgr_replica_table ('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.
Jul 31 '07 #4

Psychopsam
P: 10
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.
Jul 31 '07 #5

P: 17
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.please 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
Aug 4 '07 #6

Psychopsam
P: 10
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
Aug 10 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.