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=$(PGSHAREDIR)
 
 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 at ca.afilias.info>
-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 at post.pl>