rpms/postgresql-pgpool-II/EL-5 pgpool.conf.sample.patch, 1.3, 1.4 pgpool.init, 1.1, 1.2 postgresql-pgpool-II.spec, 1.13, 1.14
Devrim GÜNDÜZ
devrim at fedoraproject.org
Mon Mar 23 09:36:10 UTC 2009
Author: devrim
Update of /cvs/extras/rpms/postgresql-pgpool-II/EL-5
In directory cvs1.fedora.phx.redhat.com:/tmp/cvs-serv7266
Modified Files:
pgpool.conf.sample.patch pgpool.init postgresql-pgpool-II.spec
Log Message:
- Fix pid file path in init script.
- Fix spec file -- we don't use short_name macro in pgcore spec file.
- Create pgpool pid file directory.
- Fix stop/start routines, also improve init script a bit.
- Install conf files to a new directory (/etc/pgpool-II), and get rid
of sample conf files.
pgpool.conf.sample.patch:
Index: pgpool.conf.sample.patch
===================================================================
RCS file: /cvs/extras/rpms/postgresql-pgpool-II/EL-5/pgpool.conf.sample.patch,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- pgpool.conf.sample.patch 12 Aug 2008 05:34:20 -0000 1.3
+++ pgpool.conf.sample.patch 23 Mar 2009 09:36:08 -0000 1.4
@@ -1,24 +1,22 @@
---- pgpool.conf.sample.old 2008-08-12 08:26:07.000000000 +0300
-+++ pgpool.conf.sample 2008-08-12 08:27:31.000000000 +0300
+--- pgpool.conf.sample.old 2009-03-22 22:18:52.000000000 +0200
++++ pgpool.conf.sample 2009-03-22 22:46:20.000000000 +0200
@@ -12,16 +12,14 @@
# Port number for pgpool communication manager
pcp_port = 9898
-# Unix domain socket path. (The Debian package defaults to
-# /var/run/postgresql.)
--socket_dir = '/tmp'
-+# Unix domain socket path.
-+socket_dir = '/var/run'
++# Unix domain socket path.
+ socket_dir = '/tmp'
# Unix domain socket path for pgpool communication manager.
-# (Debian package defaults to /var/run/postgresql)
--pcp_socket_dir = '/tmp'
-+pcp_socket_dir = '/var/run'
+ pcp_socket_dir = '/tmp'
-# Unix domain socket path for the backend. Debian package defaults to /var/run/postgresql!
-backend_socket_dir = '/tmp'
-+# Unix domain socket path for the backend.
-+backend_socket_dir = '/var/run'
++# Unix domain socket path for the backend.
++backend_socket_dir = '/var/run/pgpool'
# pgpool communication manager timeout. 0 means no timeout, but strongly not recommended!
pcp_timeout = 10
@@ -27,7 +25,22 @@
# Logging directory
-logdir = '/tmp'
-+logdir = '/var/run'
++logdir = '/var/log/pgpool'
- # Replication mode
- replication_mode = false
+ # pid file name
+ pid_file_name = '/var/run/pgpool/pgpool.pid'
+@@ -166,10 +164,10 @@
+
+ # backend_hostname, backend_port, backend_weight
+ # here are examples
+-#backend_hostname0 = 'host1'
+-#backend_port0 = 5432
+-#backend_weight0 = 1
+-#backend_data_directory0 = '/data'
++backend_hostname0 = 'localhost'
++backend_port0 = 5432
++backend_weight0 = 1
++backend_data_directory0 = '/var/lib/pgsql/data'
+ #backend_hostname1 = 'host2'
+ #backend_port1 = 5433
+ #backend_weight1 = 1
Index: pgpool.init
===================================================================
RCS file: /cvs/extras/rpms/postgresql-pgpool-II/EL-5/pgpool.init,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- pgpool.init 16 Aug 2007 09:22:43 -0000 1.1
+++ pgpool.init 23 Mar 2009 09:36:08 -0000 1.2
@@ -8,6 +8,9 @@
#
# v1.0.0 Devrim GUNDUZ <devrim at CommandPrompt.com>
# - Initial version of Red Hat / Fedora init script
+#
+# v2.2 Devrim GUNDUZ <devrim at CommandPrompt.com>
+# - New and improved version which has some fixes.
if [ -r /etc/sysconfig/pgpool ]; then
. /etc/sysconfig/pgpool
@@ -28,25 +31,23 @@
[ "${NETWORKING}" = "no" ] && exit 0
# Find the name of the script
-NAME=pgpool
+NAME=`basename $0`
+if [ ${NAME:0:1} = "S" -o ${NAME:0:1} = "K" ]
+then
+ NAME=${NAME:3}
+fi
# Set defaults for configuration variables
PGPOOLENGINE=/usr/bin
PGPOOLDAEMON=$PGPOOLENGINE/pgpool
-PGPOOLCONF=/etc/pgpool.conf
-PGPOOLPID=/var/run/pgpool.pid
+PGPOOLCONF=/etc/pgpool-II/pgpool.conf
+PGPOOLPIDDIR=/var/run/pgpool
PGPOOLLOG=/var/log/pgpool.log
test -x $PGPOOLDAEMON || exit 5
-# Create the log file if it does not exist
-if [ ! -r $PGPOOLLOG ]
-then
- touch $PGPOOLLOG
-fi
-
# Check whether the config file exists or not
-if [ ! -r /etc/pgpool.conf ]
+if [ ! -r $PGPOOLCONF ]
then
echo "$PGPOOLCONF not found"
RETVAL=1
@@ -54,12 +55,36 @@
exit
fi
+# Create the log file if it does not exist
+if [ ! -x $PGPOOLLOG ]
+then
+ touch $PGPOOLLOG
+ chown postgres: $PGPOOLLOG
+fi
+
+if [ ! -d $PGPOOLPIDDIR ]
+then
+ mkdir $PGPOOLPIDDIR
+ chown postgres: $PGPOOLPIDDIR
+fi
+
script_result=0
start(){
+ pid=`pidof -s "$PGPOOLDAEMON"`
+ if [ $pid ]
+ then
+ echo "pgpool is already running with pid $pid"
+ failure "$PGPOQL_START"
+ echo
+ script_result=1
+ exit 1
+ fi
+
PGPOOL_START=$"Starting ${NAME} service: "
echo -n "$PGPOOL_START"
+
$PGPOOLDAEMON -f $PGPOOLCONF $OPTS & >> "$PGPOOLLOG" 2>&1 < /dev/null
sleep 2
@@ -70,7 +95,7 @@
touch /var/lock/subsys/${NAME}
echo
else
- failure "$PSQL_START"
+ failure "$PGPOQL_START"
echo
script_result=1
fi
@@ -82,7 +107,8 @@
RETVAL=1
failure
else
- killproc /usr/bin/pgpool
+ killproc /usr/bin/pgpool
+# $PGPOOLDAEMON stop & >> "$PGPOOLLOG" 2>&1 < /dev/null
RETVAL=$?
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/${NAME}
fi;
@@ -92,7 +118,7 @@
switch() {
echo -n $"Sending switchover request to $NAME "
- $PGPOOLDAEMON switch >> "$PGPOOLLOG" 2>&1 < /dev/null
+ $PGPOOLDAEMON -f $PGPOOLCONF switch >> "$PGPOOLLOG" 2>&1 < /dev/null
RETVAL=$?
echo
if [ $RETVAL -eq 0 ]
@@ -110,22 +136,23 @@
}
reload(){
-echo -n $"Reloading ${NAME}: "
- if [ -n "`pidfileofproc $PGPOOLDAEMON`" ] ; then
- killproc $PGPOOLDAEMON -HUP
- else
- failure $"Reloading ${NAME}"
- fi
- RETVAL=$?
- echo
+ echo -n $"Reloading ${NAME}: "
+
+ if [ -n "`pidfileofproc $PGPOOLDAEMON`" ] ; then
+ killproc $PGPOOLDAEMON -HUP
+ else
+ failure $"Reloading ${NAME}"
+ fi
+ RETVAL=$?
+ echo
}
condrestart(){
- [ -e /var/lock/subsys/${NAME} ] && restart
+ [ -e /var/lock/subsys/${NAME} ] && restart
}
condstop(){
- [ -e /var/lock/subsys/${NAME} ] && stop
+ [ -e /var/lock/subsys/${NAME} ] && stop
}
# See how we were called.
Index: postgresql-pgpool-II.spec
===================================================================
RCS file: /cvs/extras/rpms/postgresql-pgpool-II/EL-5/postgresql-pgpool-II.spec,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- postgresql-pgpool-II.spec 1 Mar 2009 14:57:55 -0000 1.13
+++ postgresql-pgpool-II.spec 23 Mar 2009 09:36:08 -0000 1.14
@@ -3,7 +3,7 @@
Summary: Pgpool is a connection pooling/replication server for PostgreSQL
Name: postgresql-%{short_name}
Version: 2.2
-Release: 1%{?dist}
+Release: 1%{?dist}.1
License: BSD
Group: Applications/Databases
URL: http://pgpool.projects.PostgreSQL.org
@@ -47,7 +47,7 @@
%patch1 -p0
%build
-%configure --with-pgsql-includedir=%{_includedir}/pgsql --with-pgsql-lib=%{_libdir}/pgsql --disable-static --with-pam --disable-rpath
+%configure --with-pgsql-includedir=%{_includedir}/pgsql --with-pgsql-lib=%{_libdir}/pgsql --disable-static --with-pam --disable-rpath --sysconfdir=%{_sysconfdir}/%{short_name}/
make %{?_smp_flags}
@@ -55,7 +55,10 @@
rm -rf %{buildroot}
make %{?_smp_flags} DESTDIR=%{buildroot} install
install -d %{buildroot}%{_datadir}/%{short_name}
-mv %{buildroot}/%{_sysconfdir}/*.conf.sample %{buildroot}%{_datadir}/%{short_name}
+install -d %{buildroot}%{_sysconfdir}/%{short_name}
+mv %{buildroot}/%{_sysconfdir}/%{short_name}/pcp.conf.sample %{buildroot}%{_sysconfdir}/%{short_name}/pcp.conf
+mv %{buildroot}/%{_sysconfdir}/%{short_name}/pgpool.conf.sample %{buildroot}%{_sysconfdir}/%{short_name}/pgpool.conf
+mv %{buildroot}/%{_sysconfdir}/%{short_name}/pool_hba.conf.sample %{buildroot}%{_sysconfdir}/%{short_name}/pool_hba.conf
install -d %{buildroot}%{_initrddir}
install -m 755 %{SOURCE1} %{buildroot}%{_initrddir}/pgpool
install -d %{buildroot}%{_sysconfdir}/sysconfig
@@ -88,11 +91,12 @@
%{_bindir}/pcp_systemdb_info
%{_bindir}/pg_md5
%{_mandir}/man8/pgpool*
+%dir %{_datadir}/%{short_name}
%{_datadir}/%{short_name}/system_db.sql
%{_libdir}/libpcp.so.*
-%attr(764,root,root) %{_datadir}/%{short_name}/*.conf.sample
%{_datadir}/%{short_name}/pgpool.pam
%{_initrddir}/pgpool
+%attr(764,root,apache) %config(noreplace) %{_sysconfdir}/%{short_name}/*.conf
%config(noreplace) %{_sysconfdir}/sysconfig/pgpool
%files devel
@@ -102,6 +106,14 @@
%{_libdir}/libpcp.so
%changelog
+* Mon Mar 23 2009 Devrim Gunduz <devrim at CommandPrompt.com> 2.2-1.1
+- Fix pid file path in init script.
+- Fix spec file -- we don't use short_name macro in pgcore spec file.
+- Create pgpool pid file directory.
+- Fix stop/start routines, also improve init script a bit.
+- Install conf files to a new directory (/etc/pgpool-II), and get rid
+ of sample conf files.
+
* Sun Mar 1 2009 Devrim Gunduz <devrim at CommandPrompt.com> 2.2-1
- Update to 2.2
- Fix URL
More information about the fedora-extras-commits
mailing list