|
Home > Archive > Slony1 PostgreSQL Replication > September 2005 > Compile
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Sebastian Kühner 2005-09-07, 9:23 am |
| Hello,
I'm using slony with the source code of postgres 8 now and it works fine.
What I want to do: Use slony with a postgresql package for Slackware (I'm
using Slackware Linux). I think I will have problems with the configuration,
because the config-file needs the postgresql include path.
Is there any way to handle this?
Thanks for your help!
Sebastian
| |
|
|
| Sebastian Kühner 2005-09-07, 11:24 am |
| Hi!
Thanks for your answer. I downloaded the source code of postgresql ... it's
the same version like in the package.
I made a ./configure, make, make install and make install-all-headers and I
was able to configure and install slony.
The problem that I have now is, that I can't run my setup_cluster.sh script
anymore. There appears the following error:
ERROR: could not access file "$libdir/xxid": No such file or directory
<stdin>:4: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not
access file "$libdir/xxid": No such file or directory
<stdin>:4: Error: the extension for the xxid data type cannot be loaded in
database 'dbname=contactdb host=localhost user=postgres'
<stdin>:4: ERROR: no admin conninfo for node 134583256
Does anybody know what that means??
Many thanks!
Sebastian
----- Original Message -----
From: "Tim Goodaire" <tgoodair-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org>
To: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
Sent: Wednesday, September 07, 2005 12:13 PM
Subject: Re: [Slony1-general] Compile
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general
>
| |
| Brad Nicholson 2005-09-07, 11:24 am |
| There is a FAQ entry for this:
http://linuxfinances.info/info/faq.html#AEN41935
Sebastian K=FChner wrote:
>Hi!
>
>Thanks for your answer. I downloaded the source code of postgresql ... i=
t's
>the same version like in the package.
>
>I made a ./configure, make, make install and make install-all-headers an=
d I
>was able to configure and install slony.
>
>The problem that I have now is, that I can't run my setup_cluster.sh scr=
ipt
>anymore. There appears the following error:
>
>ERROR: could not access file "$libdir/xxid": No such file or directory
><stdin>:4: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not
>access file "$libdir/xxid": No such file or directory
><stdin>:4: Error: the extension for the xxid data type cannot be loaded =
in
>database 'dbname=3Dcontactdb host=3Dlocalhost user=3Dpostgres'
><stdin>:4: ERROR: no admin conninfo for node 134583256
>
>Does anybody know what that means??
>
>Many thanks!
>
>Sebastian
>
>
>
>
>----- Original Message -----=20
>From: "Tim Goodaire" <tgoodair-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org>
>To: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
>Sent: Wednesday, September 07, 2005 12:13 PM
>Subject: Re: [Slony1-general] Compile
>
>
> =20
>
>
> ____________________
____________________
_______
>Slony1-general mailing list
>Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
>http://gborg.postgresql.org/mailman.../slony1-general
> =20
>
--=20
Brad Nicholson 416-673-4106 bnichols-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org
Database Administrator, Afilias Canada Corp.
| |
| Sebastian Kühner 2005-09-07, 11:24 am |
| They say:
Long and short: This points to a need to "audit" what installations of
PostgreSQL and Slony-I you have in place on the machine(s). Unfortunately=
,
just about any mismatch will cause things not to link up quite right.
I don't know what to do. Does anybody know what I could do?
Thanks!
Sebastian
----- Original Message -----=20
From: "Brad Nicholson" <bnichols-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org>
To: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
Sent: Wednesday, September 07, 2005 12:50 PM
Subject: Re: [Slony1-general] Compile
> There is a FAQ entry for this:
> http://linuxfinances.info/info/faq.html#AEN41935
>
> Sebastian K=FChner wrote:
>
it's[color=darkred]
and
I[color=darkred]
script[color=darkred
]
y[color=darkred]
d
in[color=darkred]
>
>
> --=20
> Brad Nicholson 416-673-4106 bnichols-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org
> Database Administrator, Afilias Canada Corp.
>
>
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general
>
| |
| Alan Hodgson 2005-09-07, 1:24 pm |
| On Wed, Sep 07, 2005 at 01:00:31PM -0300, Sebastian K=FChner wrote:
> They say:
>=20
> Long and short: This points to a need to "audit" what installations of
> PostgreSQL and Slony-I you have in place on the machine(s). Unfortunate=
ly,
> just about any mismatch will cause things not to link up quite right.
>=20
> I don't know what to do. Does anybody know what I could do?
Your installation of Slony probably installed against the wrong version o=
f
PostgreSQL on your system. Personally, I would make sure there is only o=
ne
installation of PostgreSQL on the system, that I knew exactly where it wa=
s, and
then I would build and install Slony against that. The libdir that the s=
lony
functions need to go into is that same place you'll find plpgsql.so etc. =
after
the PostgreSQL installation.
--=20
"None are more hopelessly enslaved than those who falsely believe they ar=
e
free." -- Johann W. Von Goethe
| |
| Sebastian Kühner 2005-09-07, 1:24 pm |
| Hello,
In the config of slony I put
../configure --libdir=3D/usr/lib
....and the error "xxid" disappeared.
Now there's another error that says:
<stdin>:7: PGRES_FATAL_ERROR select
"_sql_cluster1". determineIdxnameUniq
ue('public.contact', NULL); - ERROR:
Slony-I: table "public"."contact" not found
I hope that someone can help me.
Many thanks!
Sebastian
----- Original Message -----=20
From: "Alan Hodgson" <ahodgson- tuONjDs9ocH3fQ9qLvQP
4Q@public.gmane.org>
To: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
Sent: Wednesday, September 07, 2005 1:30 PM
Subject: Re: [Slony1-general] Compile
> On Wed, Sep 07, 2005 at 01:00:31PM -0300, Sebastian K=FChner wrote:
f[color=darkred]
Unfortunately,[color
=darkred]
>
> Your installation of Slony probably installed against the wrong version=
of
> PostgreSQL on your system. Personally, I would make sure there is only
one
> installation of PostgreSQL on the system, that I knew exactly where it
was, and
> then I would build and install Slony against that. The libdir that the
slony
> functions need to go into is that same place you'll find plpgsql.so etc=
..
after
> the PostgreSQL installation.
>
> --=20
> "None are more hopelessly enslaved than those who falsely believe they =
are
> free." -- Johann W. Von Goethe
>
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general
>
| |
| Sebastian Kühner 2005-09-07, 1:24 pm |
| Hello!
Sorry! The last message I wrote was an error of me!
You helped me very much! Thanks!!
Sebastian
----- Original Message -----=20
From: "Alan Hodgson" <ahodgson- tuONjDs9ocH3fQ9qLvQP
4Q@public.gmane.org>
To: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
Sent: Wednesday, September 07, 2005 1:30 PM
Subject: Re: [Slony1-general] Compile
> On Wed, Sep 07, 2005 at 01:00:31PM -0300, Sebastian K=FChner wrote:
f[color=darkred]
Unfortunately,[color
=darkred]
>
> Your installation of Slony probably installed against the wrong version=
of
> PostgreSQL on your system. Personally, I would make sure there is only
one
> installation of PostgreSQL on the system, that I knew exactly where it
was, and
> then I would build and install Slony against that. The libdir that the
slony
> functions need to go into is that same place you'll find plpgsql.so etc=
..
after
> the PostgreSQL installation.
>
> --=20
> "None are more hopelessly enslaved than those who falsely believe they =
are
> free." -- Johann W. Von Goethe
>
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general
>
| |
| Christopher Browne 2005-09-07, 1:24 pm |
| Alan Hodgson wrote:
>On Wed, Sep 07, 2005 at 01:00:31PM -0300, Sebastian K=FChner wrote:
> =20
>
ly,[color=darkred]
>
>Your installation of Slony probably installed against the wrong version =
of
>PostgreSQL on your system. Personally, I would make sure there is only =
one
>installation of PostgreSQL on the system, that I knew exactly where it w=
as, and
>then I would build and install Slony against that. The libdir that the =
slony
>functions need to go into is that same place you'll find plpgsql.so etc.=
after
>the PostgreSQL installation.
> =20
>
We commonly haven't the "luxury" of having only one PG installation, so
the documentation has reflected that.=20
I'll see about rewording it to make it a bit clearer.
| |
| Sebastian Kühner 2005-09-07, 1:24 pm |
| Hello,
I created a cluster successfully now.
On starting slone I get the error:
2005-09-07 14:55:02 ART ERROR slon_connectdb: PQconnectdb("dbname=3Dcont=
act
host=3Dlocalhost user=3Dpostgres") failed - fe_sendauth: no password supp=
lied
I have password protection on my postgresql servers (I use a web-interfac=
e
to connect to the database, so it's necesary to evite that everyone can
login with localhost). Is there any way to setup the password with slony?
Thanks!
Sebastian
----- Original Message -----=20
From: "Alan Hodgson" <ahodgson- tuONjDs9ocH3fQ9qLvQP
4Q@public.gmane.org>
To: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
Sent: Wednesday, September 07, 2005 1:30 PM
Subject: Re: [Slony1-general] Compile
> On Wed, Sep 07, 2005 at 01:00:31PM -0300, Sebastian K=FChner wrote:
f[color=darkred]
Unfortunately,[color
=darkred]
>
> Your installation of Slony probably installed against the wrong version=
of
> PostgreSQL on your system. Personally, I would make sure there is only
one
> installation of PostgreSQL on the system, that I knew exactly where it
was, and
> then I would build and install Slony against that. The libdir that the
slony
> functions need to go into is that same place you'll find plpgsql.so etc=
..
after
> the PostgreSQL installation.
>
> --=20
> "None are more hopelessly enslaved than those who falsely believe they =
are
> free." -- Johann W. Von Goethe
>
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general
>
| |
| Christopher Browne 2005-09-07, 8:25 pm |
| Sebastian K=FChner wrote:
>Hello,
>
>I created a cluster successfully now.
>
>On starting slone I get the error:
>
>2005-09-07 14:55:02 ART ERROR slon_connectdb: PQconnectdb("dbname=3Dcon=
tact
>host=3Dlocalhost user=3Dpostgres") failed - fe_sendauth: no password sup=
plied
>
>I have password protection on my postgresql servers (I use a web-interfa=
ce
>to connect to the database, so it's necesary to evite that everyone can
>login with localhost). Is there any way to setup the password with slony=
?
>
>Thanks!
>
>Sebastian
>
> =20
>
Slony-I is a "plain, ordinary" libpq-linked application, so you can use
..pgpass to manage the passwords.
Here's the .pgpass documentation:
<http://www.postgresql.org/docs/8.0/...bpq-pgpass.html>
"Best practice" is indeed to use .pgpass; that means the passwords stay
in one place rather than being strewn across all kinds of scripts
everywhere in the environment.
| |
| Sebastian Kühner 2005-09-07, 8:25 pm |
| Hi!
Thanks for the hint with the .pgpass. This solution works for me, but isn=
't
this the same like editing the pg_hba.conf like this:
host all all 127.0.0.1 255.255.255.255 md5
host all all 192.168.1.225 255.255.255.255 trust
host all all 192.168.1.223 255.255.255.255 trust
That means that all postgres servers that "participate" in the replicatio=
n
have to be in there (here 223 y 225).
Does anyone of you see a security hole? I do not. The postgres web interf=
ace
connects to "localhost"...
Many thanks!
Sebastian
----- Original Message -----=20
From: "Christopher Browne" <cbbrowne-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org>
To: "Sebastian K=FChner" <skuehner- W+yTvUamF4rQT0dZR+Al
fA@public.gmane.org>
Cc: <slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
Sent: Wednesday, September 07, 2005 4:12 PM
Subject: Re: [Slony1-general] Compile
> Sebastian K=FChner wrote:
>
PQconnectdb(" dbname=3Dcontact[col
or=darkred]
upplied[color=darkre
d]
web- interface[color=dark
red]
n[color=darkred]
ny?[color=darkred]
> Slony-I is a "plain, ordinary" libpq-linked application, so you can use
> .pgpass to manage the passwords.
>
> Here's the .pgpass documentation:
> <http://www.postgresql.org/docs/8.0/...bpq-pgpass.html>
>
> "Best practice" is indeed to use .pgpass; that means the passwords stay
> in one place rather than being strewn across all kinds of scripts
> everywhere in the environment.
>
| |
| Jim Archer 2005-09-07, 8:25 pm |
| Well if you do this then your data is only as secure as your system, and
your system may be less secure than you think. With this setup, any user
account that is compromised gives the hacker full access to your data,
even if it is a very low-privilidge account. A hacker may not be able to
easily get root access, but they could find their way on through a lesser
account.
Personally, I would not do this at all.
If you need to do this, you might at least just trust the user name that
your web system connects as, and then only for the database it connects
to. This costs you nothing.
Sebastian K=FChner said:
> Hi!
>
> Thanks for the hint with the .pgpass. This solution works for me, but
> isn't
> this the same like editing the pg_hba.conf like this:
>
> host all all 127.0.0.1 255.255.255.255 md5
> host all all 192.168.1.225 255.255.255.255 tru=
st
> host all all 192.168.1.223 255.255.255.255 tru=
st
>
> That means that all postgres servers that "participate" in the replicat=
ion
> have to be in there (here 223 y 225).
>
> Does anyone of you see a security hole? I do not. The postgres web
> interface
> connects to "localhost"...
>
> Many thanks!
>
> Sebastian
>
|
|
|
|
|