Slony1 PostgreSQL Replication - Package for Debian

Author

Package for Debian

Tomasz Rybak

2005-08-20, 8:25 pm

After Sarge has been made stable, PostgreSQL in Sid has been changed.

There is no postgresql package - instead, there are packages
postgresql-7.4 and postgresql-8.0.

For PostgreSQL 8.0 there is libpq4, and for PostgreSQL 7.4
there is libpq3.

There are different development packages for client's libpq (libpq-dev)
and for compiling programs for server (postgresql-server-dev-8.0
and postgresql-server-dev-7.4). Slony uses both (server and client),
so both should be listed in Depends section.

There are different directories for different versions of PostgreSQL,
for example /usr/include/postgresql/8.0, /usr/share/postgresql/8.0.

Here are changes I made to be able to compile Slony1 1.1 on Debian Sid
with PostgreSQL 8.0.3-12

debian/rules:

--- debian/rules.orig 2005-08-20 00:08:43.000000000 +0200
+++ debian/rules 2005-08-20 00:34:51.000000000 +0200
@@ -24,10 +24,14 @@
CFLAGS += -O2
endif

+PGSHAREBASEDIR=/usr/share/postgresql
+PGSHAREDIR ?= $(shell if [ -d $(PGSHAREBASEDIR)/8.0 ]; then echo
$(PGSHAREBASEDIR)/8.0 ; fi)
+PGSHAREDIR ?= $(shell if [ -d $(PGSHAREBASEDIR)/7.4 ]; then echo
$(PGSHAREBASEDIR)/7.4 ; fi)
+
config.status: configure
dh_testdir
# Add here commands to configure the package.
- CFLAGS="$(CFLAGS)" ./configure -- host=$(DEB_HOST_GNU_
TYPE) --build=
$(DEB_BUILD_GNU_TYPE
) --prefix=/usr --mandir=\$${prefix}/share/man
--infodir=\$${prefix}/share/info --sysconfdir=/etc/slony1
--with-perltools=\$${prefix}/bin --with-docs --with-docdir=\
$${prefix}/share/doc/slony1-1
+ CFLAGS="$(CFLAGS)" ./configure -- host=$(DEB_HOST_GNU_
TYPE) --build=
$(DEB_BUILD_GNU_TYPE
) --prefix=/usr --mandir=\$${prefix}/share/man
--infodir=\$${prefix}/share/info --sysconfdir=/etc/slony1
--with-perltools=\$${prefix}/bin --with- pgsharedir=$(PGSHARE
DIR)

build: build-stamp

debian/control:

--- debian/control.orig 2005-08-20 00:08:34.000000000 +0200
+++ debian/control 2005-08-20 00:11:47.000000000 +0200
@@ -2,12 +2,12 @@
Section: misc
Priority: optional
Maintainer: Tim Goodaire <tgoodair-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org>
-Build-Depends: debhelper (>= 4.0.0), docbook-dsssl, groff, byacc |
bison, postgresql-dev (>= 7.3.3), libpq3, flex
+Build-Depends: debhelper (>= 4.0.0), docbook-dsssl, groff, byacc |
bison, postgresql-server-dev-7.4|postgresql-server-dev-8.0, libpq3|
libpq4, flex
Standards-Version: 3.6.1

Package: slony1
Architecture: any
-Depends: postgresql (>= 7.3.3), libpq3
+Depends: postgresql-7.4|postgresql-8.0, libpq3|libpq4
Description: Slony-I is an asynchronous replication system for
PostgreSQL
This package contains the slon daemon, the slonik language, the
'altperl'
Slony-I administration tools, and the Slony-I documentation.

--
Tomasz Rybak <bogomips-N99IEGJtuYg@public.gmane.org>

Jim Archer

2005-08-21, 3:24 am

--On Saturday, August 20, 2005 9:42 PM +0200 Tomasz Rybak
<bogomips-N99IEGJtuYg@public.gmane.org> wrote:

> After Sarge has been made stable, PostgreSQL in Sid has been changed.
>
> There is no postgresql package - instead, there are packages
> postgresql-7.4 and postgresql-8.0.

I was wondering if there was a Debian package for Slony. I looked on
packages.debian.org but didn't find anything. Is there a package that
works with released Sarge available? I'm planning to give Slony a try in
the next several weeks and it would sure be easier with a package. I would
prefer to use Postgres 8.0.3 but for now I'm stuck with sarge.

Thanks!

Tomasz Rybak

2005-08-21, 7:24 am

Dnia 21-08-2005, nie o godzinie 04:14 -0400, Jim Archer napisa=B3(a):
> --On Saturday, August 20, 2005 9:42 PM +0200 Tomasz Rybak=20
> <bogomips-N99IEGJtuYg@public.gmane.org> wrote:
>=20
>=20
> I was wondering if there was a Debian package for Slony. I looked on=20
> packages.debian.org but didn't find anything. Is there a package that=20
> works with released Sarge available? I'm planning to give Slony a try =
in=20

> the next several weeks and it would sure be easier with a package. I w=
ould=20
> prefer to use Postgres 8.0.3 but for now I'm stuck with sarge.

There is no official Slony package for Debian.

But in source there is directory debian/,
so if you want to have Debian package, and have compiler installed,
you can make it yourself:

$ cd slony1-1.1.0
$ fakeroot debian/rules binary

and you'll have slony1-_1.1-1_i386.deb (or another architecture)
in parent directory.

You've written that you use Sarge, so changes shouldn't be necessary.
If you'll try to install Slony on Sid/Etch, you'll have to change
debian/rules and debian/control (patches sent by me in previous post).

--=20
Tomasz Rybak <bogomips-N99IEGJtuYg@public.gmane.org>

Sponsored Links