Thread: pgmirror

pgmirror

From
Theo Galanakis
Date:
<p><font face="Arial" size="2">Hi,</font><br />        <font face="Arial" size="2">I need some help getting dbMirror
working.I have installed the contrib RPM package for Redhat Linux. However it hasn't copied all the necessary files for
dbMirror.I could only find pending.so.</font><p>        <font face="Arial" size="2">I have tried coping the other files
from:      </font><a href="http://developer.postgresql.org/docs/pgsql/contrib/dbmirror/"><u><font color="#0000FF"
face="Arial"size="2">http://developer.postgresql.org/docs/pgsql/contrib/dbmirror/</font></u></a><p>        <font
face="Arial"size="2">then running the MirrorSetup.sql, however it returned the following error :</font><p>        <font
face="Arial"size="2">psql:MirrorSetup.sql:52: ERROR:  could not find function "nextval" in file     
"/usr/lib/pgsql/pending.so"</font><p>       <font face="Arial" size="2">So I assume I need to compile pending.c. I need
somehelp in doing so? </font><p>        <font face="Arial" size="2">Im running RedHat Linux ES3 with Postgres
7.4.5.</font><p><fontface="Arial" size="2">Regards,</font><br />        <font face="Arial" size="2">Theo</font><br
/><br/><br /><table><tr><td bgcolor="#ffffff"><font
color="#000000">______________________________________________________________________<br/> This email, including
attachments,is intended only for the addressee<br /> and may be confidential, privileged and subject to copyright. If
you<br/> have received this email in error, please advise the sender and delete<br /> it. If you are not the intended
recipientof this email, you must not<br /> use, copy or disclose its content to anyone. You must not copy or <br />
communicateto others content that is confidential or subject to <br /> copyright, unless you have the consent of the
contentowner.<br /></font></td></tr></table> 

Re: pgmirror

From
Theo Galanakis
Date:
<p><font size="2">Thanks for your response, however can you please translate, my Greek is not the best.</font><p><font
size="2">-----OriginalMessage-----</font><br /><font size="2">From: Achilleus Mantzios [<a
href="mailto:achill@matrix.gatewaynet.com">mailto:achill@matrix.gatewaynet.com</a>]</font><br /><font size="2">Sent:
Friday,14 January 2005 6:57 PM</font><br /><font size="2">To: Theo Galanakis</font><br /><font size="2">Subject: Re:
[SQL]pgmirror</font><br /><p><font size="2">O Theo Galanakis έγραψε στις Jan 14, 2005 :</font><p><font size="2">>
</font><br/><font size="2">> Hi,</font><br /><font size="2">>       I need some help getting dbMirror working. I
haveinstalled the </font><br /><font size="2">> contrib RPM package for Redhat Linux. However it hasn't copied all
the</font><br /><font size="2">> necessary files for dbMirror. I could only find pending.so.</font><p><font
size="2">Mhnto kaneis me apt-get,rpm,pkg-add,portinstall, (put your fav pckg </font><br /><font size="2">sys here)
etc...</font><p><fontsize="2">Apla phgaine sto contrib dir:</font><p><font size="2">cd contrib/dbmirror</font><br
/><fontsize="2">gmake ; gmake install</font><p><font size="2">Epishs exw grapsei ena feature wste to dbmirror na
kanei</font><br/><font size="2">kai conditional replication.</font><br /><font size="2">Opoios endiaferetai edw to
exw!</font><p><fontsize="2">> </font><br /><font size="2">>       I have tried coping the other files from :
</font><br/><font size="2">> <a href="http://developer.postgresql.org/docs/pgsql/contrib/dbmirror/"
target="_blank">http://developer.postgresql.org/docs/pgsql/contrib/dbmirror/</a></font><br/><font size="2">> <<a
href="http://developer.postgresql.org/docs/pgsql/contrib/dbmirror/"
target="_blank">http://developer.postgresql.org/docs/pgsql/contrib/dbmirror/</a>></font><br/><font size="2">>
</font><br/><font size="2">>       then running the MirrorSetup.sql, however it returned the following </font><br
/><fontsize="2">> error :</font><br /><font size="2">> </font><br /><font size="2">>      
psql:MirrorSetup.sql:52:ERROR:  could not find function "nextval"</font><br /><font size="2">> in file      
"/usr/lib/pgsql/pending.so"</font><br/><font size="2">> </font><br /><font size="2">>       So I assume I need to
compilepending.c. I need some help in doing </font><br /><font size="2">> so?</font><br /><font size="2">>
</font><br/><font size="2">>       Im running RedHat Linux ES3 with Postgres 7.4.5.</font><br /><font size="2">>
</font><br/><font size="2">> Regards,</font><br /><font size="2">>       Theo</font><br /><font size="2">>
</font><br/><font size="2">> </font><br /><font size="2">> </font><br /><font size="2">> </font><br /><font
size="2">></font><br /><font size="2">> </font><br /><font size="2">>
______________________________________________________________________</font><br/><font size="2">> This email,
includingattachments, is intended only for the addressee </font><br /><font size="2">> and may be confidential,
privilegedand subject to copyright.  If you </font><br /><font size="2">> have received this email in error, please
advisethe sender and delete </font><br /><font size="2">> it.  If you are not the intended recipient of this email,
youmust not </font><br /><font size="2">> use, copy or disclose its content to anyone.  You must not copy or
</font><br/><font size="2">> communicate to others content that is confidential or subject to </font><br /><font
size="2">>copyright, unless you have the consent of the content owner.</font><p><font size="2">-- </font><br /><font
size="2">-Achilleus</font>