postgresql: update to version 9.0.1
[openwrt/svn-archive/archive.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))