postgresql: update to version 9.0.1
[packages.git] / libs / postgresql / Makefile
1 #
2 # Copyright (C) 2006-2010 OpenWrt.org
3 #
4 # This is free software, licensed under the GNU General Public License v2.
5 # See /LICENSE for more information.
6 #
7
8 include $(TOPDIR)/rules.mk
9
10 PKG_NAME:=postgresql
11 PKG_VERSION:=9.0.1
12 PKG_RELEASE:=1
13
14 PKG_SOURCE:=$(PKG_NAME)-$(PKG_VERSION).tar.bz2
15 PKG_SOURCE_URL:=\
16         http://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v$(PKG_VERSION) \
17         http://ftp.be.postgresql.org/postgresql/source/v$(PKG_VERSION) \
18         ftp://ftp-archives.postgresql.org/pub/source/v$(PKG_VERSION)
19 PKG_MD5SUM:=57ba57e43cfe29e16dacbf5789be98d1
20 PKG_BUILD_PARALLEL:=1
21
22 include $(INCLUDE_DIR)/package.mk
23
24 define Package/libpq
25   SECTION:=libs
26   CATEGORY:=Libraries
27   DEPENDS:=+zlib +libreadline +libncurses +coreutils-su
28   TITLE:=PostgreSQL client library
29   URL:=http://www.postgresql.org/
30   SUBMENU:=database
31 endef
32
33 define Package/libpq/description
34 PostgreSQL client library.
35 endef
36
37 define Package/pgsql-cli
38   SECTION:=utils
39   CATEGORY:=Utilities
40   DEPENDS:=+libpq
41   TITLE:=Command Line Interface (CLI) to PostgreSQL databases
42   URL:=http://www.postgresql.org/
43   SUBMENU:=database
44 endef
45
46 define Package/pgsql-cli/description
47 Command Line Interface (CLI) to PostgreSQL databases.
48 endef
49
50 define Package/pgsql-server
51   SECTION:=utils
52   CATEGORY:=Utilities
53   DEPENDS:=+libpq
54   TITLE:=PostgreSQL databases Server
55   URL:=http://www.postgresql.org/
56   SUBMENU:=database
57 endef
58
59 define Package/pgsql-server/description
60 PostgreSQL databases Server.
61 endef
62
63 # Need a native ecpg ,pg_config, and zic for build
64 define Build/Configure
65         (cd $(PKG_BUILD_DIR); rm -f config.cache; \
66                 ./configure \
67                         --prefix=/usr \
68                         --exec-prefix=/usr \
69                         --bindir=/usr/bin \
70                         --datadir=/usr/share \
71                         --includedir=/usr/include \
72                         --infodir=/usr/share/info \
73                         --libdir=/usr/lib \
74                         --libexecdir=/usr/lib \
75                         --localstatedir=/var \
76                         --mandir=/usr/share/man \
77                         --sbindir=/usr/sbin \
78                         --sysconfdir=/etc \
79                         $(DISABLE_NLS) \
80                         $(DISABLE_LARGEFILE) \
81                         --enable-shared \
82                         --enable-static \
83                         --disable-integer-datetimes \
84                         --disable-rpath \
85                         --without-java \
86                         --without-krb4 \
87                         --without-krb5 \
88                         --without-openssl \
89                         --without-pam \
90                         --without-perl \
91                         --without-python \
92                         --without-readline \
93                         --without-rendezvous \
94                         --without-tcl \
95                         --without-tk \
96                         --with-zlib="yes" \
97                         --enable-depend \
98                         --with-system-timezone=/tmp \
99         );
100         $(MAKE) -C $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc CC="$(HOSTCC)" CFLAGS+="-I../../libpq"
101         mv $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc/ecpg \
102                 $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc/ecpg.host
103         $(MAKE) -C $(PKG_BUILD_DIR)/src/timezone CC="$(HOSTCC)"
104         mv $(PKG_BUILD_DIR)/src/timezone/zic $(PKG_BUILD_DIR)/host-zic
105         $(INSTALL_DIR) $(STAGING_DIR)/host/bin/
106         $(CP) $(PKG_BUILD_DIR)/host-zic $(STAGING_DIR)/host/bin/zic
107         $(MAKE) -C $(PKG_BUILD_DIR)/src/bin/pg_config CC="$(HOSTCC)"
108         mv $(PKG_BUILD_DIR)/src/bin/pg_config/pg_config \
109                 $(PKG_BUILD_DIR)/src/bin/pg_config/pg_config.host
110         $(MAKE) -C $(PKG_BUILD_DIR) distclean
111
112         (cd $(PKG_BUILD_DIR); rm -f config.cache; \
113                 $(TARGET_CONFIGURE_OPTS) \
114                 CFLAGS="$(TARGET_CFLAGS)" \
115                 CPPFLAGS="$$$$CPPFLAGS $(TARGET_CPPFLAGS)" \
116                 LDFLAGS="$(TARGET_LDFLAGS)" \
117                 ./configure \
118                         --target=$(GNU_TARGET_NAME) \
119                         --host=$(GNU_TARGET_NAME) \
120                         --build=$(GNU_HOST_NAME) \
121                         --program-prefix="" \
122                         --program-suffix="" \
123                         --prefix=/usr \
124                         --exec-prefix=/usr \
125                         --bindir=/usr/bin \
126                         --datadir=/usr/share \
127                         --includedir=/usr/include \
128                         --infodir=/usr/share/info \
129                         --libdir=/usr/lib \
130                         --libexecdir=/usr/lib \
131                         --localstatedir=/var \
132                         --mandir=/usr/share/man \
133                         --sbindir=/usr/sbin \
134                         --sysconfdir=/etc \
135                         $(DISABLE_NLS) \
136                         $(DISABLE_LARGEFILE) \
137                         --enable-shared \
138                         --enable-static \
139                         --disable-integer-datetimes \
140                         --disable-rpath \
141                         --without-java \
142                         --without-krb4 \
143                         --without-krb5 \
144                         --without-openssl \
145                         --without-pam \
146                         --without-perl \
147                         --without-python \
148                         --without-rendezvous \
149                         --without-tcl \
150                         --without-tk \
151                         --with-zlib="yes" \
152                         --enable-depend \
153                         $(if $(CONFIG_TARGET_avr32),--disable-spinlocks) \
154         );
155         $(SED) 's@ECPG = ../../preproc/ecpg@ECPG = ../../preproc/ecpg.host@' $(PKG_BUILD_DIR)/src/interfaces/ecpg/test/Makefile.regress
156 endef
157
158 TARGET_CFLAGS += $(FPIC)
159
160 define Build/Compile
161         $(MAKE) $(PKG_JOBS) -C "$(PKG_BUILD_DIR)" \
162                 DESTDIR="$(PKG_INSTALL_DIR)" \
163                 all
164         $(MAKE) $(PKG_JOBS) -C "$(PKG_BUILD_DIR)" \
165                 DESTDIR="$(PKG_INSTALL_DIR)" \
166                 install
167 endef
168
169 define Package/libpq/install
170         $(INSTALL_DIR) $(1)/usr/lib
171         $(CP) $(PKG_INSTALL_DIR)/usr/lib/libpq.so.* $(1)/usr/lib/
172 endef
173
174 define Package/pgsql-cli/install
175         $(INSTALL_DIR) $(1)/usr/bin
176         $(INSTALL_BIN) $(PKG_INSTALL_DIR)/usr/bin/psql $(1)/usr/bin/
177 endef
178
179 define Package/pgsql-server/install
180         $(INSTALL_DIR) $(1)/usr/bin
181         $(INSTALL_DIR) $(1)/usr/share/postgresql
182         $(INSTALL_DIR) $(1)/usr/lib
183         $(INSTALL_DIR) $(1)/etc/init.d
184         $(INSTALL_DIR) $(1)/etc/config
185         $(INSTALL_BIN) $(PKG_INSTALL_DIR)/usr/bin/* $(1)/usr/bin
186         ln -sf postgres $(1)/usr/bin/postmaster
187
188         $(INSTALL_BIN) ./files/postgresql.init $(1)/etc/init.d/postgresql
189
190         $(CP) -r $(PKG_INSTALL_DIR)/usr/share/postgresql/* \
191                 $(1)/usr/share/postgresql
192
193         $(INSTALL_DATA) ./files/postgresql.config $(1)/etc/config/postgresql
194
195         $(CP) -r \
196                 $(PKG_INSTALL_DIR)/usr/lib/postgresql \
197                 $(1)/usr/lib
198 endef
199
200 define Package/pgsql-server/postinst
201 #!/bin/sh
202 grep -q '^postgres:' /etc/passwd && exit 0
203 group=$$(grep '^postgres:' /etc/group | cut -f3 -d:)
204 if [ -z "$${group}" ] ; then
205         group=1000
206         tst=$$(cat /etc/group | grep ":$${group}:")
207         while [ -n "$${tst}" ] ; do
208                 group=$$(($${group}+1))
209                 tst=$$(cat /etc/group | grep ":$${group}:")
210         done
211         echo "postgres:x:$${group}:" >>/etc/group
212 fi
213
214 user=$$(cat /etc/passwd | grep "^postgres:")
215 if [ -z "$${user}" ] ; then
216         num="$${group}"
217         tst=$$(cat /etc/passwd | grep ":.*:$${num}:")
218         while [ -n "$${tst}" ] ; do
219                 num=$$(($${num}+1))
220                 tst=$$(cat /etc/passwd | grep ":.*:$${num}:")
221         done
222         echo "postgres:*:$${num}:$${group}:PostgreSQL administrator:/tmp:/bin/ash" >>/etc/passwd
223 fi
224 endef
225
226 define Build/InstallDev
227         $(INSTALL_DIR) $(1)/usr/bin
228         $(INSTALL_BIN) $(PKG_BUILD_DIR)/src/bin/pg_config/pg_config.host $(1)/usr/bin/pg_config
229         $(INSTALL_DIR) $(1)/usr/include
230         $(CP) $(PKG_INSTALL_DIR)/usr/include/libpq $(1)/usr/include/
231         $(CP) $(PKG_INSTALL_DIR)/usr/include/libpq-fe.h $(1)/usr/include/
232         $(CP) $(PKG_INSTALL_DIR)/usr/include/pg_config.h $(1)/usr/include/
233         $(CP) $(PKG_INSTALL_DIR)/usr/include/pg_config_manual.h $(1)/usr/include/
234         $(CP) $(PKG_INSTALL_DIR)/usr/include/postgres_ext.h $(1)/usr/include/
235         $(CP) $(PKG_INSTALL_DIR)/usr/include/postgresql $(1)/usr/include/
236         $(INSTALL_DIR) $(1)/usr/lib
237         $(CP) $(PKG_INSTALL_DIR)/usr/lib/libpq.{a,so*} $(1)/usr/lib/
238         $(CP) $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc/ecpg.host $(1)/usr/bin/ecpg
239         $(CP) $(PKG_BUILD_DIR)/host-zic $(1)/usr/bin/zic
240 endef
241
242 $(eval $(call BuildPackage,libpq))
243 $(eval $(call BuildPackage,pgsql-cli))
244 $(eval $(call BuildPackage,pgsql-server))