1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
|
# Copyright 1999-2004 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
# $Header: /var/cvsroot/gentoo-x86/dev-db/postgresql/postgresql-7.4.5.ebuild,v 1.2 2004/08/22 17:00:57 weeve Exp $
inherit eutils gnuconfig flag-o-matic
DESCRIPTION="sophisticated Object-Relational DBMS."
HOMEPAGE="http://www.postgresql.org/"
P_HIERPG="hier-Pg7.4-0.5.3"
SRC_URI="mirror://postgresql/source/v${PV}/${PN}-base-${PV}.tar.bz2
mirror://postgresql/source/v${PV}/${PN}-opt-${PV}.tar.bz2
doc? ( mirror://postgresql/source/v${PV}/${PN}-docs-${PV}.tar.bz2 )
pg-hier? ( ftp://gborg.postgresql.org/pub/hierpg/stable/${P_HIERPG}.tar.gz )"
LICENSE="POSTGRESQL"
SLOT="0"
KEYWORDS="~x86 ~ppc ~sparc ~mips ~alpha ~arm ~hppa ~amd64 ~ia64 ~s390 ~ppc64"
IUSE="ssl nls java python tcltk perl libg++ pam readline zlib doc pg-hier pg-vacuumdelay pg-intdatetime"
DEPEND="virtual/libc
sys-devel/autoconf
>=sys-libs/ncurses-5.2
>=sys-devel/bison-1.875
zlib? ( >=sys-libs/zlib-1.1.3 )
readline? ( >=sys-libs/readline-4.1 )
tcltk? ( >=dev-lang/tcl-8 >=dev-lang/tk-8.3.3-r1 )
perl? ( >=dev-lang/perl-5.6.1-r2 )
python? ( >=dev-lang/python-2.2 dev-python/egenix-mx-base )
java? ( >=virtual/jdk-1.3* >=dev-java/ant-1.3
dev-java/java-config )
ssl? ( >=dev-libs/openssl-0.9.6-r1 )
nls? ( sys-devel/gettext )"
# java dep workaround for portage bug
# x86? ( java? ( =dev-java/sun-jdk-1.3* >=dev-java/ant-1.3 ) )
RDEPEND="virtual/libc
zlib? ( >=sys-libs/zlib-1.1.3 )
tcltk? ( >=dev-lang/tcl-8 )
perl? ( >=dev-lang/perl-5.6.1-r2 )
python? ( >=dev-lang/python-2.2 )
java? ( >=virtual/jdk-1.3* )
ssl? ( >=dev-libs/openssl-0.9.6-r1 )"
PG_DIR="/var/lib/postgresql"
MAX_CONNECTIONS=1024
pkg_setup() {
if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -lt 4 ] ; then
eerror "Postgres ${PV} cannot upgrade your existing databases, you must"
eerror "use pg_dump to export your existing databases to a file, and then"
eerror "pg_restore to import them when you have upgraded completely."
eerror "You must remove your entire database directory to continue."
eerror "(database directory = ${PG_DIR})."
exit 1
fi
fi
}
check_java_config() {
JDKHOME="`java-config --jdk-home`"
if [[ -z "${JDKHOME}" || ! -d "${JDKHOME}" ]]; then
NOJDKERROR="You need to use java-config to set your JVM to a JDK!"
eerror "${NOJDKERROR}"
die "${NOJDKERROR}"
fi
}
src_unpack() {
unpack ${A} || die
epatch ${FILESDIR}/${P}-gentoo.patch
if use pg-hier; then
cd ${S} || die
epatch ${WORKDIR}/${P_HIERPG}.diff
fi
if use pg-vacuumdelay; then
cd ${S} || die
epatch ${FILESDIR}/${P}-vacuum-delay.patch
fi
if [ "${ARCH}" = "hppa" ]
then
cd ${S}
epatch ${FILESDIR}/${P}-hppa-testandset.patch
fi
}
src_compile() {
filter-flags -ffast-math
if use java; then
check_java_config
fi
local myconf
use tcltk && myconf="--with-tcl"
use python && myconf="$myconf --with-python"
use perl && myconf="$myconf --with-perl"
use java && myconf="$myconf --with-java"
use ssl && myconf="$myconf --with-openssl"
use nls && myconf="$myconf --enable-nls"
use libg++ && myconf="$myconf --with-CXX"
use pam && myconf="$myconf --with-pam"
use readline || myconf="$myconf --without-readline"
use zlib || myconf="$myconf --without-zlib"
use pg-intdatetime && myconf="$myconf --enable-integer-datetimes"
# these are the only working CFLAGS I could get on ppc, so locking them
# down, anything more aggressive fails (i.e. -mcpu or -Ox)
# Gerk - Nov 26, 2002
use ppc && CFLAGS="-pipe -fsigned-char"
# Detect mips systems properly
gnuconfig_update
./configure --prefix=/usr \
--mandir=/usr/share/man \
--host=${CHOST} \
--docdir=/usr/share/doc/${PF} \
--libdir=/usr/lib \
--includedir=/usr/include/postgresql/pgsql \
--enable-depend \
--with-gnu-ld \
--with-maxbackends=${MAX_CONNECTIONS} \
$myconf || die
make || die
cd contrib
make || die
}
src_install() {
if use perl; then
mv ${S}/src/pl/plperl/Makefile ${S}/src/pl/plperl/Makefile_orig
sed -e "s:(INST_DYNAMIC) /usr/lib:(INST_DYNAMIC) ${D}/usr/lib:" \
${S}/src/pl/plperl/Makefile_orig > ${S}/src/pl/plperl/Makefile
mv ${S}/src/pl/plperl/GNUmakefile ${S}/src/pl/plperl/GNUmakefile_orig
sed -e "s:\$(DESTDIR)\$(plperl_installdir):\$(plperl_installdir):" \
${S}/src/pl/plperl/GNUmakefile_orig > ${S}/src/pl/plperl/GNUmakefile
fi
make DESTDIR=${D} includedir_server=/usr/include/postgresql/server includedir_internal=/usr/include/postgresql/internal LIBDIR=${D}/usr/lib install || die
make DESTDIR=${D} includedir_server=/usr/include/postgresql/server includedir_internal=/usr/include/postgresql/internal install-all-headers || die
cd ${S}/contrib
make DESTDIR=${D} LIBDIR=${D}/usr/lib install || die
cd ${S}
if use pg-hier; then
dodoc ${WORKDIR}/README-${P_HIERPG}.html || die
fi
dodoc README HISTORY COPYRIGHT INSTALL
dodoc contrib/adddepend/*
exeinto /usr/bin
if use java; then
# we need to remove jar file after dojar; otherwise two same jar
# file are installed.
dojar ${D}/usr/share/postgresql/java/postgresql.jar || die
rm ${D}/usr/share/postgresql/java/postgresql.jar
dojar ${D}/usr/share/postgresql/java/postgresql-examples.jar || die
rm ${D}/usr/share/postgresql/java/postgresql-examples.jar
fi
# backward compatibility
for i in ${D}/usr/include/postgresql/pgsql/*
do
ln -s ${i} ${D}/usr/include/
done
cd ${S}/doc
dodoc FAQ* README.* TODO bug.template
if use doc; then
cd ${S}/doc
docinto FAQ_html || die
dodoc src/FAQ/* || die
docinto sgml || die
dodoc src/sgml/*.{sgml,dsl} || die
docinto sgml/ref || die
dodoc src/sgml/ref/*.sgml || die
docinto TODO.detail || die
dodoc TODO.detail/* || die
fi
cd ${S}
exeinto /etc/init.d/
newexe ${FILESDIR}/postgresql.init-${PV} postgresql || die
newexe ${FILESDIR}/pg_autovacuum.init-${PV} pg_autovacuum || die
dosed "s:___DOCDIR___:/usr/share/doc/${PF}:" /etc/init.d/pg_autovacuum
insinto /etc/conf.d/
newins ${FILESDIR}/postgresql.conf-${PV} postgresql || die
newins ${FILESDIR}/pg_autovacuum.conf-${PV} pg_autovacuum || die
}
pkg_postinst() {
einfo "Make sure the postgres user in /etc/passwd has an account setup with /bin/bash as the shell"
if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -eq 4 ] ; then
ewarn ""
ewarn "If you are upgrading from PostgreSQL 7.4 or 7.4.1, it is strongly recommended"
ewarn "that you read the release notes concerning changes to the system catalogs."
ewarn "You can run 7.4.2 without rerunning initdb, however you may still experience"
ewarn "random crashes due to an error in pg_statistic."
ewarn ""
ewarn "If you prefer not to re-initdb your installation, the release notes contain"
ewarn "a procedure for manually correcting the problem."
ewarn ""
fi
if use pg-hier; then
ewarn ""
ewarn "REQUIRED!! After installing patched PostgreSQL by pg-hier"
ewarn "it is required to run 'initdb'. Without this Pg will fail "
ewarn "with error "
ewarn "ERROR: did not find '}' at end of input node. "
ewarn ""
fi
else
einfo ""
einfo "Execute the following command"
einfo "ebuild /var/db/pkg/dev-db/${PF}/${PF}.ebuild config"
einfo "to setup the initial database environment."
einfo ""
fi
einfo ""
einfo "Python modules was removed from PostgreSQL package."
einfo "If you need it, please run \"emerge dev-db/pygresq\"."
einfo ""
}
pkg_config() {
einfo "Creating the data directory ..."
mkdir -p ${PG_DIR}/data
chown -Rf postgres:postgres ${PG_DIR}
chmod 700 ${PG_DIR}/data
einfo "Initializing the database ..."
if [ -f ${PG_DIR}/data/PG_VERSION ] ; then
PG_MAJOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f1 -d.`
PG_MINOR=`cat ${PG_DIR}/data/PG_VERSION | cut -f2 -d.`
if [ ${PG_MAJOR} -lt 7 ] || [ ${PG_MAJOR} -eq 7 -a ${PG_MINOR} -lt 3 ] ; then
eerror "Postgres ${PV} cannot upgrade your existing databases."
eerror "You must remove your entire database directory to continue."
eerror "(database directory = ${PG_DIR})."
exit 1
else
einfon "A postgres data directory already exists from version "; cat ${PG_DIR}/data/PG_VERSION
einfo "Read the documentation to check how to upgrade to version ${PV}."
fi
else
local SEM=`sysctl -n kernel.sem | cut -f-3`
local SEMMNI=`sysctl -n kernel.sem | cut -f4`
local SEMMNI_MIN=`expr \( ${MAX_CONNECTIONS} + 15 \) / 16`
local SHMMAX=`sysctl -n kernel.shmmax`
local SHMMAX_MIN=`expr 250000 + 30600 \* ${MAX_CONNECTIONS}`
if [ ${SEMMNI} -lt ${SEMMNI_MIN} ]; then
eerror "The current value of SEMMNI is too low"
eerror "for postgresql to run ${MAX_CONNECTIONS} connections"
eerror "Temporary setting this value to ${SEMMNI_MIN} while creating the initial database."
echo ${SEM} ${SEMMNI_MIN} > /proc/sys/kernel/sem
fi
su postgres -c "/usr/bin/initdb --pgdata ${PG_DIR}/data"
if [ ! `sysctl -n kernel.sem | cut -f4` -eq ${SEMMNI} ] ; then
echo ${SEM} ${SEMMNI} > /proc/sys/kernel/sem
ewarn "Restoring the SEMMNI value to the previous value"
ewarn "Please edit the last value of kernel.sem in /etc/sysctl.conf"
ewarn "and set it to at least ${SEMMNI_MIN}"
ewarn ""
ewarn " kernel.sem = ${SEM} ${SEMMNI_MIN}"
ewarn ""
fi
if [ ${SHMMAX} -lt ${SHMMAX_MIN} ]; then
eerror "The current value of SHMMAX is too low for postgresql to run."
eerror "Please edit /etc/sysctl.conf and set this value to at least ${SHMMAX_MIN}."
eerror ""
eerror " kernel.shmmax = ${SHMMAX_MIN}"
eerror ""
fi
einfo "If you are upgrading from a pre-7.3 version of PostgreSQL, please read"
einfo "the README.adddepend file for information on how to properly migrate"
einfo "all serial columns, unique keys and foreign keys to this version."
fi
}
|