2 # Copyright (C) 2006-2010 OpenWrt.org
4 # This is free software, licensed under the GNU General Public License v2.
5 # See /LICENSE for more information.
8 include $(TOPDIR)/rules.mk
14 PKG_SOURCE:=$(PKG_NAME)-$(PKG_VERSION).tar.bz2
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
22 include $(INCLUDE_DIR)/package.mk
27 DEPENDS:=+zlib +libreadline +libncurses +coreutils-su
28 TITLE:=PostgreSQL client library
29 URL:=http://www.postgresql.org/
33 define Package/libpq/description
34 PostgreSQL client library.
37 define Package/pgsql-cli
41 TITLE:=Command Line Interface (CLI) to PostgreSQL databases
42 URL:=http://www.postgresql.org/
46 define Package/pgsql-cli/description
47 Command Line Interface (CLI) to PostgreSQL databases.
50 define Package/pgsql-server
54 TITLE:=PostgreSQL databases Server
55 URL:=http://www.postgresql.org/
59 define Package/pgsql-server/description
60 PostgreSQL databases Server.
63 # Need a native ecpg ,pg_config, and zic for build
64 define Build/Configure
65 (cd $(PKG_BUILD_DIR); rm -f config.cache; \
70 --datadir=/usr/share \
71 --includedir=/usr/include \
72 --infodir=/usr/share/info \
74 --libexecdir=/usr/lib \
75 --localstatedir=/var \
76 --mandir=/usr/share/man \
80 $(DISABLE_LARGEFILE) \
83 --disable-integer-datetimes \
93 --without-rendezvous \
98 --with-system-timezone=/tmp \
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
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)" \
118 --target=$(GNU_TARGET_NAME) \
119 --host=$(GNU_TARGET_NAME) \
120 --build=$(GNU_HOST_NAME) \
121 --program-prefix="" \
122 --program-suffix="" \
126 --datadir=/usr/share \
127 --includedir=/usr/include \
128 --infodir=/usr/share/info \
130 --libexecdir=/usr/lib \
131 --localstatedir=/var \
132 --mandir=/usr/share/man \
133 --sbindir=/usr/sbin \
136 $(DISABLE_LARGEFILE) \
139 --disable-integer-datetimes \
148 --without-rendezvous \
153 $(if $(CONFIG_TARGET_avr32),--disable-spinlocks) \
155 $(SED) 's@ECPG = ../../preproc/ecpg@ECPG = ../../preproc/ecpg.host@' $(PKG_BUILD_DIR)/src/interfaces/ecpg/test/Makefile.regress
158 TARGET_CFLAGS += $(FPIC)
161 $(MAKE) $(PKG_JOBS) -C "$(PKG_BUILD_DIR)" \
162 DESTDIR="$(PKG_INSTALL_DIR)" \
164 $(MAKE) $(PKG_JOBS) -C "$(PKG_BUILD_DIR)" \
165 DESTDIR="$(PKG_INSTALL_DIR)" \
169 define Package/libpq/install
170 $(INSTALL_DIR) $(1)/usr/lib
171 $(CP) $(PKG_INSTALL_DIR)/usr/lib/libpq.so.* $(1)/usr/lib/
174 define Package/pgsql-cli/install
175 $(INSTALL_DIR) $(1)/usr/bin
176 $(INSTALL_BIN) $(PKG_INSTALL_DIR)/usr/bin/psql $(1)/usr/bin/
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
188 $(INSTALL_BIN) ./files/postgresql.init $(1)/etc/init.d/postgresql
190 $(CP) -r $(PKG_INSTALL_DIR)/usr/share/postgresql/* \
191 $(1)/usr/share/postgresql
193 $(INSTALL_DATA) ./files/postgresql.config $(1)/etc/config/postgresql
196 $(PKG_INSTALL_DIR)/usr/lib/postgresql \
200 define Package/pgsql-server/postinst
202 grep -q '^postgres:' /etc/passwd && exit 0
203 group=$$(grep '^postgres:' /etc/group | cut -f3 -d:)
204 if [ -z "$${group}" ] ; then
206 tst=$$(cat /etc/group | grep ":$${group}:")
207 while [ -n "$${tst}" ] ; do
208 group=$$(($${group}+1))
209 tst=$$(cat /etc/group | grep ":$${group}:")
211 echo "postgres:x:$${group}:" >>/etc/group
214 user=$$(cat /etc/passwd | grep "^postgres:")
215 if [ -z "$${user}" ] ; then
217 tst=$$(cat /etc/passwd | grep ":.*:$${num}:")
218 while [ -n "$${tst}" ] ; do
220 tst=$$(cat /etc/passwd | grep ":.*:$${num}:")
222 echo "postgres:*:$${num}:$${group}:PostgreSQL administrator:/tmp:/bin/ash" >>/etc/passwd
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
242 $(eval $(call BuildPackage,libpq))
243 $(eval $(call BuildPackage,pgsql-cli))
244 $(eval $(call BuildPackage,pgsql-server))