Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd27da2e

Browse files
committed
test pg_pathman with Travis-CI
1 parent696b032 commitd27da2e

File tree

3 files changed

+178
-0
lines changed

3 files changed

+178
-0
lines changed

‎.travis.yml

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
language:c
2+
3+
before_install:
4+
-sudo sh ./travis/apt.postgresql.org.sh
5+
6+
env:
7+
-PGVERSION=9.5
8+
9+
script:bash ./travis/pg-travis-test.sh

‎travis/apt.postgresql.org.sh

Lines changed: 136 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,136 @@
1+
#!/bin/sh
2+
3+
# script to add apt.postgresql.org to sources.list
4+
5+
# from command like
6+
CODENAME="$1"
7+
# lsb_release is the best interface, but not always available
8+
if [-z"$CODENAME" ];then
9+
CODENAME=$(lsb_release -cs2>/dev/null)
10+
fi
11+
# parse os-release (unreliable, does not work on Ubuntu)
12+
if [-z"$CODENAME"-a-f /etc/os-release ];then
13+
. /etc/os-release
14+
# Debian: VERSION="7.0 (wheezy)"
15+
# Ubuntu: VERSION="13.04, Raring Ringtail"
16+
CODENAME=$(echo$VERSION| sed -ne's/.*(\(.*\)).*/\1/')
17+
fi
18+
# guess from sources.list
19+
if [-z"$CODENAME" ];then
20+
CODENAME=$(grep'^deb' /etc/apt/sources.list| head -n1| awk'{ print $3 }')
21+
fi
22+
# complain if no result yet
23+
if [-z"$CODENAME" ];then
24+
cat<<EOF
25+
Could not determine the distribution codename. Please report this as a bug to
26+
pgsql-pkg-debian@postgresql.org. As a workaround, you can call this script with
27+
the proper codename as parameter, e.g. "$0 squeeze".
28+
EOF
29+
exit 1
30+
fi
31+
32+
# errors are non-fatal above
33+
set -e
34+
35+
cat<<EOF
36+
This script will enable the PostgreSQL APT repository on apt.postgresql.org on
37+
your system. The distribution codename used will be$CODENAME-pgdg.
38+
39+
EOF
40+
41+
case$CODENAMEin
42+
# known distributions
43+
sid|wheezy|squeeze|lenny|etch) ;;
44+
precise|lucid) ;;
45+
*)# unknown distribution, verify on the web
46+
DISTURL="http://apt.postgresql.org/pub/repos/apt/dists/"
47+
if [-x /usr/bin/curl ];then
48+
DISTHTML=$(curl -s$DISTURL)
49+
elif [-x /usr/bin/wget ];then
50+
DISTHTML=$(wget --quiet -O -$DISTURL)
51+
fi
52+
if ["$DISTHTML" ];then
53+
if!echo"$DISTHTML"| grep -q"$CODENAME-pgdg";then
54+
cat<<EOF
55+
Your system is using the distribution codename$CODENAME, but$CODENAME-pgdg
56+
does not seem to be a valid distribution on
57+
$DISTURL
58+
59+
We abort the installation here. Please ask on the mailing list for assistance.
60+
61+
pgsql-pkg-debian@postgresql.org
62+
EOF
63+
exit 1
64+
fi
65+
fi
66+
;;
67+
esac
68+
69+
#echo -n "Press Enter to continue, or Ctrl-C to abort."
70+
#
71+
#read enter
72+
73+
echo"Writing /etc/apt/sources.list.d/pgdg.list ..."
74+
cat> /etc/apt/sources.list.d/pgdg.list<<EOF
75+
deb http://apt.postgresql.org/pub/repos/apt/$CODENAME-pgdg main
76+
#deb-src http://apt.postgresql.org/pub/repos/apt/$CODENAME-pgdg main
77+
EOF
78+
79+
echo"Importing repository signing key ..."
80+
KEYRING="/etc/apt/trusted.gpg.d/apt.postgresql.org.gpg"
81+
test -e$KEYRING|| touch$KEYRING
82+
apt-key --keyring$KEYRING add -<<EOF
83+
-----BEGIN PGP PUBLIC KEY BLOCK-----
84+
Version: GnuPG v1.4.12 (GNU/Linux)
85+
86+
mQINBE6XR8IBEACVdDKT2HEH1IyHzXkb4nIWAY7echjRxo7MTcj4vbXAyBKOfjja
87+
UrBEJWHN6fjKJXOYWXHLIYg0hOGeW9qcSiaa1/rYIbOzjfGfhE4x0Y+NJHS1db0V
88+
G6GUj3qXaeyqIJGS2z7m0Thy4Lgr/LpZlZ78Nf1fliSzBlMo1sV7PpP/7zUO+aA4
89+
bKa8Rio3weMXQOZgclzgeSdqtwKnyKTQdXY5MkH1QXyFIk1nTfWwyqpJjHlgtwMi
90+
c2cxjqG5nnV9rIYlTTjYG6RBglq0SmzF/raBnF4Lwjxq4qRqvRllBXdFu5+2pMfC
91+
IZ10HPRdqDCTN60DUix+BTzBUT30NzaLhZbOMT5RvQtvTVgWpeIn20i2NrPWNCUh
92+
hj490dKDLpK/v+A5/i8zPvN4c6MkDHi1FZfaoz3863dylUBR3Ip26oM0hHXf4/2U
93+
A/oA4pCl2W0hc4aNtozjKHkVjRx5Q8/hVYu+39csFWxo6YSB/KgIEw+0W8DiTII3
94+
RQj/OlD68ZDmGLyQPiJvaEtY9fDrcSpI0Esm0i4sjkNbuuh0Cvwwwqo5EF1zfkVj
95+
Tqz2REYQGMJGc5LUbIpk5sMHo1HWV038TWxlDRwtOdzw08zQA6BeWe9FOokRPeR2
96+
AqhyaJJwOZJodKZ76S+LDwFkTLzEKnYPCzkoRwLrEdNt1M7wQBThnC5z6wARAQAB
97+
tBxQb3N0Z3JlU1FMIERlYmlhbiBSZXBvc2l0b3J5iQI9BBMBCAAnAhsDBQsJCAcD
98+
BRUKCQgLBRYCAwEAAh4BAheABQJRKm2VBQkINsBBAAoJEH/MfUaszEz4RTEP/1sQ
99+
HyjHaUiAPaCAv8jw/3SaWP/g8qLjpY6ROjLnDMvwKwRAoxUwcIv4/TWDOMpwJN+C
100+
JIbjXsXNYvf9OX+UTOvq4iwi4ADrAAw2xw+Jomc6EsYla+hkN2FzGzhpXfZFfUsu
101+
phjY3FKL+4hXH+R8ucNwIz3yrkfc17MMn8yFNWFzm4omU9/JeeaafwUoLxlULL2z
102+
Y7H3+QmxCl0u6t8VvlszdEFhemLHzVYRY0Ro/ISrR78CnANNsMIy3i11U5uvdeWV
103+
CoWV1BXNLzOD4+BIDbMB/Do8PQCWiliSGZi8lvmj/sKbumMFQonMQWOfQswTtqTy
104+
Q3yhUM1LaxK5PYq13rggi3rA8oq8SYb/KNCQL5pzACji4TRVK0kNpvtxJxe84X8+
105+
9IB1vhBvF/Ji/xDd/3VDNPY+k1a47cON0S8Qc8DA3mq4hRfcgvuWy7ZxoMY7AfSJ
106+
Ohleb9+PzRBBn9agYgMxZg1RUWZazQ5KuoJqbxpwOYVFja/stItNS4xsmi0lh2I4
107+
MNlBEDqnFLUxSvTDc22c3uJlWhzBM/f2jH19uUeqm4jaggob3iJvJmK+Q7Ns3Wcf
108+
huWwCnc1+58diFAMRUCRBPeFS0qd56QGk1r97B6+3UfLUslCfaaA8IMOFvQSHJwD
109+
O87xWGyxeRTYIIP9up4xwgje9LB7fMxsSkCDTHOkiEYEEBEIAAYFAk6XSO4ACgkQ
110+
xa93SlhRC1qmjwCg9U7U+XN7Gc/dhY/eymJqmzUGT/gAn0guvoX75Y+BsZlI6dWn
111+
qaFU6N8HiQIcBBABCAAGBQJOl0kLAAoJEExaa6sS0qeuBfEP/3AnLrcKx+dFKERX
112+
o4NBCGWr+i1CnowupKS3rm2xLbmiB969szG5TxnOIvnjECqPz6skK3HkV3jTZaju
113+
v3sR6M2ItpnrncWuiLnYcCSDp9TEMpCWzTEgtrBlKdVuTNTeRGILeIcvqoZX5w+u
114+
i0eBvvbeRbHEyUsvOEnYjrqoAjqUJj5FUZtR1+V9fnZp8zDgpOSxx0LomnFdKnhj
115+
uyXAQlRCA6/roVNR9ruRjxTR5ubteZ9ubTsVYr2/eMYOjQ46LhAgR+3Alblu/WHB
116+
MR/9F9//RuOa43R5Sjx9TiFCYol+Ozk8XRt3QGweEH51YkSYY3oRbHBb2Fkql6N6
117+
YFqlLBL7/aiWnNmRDEs/cdpo9HpFsbjOv4RlsSXQfvvfOayHpT5nO1UQFzoyMVpJ
118+
615zwmQDJT5Qy7uvr2eQYRV9AXt8t/H+xjQsRZCc5YVmeAo91qIzI/tA2gtXik49
119+
6yeziZbfUvcZzuzjjxFExss4DSAwMgorvBeIbiz2k2qXukbqcTjB2XqAlZasd6Ll
120+
nLXpQdqDV3McYkP/MvttWh3w+J/woiBcA7yEI5e3YJk97uS6+ssbqLEd0CcdT+qz
121+
+Waw0z/ZIU99Lfh2Qm77OT6vr//Zulw5ovjZVO2boRIcve7S97gQ4KC+G/+QaRS+
122+
VPZ67j5UMxqtT/Y4+NHcQGgwF/1i
123+
=Iugu
124+
-----END PGP PUBLIC KEY BLOCK-----
125+
EOF
126+
127+
echo"Running apt-get update ..."
128+
apt-get update
129+
130+
cat<<EOF
131+
132+
You can now start installing packages from apt.postgresql.org.
133+
134+
Have a look at https://wiki.postgresql.org/wiki/Apt for more information;
135+
most notably the FAQ at https://wiki.postgresql.org/wiki/Apt/FAQ
136+
EOF

