| 1 |
# $Id$ |
| 2 |
# Authority: charliebrady |
| 3 |
# Name: Charlie Brady |
| 4 |
|
| 5 |
Summary: e-smith specific postgresql configuration and templates. |
| 6 |
%define name smeserver-postgresql |
| 7 |
Name: %{name} |
| 8 |
%define version 0.0.1 |
| 9 |
%define release 24 |
| 10 |
Version: %{version} |
| 11 |
Release: %{release}%{?dist} |
| 12 |
License: GPL |
| 13 |
Group: Networking/Daemons |
| 14 |
Source: %{name}-%{version}.tar.gz |
| 15 |
Patch0: smeserver-postgresql-0.0.1.chpst.patch |
| 16 |
Patch1: smeserver-postgresql-0.0.1.config_templates.patch |
| 17 |
Patch2: smeserver-postgresql-0.0.1.chpst.patch2 |
| 18 |
Patch3: smeserver-postgresql-0.0.1.config_templates.patch2 |
| 19 |
Patch4: smeserver-postgresql-0.0.1.restore.patch |
| 20 |
Patch5: smeserver-postgresql-0.0.1.restore.patch2 |
| 21 |
Patch6: smeserver-postgresql-0.0.1.tcpip_socket.patch |
| 22 |
Patch7: smeserver-postgresql-0.0.1.permissions.patch |
| 23 |
Patch8: smeserver-postgresql-0.0.1.chpst.patch3 |
| 24 |
Patch9: smeserver-postgresql-0.0.1.permissions.patch2 |
| 25 |
Patch10: smeserver-postgresql-0.0.1.tcpip_socket.patch2 |
| 26 |
Patch11: smeserver-postgresql-0.0.1.startup.patch |
| 27 |
Patch12: smeserver-postgresql-0.0.1.sigterm.patch |
| 28 |
Patch13: smeserver-postgresql-0.0.1.disabled_pre_backup.patch |
| 29 |
Patch14: smeserver-postgresql-0.0.1.restore.patch3 |
| 30 |
Patch15: smeserver-postgresql-0.0.1.restore.patch4 |
| 31 |
Patch16: smeserver-postgresql-0.0.1.restore.patch5 |
| 32 |
Patch17: smeserver-postgresql-0.0.1.restore.patch6 |
| 33 |
Patch18: smeserver-postgresql-0.0.1.tcpip_socket.patch3 |
| 34 |
Patch19: smeserver-postgresql-0.0.1.tcpip_socket.patch4 |
| 35 |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
| 36 |
BuildArch: noarch |
| 37 |
Requires: e-smith-base |
| 38 |
Requires: postgresql |
| 39 |
Requires: postgresql-server |
| 40 |
Requires: e-smith-lib >= 1.15.1-19 |
| 41 |
BuildRequires: e-smith-devtools >= 1.13.1-03 |
| 42 |
AutoReqProv: no |
| 43 |
|
| 44 |
%changelog |
| 45 |
* Tue Sep 11 2007 Charlie Brady <charlieb@e-smith.com> 0.0.1-24 |
| 46 |
- Add support for localhost/private/public access settings to |
| 47 |
determine which network interfaces to bind to. |
| 48 |
|
| 49 |
* Thu May 24 2007 Charlie Brady <charlieb@e-smith.com> 0.0.1-23 |
| 50 |
- Determine correct format for network access specs in postgresql.conf |
| 51 |
at template expansion time (postgresql 7 and 8 need different |
| 52 |
directives). |
| 53 |
|
| 54 |
* Sun Apr 29 2007 Shad L. Lords <slords@mail.com> |
| 55 |
- Clean up spec so package can be built by koji/plague |
| 56 |
|
| 57 |
* Tue Feb 06 2007 Charlie Brady <charlieb@e-smith.com> 0.0.1-22 |
| 58 |
- Escape braces in full restore template. |
| 59 |
|
| 60 |
* Thu Dec 07 2006 Shad L. Lords <slords@mail.com> |
| 61 |
- Update to new release naming. No functional changes. |
| 62 |
- Make Packager generic |
| 63 |
|
| 64 |
* Fri Dec 01 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-21 |
| 65 |
- Tighten permissions of dump file so that it is never world |
| 66 |
readable. |
| 67 |
- Fix restore scriptlet so that it exits silently if there is no |
| 68 |
dump to restore from. |
| 69 |
- Fix taint problem with restore script. |
| 70 |
- Fix services2adjust symlink names so that postgresl is stopped |
| 71 |
prior to restore, and restarted during timezone change. |
| 72 |
|
| 73 |
* Wed Oct 18 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-20 |
| 74 |
- Expand template for 00_restore_backup pgsql.init script during |
| 75 |
pre-restore event, so that the dump is restored following next |
| 76 |
reboot. |
| 77 |
|
| 78 |
* Tue Oct 17 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-19 |
| 79 |
- Fix permissions problem with restore from backup. |
| 80 |
|
| 81 |
* Mon Sep 25 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-18 |
| 82 |
- Ensure that pre-backup event does not fail if postgresql is disabled. |
| 83 |
- Apply sigterm patch - included in -17 source, but not applied in build. |
| 84 |
|
| 85 |
* Thu Sep 21 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-17 |
| 86 |
- Add control/t script so that SIGINT is used to terminate postgresql |
| 87 |
(so that existing connections cannot keep the server up indefinitely). |
| 88 |
|
| 89 |
* Thu Sep 14 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-16 |
| 90 |
- Fix run script so that conf templates are not run until after |
| 91 |
initdb. |
| 92 |
|
| 93 |
* Thu Sep 7 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-15 |
| 94 |
- Fix permissions of run files (typo). |
| 95 |
|
| 96 |
* Tue Aug 29 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-14 |
| 97 |
- Fix comparison operator in tcpip template fragment. |
| 98 |
|
| 99 |
* Tue Aug 29 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-13 |
| 100 |
- Fix ownership of config files (typo). |
| 101 |
|
| 102 |
* Tue Aug 29 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-12 |
| 103 |
- Run all pgsql.init scripts is user 'postgres'. |
| 104 |
|
| 105 |
* Thu Aug 24 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-11 |
| 106 |
- Require passwords for local socket and loopback socket connections |
| 107 |
except for 'postgres' user connecting via Unix domain socket. |
| 108 |
|
| 109 |
* Mon Aug 21 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-10 |
| 110 |
- Add option to accept connections on tcpip socket. |
| 111 |
|
| 112 |
* Fri Aug 04 2006 Charlie Brady <charlie_brady@mitel.com> 0.0.1-09 |
| 113 |
- Fix permissions on log/run file, and fix name of pgsql/init |
| 114 |
directory. |
| 115 |
|
| 116 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 117 |
- [0.0.1-08] |
| 118 |
- Deal more correctly with pgsql.init startup race condition. |
| 119 |
|
| 120 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 121 |
- [0.0.1-07] |
| 122 |
- Add full database restore feature. |
| 123 |
|
| 124 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 125 |
- [0.0.1-06] |
| 126 |
- Move config templates to the correct place. |
| 127 |
- Fix delete-db action to remove empty subdirectories of |
| 128 |
/var/lib/pgsql/data. |
| 129 |
|
| 130 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 131 |
- [0.0.1-05] |
| 132 |
- Use chpst rather than setuidgid in run script. |
| 133 |
|
| 134 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 135 |
- [0.0.1-04] |
| 136 |
- Add minimal templated configuration files. |
| 137 |
|
| 138 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 139 |
- [0.0.1-03] |
| 140 |
- Fix broken pqsql.init. |
| 141 |
|
| 142 |
* Wed Jun 28 2006 Charlie Brady <charlieb@e-smith.com> |
| 143 |
- [0.0.1-02] |
| 144 |
- Add missing /etc/e-smith/pgsql/init directory |
| 145 |
|
| 146 |
* Wed May 24 2006 Charlie Brady <charlieb@e-smith.com> |
| 147 |
- [0.0.1-01] |
| 148 |
- initial release |
| 149 |
|
| 150 |
%description |
| 151 |
This package adds necessary startup and configuration items for |
| 152 |
postgresql. |
| 153 |
|
| 154 |
%prep |
| 155 |
%setup |
| 156 |
%patch0 -p1 |
| 157 |
%patch1 -p1 |
| 158 |
%patch2 -p1 |
| 159 |
%patch3 -p1 |
| 160 |
%patch4 -p1 |
| 161 |
%patch5 -p1 |
| 162 |
%patch6 -p1 |
| 163 |
%patch7 -p1 |
| 164 |
%patch8 -p1 |
| 165 |
%patch9 -p1 |
| 166 |
%patch10 -p1 |
| 167 |
%patch11 -p1 |
| 168 |
%patch12 -p1 |
| 169 |
%patch13 -p1 |
| 170 |
%patch14 -p1 |
| 171 |
%patch15 -p1 |
| 172 |
%patch16 -p1 |
| 173 |
%patch17 -p1 |
| 174 |
%patch18 -p1 |
| 175 |
%patch19 -p1 |
| 176 |
|
| 177 |
%build |
| 178 |
mkdir -p root/etc/e-smith/pgsql/init |
| 179 |
perl createlinks |
| 180 |
|
| 181 |
mkdir -p root/etc/rc.d/init.d/supervise |
| 182 |
ln -s ../daemontools root/etc/rc.d/init.d/supervise/postgresql |
| 183 |
|
| 184 |
mkdir -p root/etc/rc.d/rc7.d |
| 185 |
ln -s /etc/rc.d/init.d/e-smith-service root/etc/rc.d/rc7.d/S50postgresql |
| 186 |
ln -s /etc/rc.d/init.d/e-smith-service root/etc/rc.d/rc7.d/S99pgsql.init |
| 187 |
|
| 188 |
mkdir -p root/service |
| 189 |
ln -s /var/service/postgresql root/service |
| 190 |
touch root/var/service/postgresql/down |
| 191 |
|
| 192 |
mkdir -p root/var/log/postgresql |
| 193 |
mkdir -p root/home/e-smith/db/pgsql |
| 194 |
mkdir -p root/etc/e-smith/pgsql/init |
| 195 |
|
| 196 |
|
| 197 |
%install |
| 198 |
rm -rf $RPM_BUILD_ROOT |
| 199 |
(cd root ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT) |
| 200 |
/sbin/e-smith/genfilelist $RPM_BUILD_ROOT \ |
| 201 |
--file /var/service/postgresql/run 'attr(0750,root,root)' \ |
| 202 |
--file /var/service/postgresql/log/run 'attr(0750,root,root)' \ |
| 203 |
--file /var/service/postgresql/control/t 'attr(0750,root,root)' \ |
| 204 |
--dir '/var/log/postgresql' 'attr(2750,smelog,smelog)' \ |
| 205 |
--dir '/home/e-smith/db' 'attr(0750,root,root)' \ |
| 206 |
--dir '/home/e-smith/db/pgsql' 'attr(0750,root,root)' \ |
| 207 |
> %{name}-%{version}-filelist |
| 208 |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
| 209 |
|
| 210 |
%clean |
| 211 |
rm -rf $RPM_BUILD_ROOT |
| 212 |
|
| 213 |
%files -f %{name}-%{version}-filelist |
| 214 |
%defattr(-,root,root) |
Parent Directory
| 
Revision Log
| 
Revision Graph
