473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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_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
6 2307
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
So I replaced datetime with timestamp and it compiled okay. Just updating this as I go to help others.
Jul 31 '07 #3
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
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
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
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

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

Similar topics

17
by: Carmen Wai | last post by:
Hello: I would like to know whether there is any different in installing Postgresql on the Linux system with file system of EXT2 or EXT3. I have two machines with idential OS (Red Hat 7.3...
19
by: Alex Madon | last post by:
Hello, I am testing a web application (using the DBX PHP function to call a Postgresql backend). I have 375Mb RAM on my test home box. I ran ab (apache benchmark) to test the behaviour of the...
14
by: Manuel Tejada | last post by:
Hi My box: RedHat 9.0, Pentium III Recently I upgraded from PostgreSQL 7.3.2 to PostgreSQL 7.4.1. The PostgreSQL 7.3.2's rpms were installed from RehHat CDs The PostgreSQL 7.4.1's rpms I used...
9
by: Wei Wang | last post by:
hi, I just took over a project done by somebody else of some C extension of Postgresql 7.1.3. And now I have to port it to pl/pgsql. The guy who developed it said he didn't get it running under...
2
by: Benjamin Jury | last post by:
> -----Original Message----- > From: Christopher Browne > Sent: 10 February 2004 01:57 > To: "pgsql-admin@postgresql.org.pgsql-general"@postgresql.org > Subject: Re: book for postgresql > -...
4
by: John Small | last post by:
I want to use PostgreSQL on a project that will have to run on both Linux and Windows. But using cygwin is not a viable option. Does the dbExpert version of PostgreSQL run natively under...
1
by: Robert Fitzpatrick | last post by:
I am getting the following problem with trying to install from source PHP 4.3.6 with PG support on FreeBSD 5.2.1. I have PostgreSQL 7.4.2 recently upgraded from 7.3.x and it is up and running fine....
7
by: Eric | last post by:
Hi, Any suggestion to Rapid Application Dev with postgreSQL ? I have a small app to make. I would prefer open-source solution if possible. I also would like to developp on my linux box but...
2
by: Mike Morris | last post by:
Hi, I've setup a postgres server (7.4) and confirmed that SSL is enabled - I can successfully connect via tcp socket over SSL using the psql client. From PHP4, how can I get the pg_connect...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.