‎travis/pg-travis-test.sh

Lines changed: 33 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,33 @@
1+
#!/bin/bash
2+
3+
set -eux
4+
5+
sudo apt-get update
6+
7+
packages="postgresql-$PGVERSION postgresql-server-dev-$PGVERSION postgresql-common"
8+
9+
# bug: http://www.postgresql.org/message-id/20130508192711.GA9243@msgid.df7cb.de
10+
sudo update-alternatives --remove-all postmaster.1.gz
11+
12+
# stop all existing instances (because of https://github.com/travis-ci/travis-cookbooks/pull/221)
13+
sudo service postgresql stop
14+
# and make sure they don't come back
15+
echo'exit 0'| sudo tee /etc/init.d/postgresql
16+
sudo chmod a+x /etc/init.d/postgresql
17+
18+
sudo apt-get -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" install$packages
19+
20+
status=0
21+
sudo pg_createcluster --start$PGVERSIONtest -p 55435 -- -A trust
22+
23+
make USE_PGXS=1 PG_CONFIG=/usr/lib/postgresql/$PGVERSION/bin/pg_config
24+
sudo make install USE_PGXS=1 PG_CONFIG=/usr/lib/postgresql/$PGVERSION/bin/pg_config
25+
26+
# add pg_pathman to shared_preload_libraries
27+
sudo bash -c"echo\"shared_preload_libraries = 'pg_pathman'\" >> /etc/postgresql/$PGVERSION/test/postgresql.conf"
28+
sudo pg_ctlcluster$PGVERSIONtest restart
29+
30+
PGPORT=55435 make installcheck USE_PGXS=1 PGUSER=postgres PG_CONFIG=/usr/lib/postgresql/$PGVERSION/bin/pg_config|| status=$?
31+
32+
iftest -f regression.diffs;then cat regression.diffs;fi
33+
exit$status

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp