Attachment #37269 for bug #59402

View | Details | Raw Unified | Return to bug 59402
Collapse All | Expand All

Lines 5-13 Link Here

(-)Makefile (-8 / +16 lines)
5	# $FreeBSD: ports/databases/postgresql7/Makefile,v 1.115 2003/10/13 09:54:16 edwin Exp $	5	# $FreeBSD: ports/databases/postgresql7/Makefile,v 1.115 2003/10/13 09:54:16 edwin Exp $
6	#	6	#
7		7
8	PORTNAME?= postgresql	8	PORTNAME= postgresql
9	PORTVERSION?= 7.3.4	9	PORTVERSION?= 7.4
10	PORTREVISION= 1	10	PORTREVISION?= 0
11	CATEGORIES?= databases	11	CATEGORIES?= databases
12	MASTER_SITES= ${MASTER_SITE_PGSQL}	12	MASTER_SITES= ${MASTER_SITE_PGSQL}
13	MASTER_SITE_SUBDIR= source/v${PORTVERSION}	13	MASTER_SITE_SUBDIR= source/v${PORTVERSION}
Lines 20-25 Link Here
20	WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION}	20	WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION}
21	DIST_SUBDIR= postgresql	21	DIST_SUBDIR= postgresql
22		22
		23	USE_BZIP2= YES
23	USE_GMAKE= YES	24	USE_GMAKE= YES
24	GNU_CONFIGURE= YES	25	GNU_CONFIGURE= YES
25		26
Lines 36-41 Link Here
36	--with-includes=${LOCALBASE}/include	37	--with-includes=${LOCALBASE}/include
37	CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"	38	CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"
38		39
		40	.if defined(WITH_PAM)
		41	CONFIGURE_ARGS+= --with-pam
		42	.endif
		43
39	.if !defined(WITHOUT_GNUGETOPT)	44	.if !defined(WITHOUT_GNUGETOPT)
40	USE_GETOPT_LONG=yes	45	USE_GETOPT_LONG=yes
41	.endif	46	.endif
Lines 50-56 Link Here
50	.endif	55	.endif
51		56
52	.if defined(WITH_OPTIMIZED_CFLAGS)	57	.if defined(WITH_OPTIMIZED_CFLAGS)
53	CFLAGS+= -O3 -funroll-loops	58	CFLAGS+= -O3 -funroll-loops
54	.endif	59	.endif
55		60
56	.if defined(WITH_DEBUG)	61	.if defined(WITH_DEBUG)
Lines 62-79 Link Here
62		67
63	.if !defined(WITHOUT_SSL)	68	.if !defined(WITHOUT_SSL)
64	USE_OPENSSL= yes	69	USE_OPENSSL= yes
65	CONFIGURE_ARGS+= "--with-openssl=${OPENSSLBASE}"	70	CONFIGURE_ARGS+= "--with-openssl=${OPENSSLBASE}"
66	.endif	71	.endif
67		72
68	.if defined(WITHOUT_SERVER)	73	.if defined(WITHOUT_SERVER)
69	PLIST_SUB+= SERVER="@comment "	74	PLIST_SUB+= SERVER="@comment "
70	PKGNAMESUFFIX= -client	75	PKGNAMESUFFIX= -client
71	PKGMSG= ""	76	PKGMSG= ""
		77	CONFLICTS= postgresql-7*
72	.else	78	.else
73	PKGMESSAGE= ${FILESDIR}/pkg-message.server	79	PKGMESSAGE= ${FILESDIR}/pkg-message.server
74	PKGMSG= ${PKGMESSAGE}	80	PKGMSG= ${PKGMESSAGE}
		81	CONFLICTS= postgresql-7*client
75	PLIST_SUB+= SERVER=""	82	PLIST_SUB+= SERVER=""
76	INSTALL_TARGET+= install-all-headers	83	INSTALL_TARGET+= install-all-headers
77	MAKEFILE= GNUmakefile	84	MAKEFILE= GNUmakefile
78	.endif	85	.endif
79		86
Lines 92-98 Link Here
92	.if defined(WITH_KRB5)	99	.if defined(WITH_KRB5)
93	CONFIGURE_ARGS+= --with-krb5="`${KRB5CONF} --prefix krb5`"	100	CONFIGURE_ARGS+= --with-krb5="`${KRB5CONF} --prefix krb5`"
94	LDFLAGS+= `${KRB5CONF} --libs krb5`	101	LDFLAGS+= `${KRB5CONF} --libs krb5`
95	CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"	102	CONFIGURE_ENV= LDFLAGS="${LDFLAGS}"
96	.endif	103	.endif
97		104
98	.if defined(WITH_TESTS)	105	.if defined(WITH_TESTS)
Lines 142-150 Link Here
142	@${ECHO} " WITHOUT_GETTEXT Skips building with support for"	149	@${ECHO} " WITHOUT_GETTEXT Skips building with support for"
143	@${ECHO} " internationalized error messages"	150	@${ECHO} " internationalized error messages"
144	@${ECHO} " WITHOUT_SERVER Don't install the server,"	151	@${ECHO} " WITHOUT_SERVER Don't install the server,"
145	@${ECHO} " only install binaries, headers and libs"	152	@${ECHO} " only install binaries, headers and libs"
146	@${ECHO} " for PostgreSQL clients"	153	@${ECHO} " for PostgreSQL clients"
147	@${ECHO} " WITHOUT_SSL Builds without OpenSSL support"	154	@${ECHO} " WITHOUT_SSL Builds without OpenSSL support"
		155	@${ECHO} " WITH_PAM Builds with PAM support"
148	@${ECHO} " WITH_MIT_KRB5 Builds with MIT's kerberos support"	156	@${ECHO} " WITH_MIT_KRB5 Builds with MIT's kerberos support"
149	@${ECHO} " WITH_HEIMDAL_KRB5 Builds with Heimdal's kerberos support"	157	@${ECHO} " WITH_HEIMDAL_KRB5 Builds with Heimdal's kerberos support"
150	@${ECHO} " WITH_OPTIMIZED_CFLAGS Builds with compiler optimizations (-O3)"	158	@${ECHO} " WITH_OPTIMIZED_CFLAGS Builds with compiler optimizations (-O3)"

Lines 1-4 Link Here

(-)distinfo (-4 / +4 lines)
1	MD5 (postgresql/postgresql-base-7.3.4.tar.gz) = 2b8600cc0f0c2d80271b533c394c886b	1	MD5 (postgresql/postgresql-base-7.4.tar.bz2) = a1af58384f506ed63c1d960ab43a2b3b
2	MD5 (postgresql/postgresql-opt-7.3.4.tar.gz) = 3a0f0254bf9d6dccc61baa149c68ae75	2	MD5 (postgresql/postgresql-opt-7.4.tar.bz2) = df425a08172b1e6ca41e7720b65a6b15
3	MD5 (postgresql/postgresql-docs-7.3.4.tar.gz) = 0144134674614e6b6a54103482f8acb2	3	MD5 (postgresql/postgresql-test-7.4.tar.bz2) = 3c104928f6dadb8fa6086b5ae8060835
4	MD5 (postgresql/postgresql-test-7.3.4.tar.gz) = 7734ec70bb8e3d3bb3ba49e6dcee10e5	4	MD5 (postgresql/postgresql-docs-7.4.tar.bz2) = b8f1d43dc64b6813b3239f36425c8cb8

Lines 33-53 Link Here

(-)pkg-plist (-36 / +98 lines)
33	include/postgresql/internal/postgres_fe.h	33	include/postgresql/internal/postgres_fe.h
34	include/postgresql/internal/pqexpbuffer.h	34	include/postgresql/internal/pqexpbuffer.h
35	@dirrm include/postgresql/internal	35	@dirrm include/postgresql/internal
		36	include/compatlib.h
		37	include/datetime.h
		38	include/decimal.h
		39	include/ecpg_informix.h
36	include/ecpgerrno.h	40	include/ecpgerrno.h
37	include/ecpglib.h	41	include/ecpglib.h
38	include/ecpgtype.h	42	include/ecpgtype.h
39	include/libpq-fe.h	43	include/libpq-fe.h
40	include/pg_config.h	44	include/pg_config.h
41	include/pg_config_os.h	45	include/pg_config_os.h
		46	include/pgtypes_date.h
		47	include/pgtypes_error.h
		48	include/pgtypes_interval.h
		49	include/pgtypes_numeric.h
		50	include/pgtypes_timestamp.h
42	include/postgres_ext.h	51	include/postgres_ext.h
43	include/sql3types.h	52	include/sql3types.h
44	include/sqlca.h	53	include/sqlca.h
		54	include/sqlda.h
		55	include/sqltypes.h
45	lib/libecpg.a	56	lib/libecpg.a
46	lib/libecpg.so	57	lib/libecpg.so
47	lib/libecpg.so.3	58	lib/libecpg.so.4
		59	lib/libecpg_compat.a
		60	lib/libecpg_compat.so
		61	lib/libecpg_compat.so.1
48	lib/libpq.a	62	lib/libpq.a
49	lib/libpq.so	63	lib/libpq.so
50	lib/libpq.so.3	64	lib/libpq.so.3
		65	lib/libpgtypes.a
		66	lib/libpgtypes.so
		67	lib/libpgtypes.so.1
51	%%SERVER%%lib/postgresql/ascii_and_mic.so	68	%%SERVER%%lib/postgresql/ascii_and_mic.so
52	%%SERVER%%lib/postgresql/cyrillic_and_mic.so	69	%%SERVER%%lib/postgresql/cyrillic_and_mic.so
53	%%SERVER%%lib/postgresql/euc_cn_and_mic.so	70	%%SERVER%%lib/postgresql/euc_cn_and_mic.so
Lines 77-133 Link Here
77	%%SERVER%%lib/postgresql/plpgsql.so	94	%%SERVER%%lib/postgresql/plpgsql.so
78	@unexec rmdir %D/lib/postgresql 2>/dev/null \|\| true	95	@unexec rmdir %D/lib/postgresql 2>/dev/null \|\| true
79	%%SERVER%%share/postgresql/502.pgsql	96	%%SERVER%%share/postgresql/502.pgsql
80	%%SERVER%%share/postgresql/postgres.bki	97	%%SERVER%%share/postgresql/conversion_create.sql
81	%%SERVER%%share/postgresql/postgres.description	98	%%SERVER%%share/postgresql/information_schema.sql
82	%%SERVER%%share/postgresql/pg_hba.conf.sample	99	%%SERVER%%share/postgresql/pg_hba.conf.sample
83	%%SERVER%%share/postgresql/pg_ident.conf.sample	100	%%SERVER%%share/postgresql/pg_ident.conf.sample
		101	%%SERVER%%share/postgresql/pg_service.conf.sample
		102	%%SERVER%%share/postgresql/postgres.bki
		103	%%SERVER%%share/postgresql/postgres.description
84	%%SERVER%%share/postgresql/postgresql.conf.sample	104	%%SERVER%%share/postgresql/postgresql.conf.sample
85	%%SERVER%%share/postgresql/conversion_create.sql	105	%%SERVER%%share/postgresql/sql_features.txt
86	share/postgresql/post-install-notes	106	share/postgresql/post-install-notes
87	@unexec rmdir %D/share/postgresql 2>/dev/null \|\| true	107	@unexec rmdir %D/share/postgresql 2>/dev/null \|\| true
		108	%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
		109	%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_controldata.mo
88	%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_dump.mo	110	%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_dump.mo
		111	%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_resetxlog.mo
		112	%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts.mo
89	%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql.mo	113	%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql.mo
90	%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
91	%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump.mo	114	%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump.mo
92	%%GETTEXT%%share/locale/de/LC_MESSAGES/psql.mo	115	%%GETTEXT%%share/locale/de/LC_MESSAGES/psql.mo
93	%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata.mo	116	%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata.mo
94	%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog.mo	117	%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog.mo
95	%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq.mo	118	%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq.mo
96	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo	119	%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts.mo
		120	%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
		121	%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
		122	%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump.mo
		123	%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog.mo
		124	%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts.mo
		125	%%GETTEXT%%share/locale/es/LC_MESSAGES/psql.mo
		126	%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
		127	%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
		128	%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
		129	%%GETTEXT%%share/locale/hr/LC_MESSAGES/libpq.mo
		130	%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
		131	%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
		132	%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
		133	%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq.mo
		134	%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata.mo
		135	%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump.mo
		136	%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog.mo
		137	%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts.mo
		138	%%GETTEXT%%share/locale/it/LC_MESSAGES/psql.mo
		139	%%GETTEXT%%share/locale/nb/LC_MESSAGES/libpq.mo
		140	%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_controldata.mo
		141	%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_dump.mo
		142	%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_resetxlog.mo
		143	%%GETTEXT%%share/locale/nb/LC_MESSAGES/psql.mo
		144	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo
97	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata.mo	145	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata.mo
		146	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo
98	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo	147	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo
99	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo	148	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts.mo
100	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo	149	%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql.mo
101	%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo	150	%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo
102	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_controldata.mo	151	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_controldata.mo
		152	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo
103	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog.mo	153	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog.mo
104	%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo	154	%%GETTEXT%%share/locale/ru/LC_MESSAGES/pgscripts.mo
105	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo	155	%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo
106	%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo	156	%%GETTEXT%%share/locale/sl/LC_MESSAGES/libpq.mo
		157	%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_controldata.mo
		158	%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_resetxlog.mo
		159	%%GETTEXT%%share/locale/sl/LC_MESSAGES/pgscripts.mo
		160	%%GETTEXT%%share/locale/sl/LC_MESSAGES/psql.mo
		161	%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo
107	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata.mo	162	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata.mo
		163	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo
108	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog.mo	164	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog.mo
109	%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo	165	%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts.mo
110	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo	166	%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo
111	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo	167	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo
112	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata.mo	168	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
		169	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo
113	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo	170	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
114	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo	171	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts.mo
		172	%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo
		173	%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
115	%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_dump.mo	174	%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_dump.mo
116	%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/psql.mo	175	%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/psql.mo
117	%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
118	%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
119	%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
120	%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
121	%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
122	%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
123	%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
124	%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
125	%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
126	%%SERVER%%%%GETTEXT%%share/locale/cs/LC_MESSAGES/postgres.mo	176	%%SERVER%%%%GETTEXT%%share/locale/cs/LC_MESSAGES/postgres.mo
127	%%SERVER%%%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres.mo	177	%%SERVER%%%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres.mo
128	%%SERVER%%%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres.mo	178	%%SERVER%%%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres.mo
129	%%SERVER%%%%GETTEXT%%share/locale/hr/LC_MESSAGES/postgres.mo	179	%%SERVER%%%%GETTEXT%%share/locale/hr/LC_MESSAGES/postgres.mo
130	%%SERVER%%%%GETTEXT%%share/locale/hu/LC_MESSAGES/postgres.mo	180	%%SERVER%%%%GETTEXT%%share/locale/hu/LC_MESSAGES/postgres.mo
		181	%%SERVER%%%%GETTEXT%%share/locale/it/LC_MESSAGES/postgres.mo
		182	%%SERVER%%%%GETTEXT%%share/locale/nb/LC_MESSAGES/postgres.mo
		183	%%SERVER%%%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres.mo
131	%%SERVER%%%%GETTEXT%%share/locale/ru/LC_MESSAGES/postgres.mo	184	%%SERVER%%%%GETTEXT%%share/locale/ru/LC_MESSAGES/postgres.mo
132	%%SERVER%%%%GETTEXT%%share/locale/sv/LC_MESSAGES/postgres.mo	185	%%SERVER%%%%GETTEXT%%share/locale/sv/LC_MESSAGES/postgres.mo
133	%%SERVER%%%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres.mo	186	%%SERVER%%%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres.mo
Lines 173-178 Link Here
173	%%SERVER%%include/postgresql/server/access/rtscan.h	226	%%SERVER%%include/postgresql/server/access/rtscan.h
174	%%SERVER%%include/postgresql/server/access/sdir.h	227	%%SERVER%%include/postgresql/server/access/sdir.h
175	%%SERVER%%include/postgresql/server/access/skey.h	228	%%SERVER%%include/postgresql/server/access/skey.h
		229	%%SERVER%%include/postgresql/server/access/slru.h
176	%%SERVER%%include/postgresql/server/access/strat.h	230	%%SERVER%%include/postgresql/server/access/strat.h
177	%%SERVER%%include/postgresql/server/access/transam.h	231	%%SERVER%%include/postgresql/server/access/transam.h
178	%%SERVER%%include/postgresql/server/access/tupdesc.h	232	%%SERVER%%include/postgresql/server/access/tupdesc.h
Lines 222-227 Link Here
222	%%SERVER%%include/postgresql/server/catalog/pg_trigger.h	276	%%SERVER%%include/postgresql/server/catalog/pg_trigger.h
223	%%SERVER%%include/postgresql/server/catalog/pg_type.h	277	%%SERVER%%include/postgresql/server/catalog/pg_type.h
224	%%SERVER%%include/postgresql/server/catalog/pg_version.h	278	%%SERVER%%include/postgresql/server/catalog/pg_version.h
		279	%%SERVER%%include/postgresql/server/commands/alter.h
225	%%SERVER%%include/postgresql/server/commands/async.h	280	%%SERVER%%include/postgresql/server/commands/async.h
226	%%SERVER%%include/postgresql/server/commands/cluster.h	281	%%SERVER%%include/postgresql/server/commands/cluster.h
227	%%SERVER%%include/postgresql/server/commands/comment.h	282	%%SERVER%%include/postgresql/server/commands/comment.h
Lines 238-243 Link Here
238	%%SERVER%%include/postgresql/server/commands/sequence.h	293	%%SERVER%%include/postgresql/server/commands/sequence.h
239	%%SERVER%%include/postgresql/server/commands/tablecmds.h	294	%%SERVER%%include/postgresql/server/commands/tablecmds.h
240	%%SERVER%%include/postgresql/server/commands/trigger.h	295	%%SERVER%%include/postgresql/server/commands/trigger.h
		296	%%SERVER%%include/postgresql/server/commands/typecmds.h
241	%%SERVER%%include/postgresql/server/commands/user.h	297	%%SERVER%%include/postgresql/server/commands/user.h
242	%%SERVER%%include/postgresql/server/commands/vacuum.h	298	%%SERVER%%include/postgresql/server/commands/vacuum.h
243	%%SERVER%%include/postgresql/server/commands/variable.h	299	%%SERVER%%include/postgresql/server/commands/variable.h
Lines 271-276 Link Here
271	%%SERVER%%include/postgresql/server/executor/nodeUnique.h	327	%%SERVER%%include/postgresql/server/executor/nodeUnique.h
272	%%SERVER%%include/postgresql/server/executor/spi.h	328	%%SERVER%%include/postgresql/server/executor/spi.h
273	%%SERVER%%include/postgresql/server/executor/spi_priv.h	329	%%SERVER%%include/postgresql/server/executor/spi_priv.h
		330	%%SERVER%%include/postgresql/server/executor/tstoreReceiver.h
274	%%SERVER%%include/postgresql/server/executor/tuptable.h	331	%%SERVER%%include/postgresql/server/executor/tuptable.h
275	%%SERVER%%include/postgresql/server/lib/dllist.h	332	%%SERVER%%include/postgresql/server/lib/dllist.h
276	%%SERVER%%include/postgresql/server/lib/lispsort.h	333	%%SERVER%%include/postgresql/server/lib/lispsort.h
Lines 279-292 Link Here
279	%%SERVER%%include/postgresql/server/libpq/be-fsstubs.h	336	%%SERVER%%include/postgresql/server/libpq/be-fsstubs.h
280	%%SERVER%%include/postgresql/server/libpq/crypt.h	337	%%SERVER%%include/postgresql/server/libpq/crypt.h
281	%%SERVER%%include/postgresql/server/libpq/hba.h	338	%%SERVER%%include/postgresql/server/libpq/hba.h
		339	%%SERVER%%include/postgresql/server/libpq/ip.h
282	%%SERVER%%include/postgresql/server/libpq/libpq-be.h	340	%%SERVER%%include/postgresql/server/libpq/libpq-be.h
283	%%SERVER%%include/postgresql/server/libpq/libpq-fs.h	341	%%SERVER%%include/postgresql/server/libpq/libpq-fs.h
284	%%SERVER%%include/postgresql/server/libpq/libpq.h	342	%%SERVER%%include/postgresql/server/libpq/libpq.h
285	%%SERVER%%include/postgresql/server/libpq/password.h
286	%%SERVER%%include/postgresql/server/libpq/pqcomm.h	343	%%SERVER%%include/postgresql/server/libpq/pqcomm.h
287	%%SERVER%%include/postgresql/server/libpq/pqformat.h	344	%%SERVER%%include/postgresql/server/libpq/pqformat.h
288	%%SERVER%%include/postgresql/server/libpq/pqsignal.h	345	%%SERVER%%include/postgresql/server/libpq/pqsignal.h
289	%%SERVER%%include/postgresql/server/mb/pg_wchar.h	346	%%SERVER%%include/postgresql/server/mb/pg_wchar.h
		347	%%SERVER%%include/postgresql/server/nodes/bitmapset.h
290	%%SERVER%%include/postgresql/server/nodes/execnodes.h	348	%%SERVER%%include/postgresql/server/nodes/execnodes.h
291	%%SERVER%%include/postgresql/server/nodes/makefuncs.h	349	%%SERVER%%include/postgresql/server/nodes/makefuncs.h
292	%%SERVER%%include/postgresql/server/nodes/memnodes.h	350	%%SERVER%%include/postgresql/server/nodes/memnodes.h
Lines 342-347 Link Here
342	%%SERVER%%include/postgresql/server/port/aix.h	400	%%SERVER%%include/postgresql/server/port/aix.h
343	%%SERVER%%include/postgresql/server/port/beos.h	401	%%SERVER%%include/postgresql/server/port/beos.h
344	%%SERVER%%include/postgresql/server/port/bsdi.h	402	%%SERVER%%include/postgresql/server/port/bsdi.h
		403	%%SERVER%%include/postgresql/server/port/cygwin.h
345	%%SERVER%%include/postgresql/server/port/darwin.h	404	%%SERVER%%include/postgresql/server/port/darwin.h
346	%%SERVER%%include/postgresql/server/port/dgux.h	405	%%SERVER%%include/postgresql/server/port/dgux.h
347	%%SERVER%%include/postgresql/server/port/freebsd.h	406	%%SERVER%%include/postgresql/server/port/freebsd.h
Lines 360-372 Link Here
360	%%SERVER%%include/postgresql/server/port/ultrix4.h	419	%%SERVER%%include/postgresql/server/port/ultrix4.h
361	%%SERVER%%include/postgresql/server/port/univel.h	420	%%SERVER%%include/postgresql/server/port/univel.h
362	%%SERVER%%include/postgresql/server/port/unixware.h	421	%%SERVER%%include/postgresql/server/port/unixware.h
363	%%SERVER%%include/postgresql/server/port/win.h
364	%%SERVER%%include/postgresql/server/port/win32.h	422	%%SERVER%%include/postgresql/server/port/win32.h
365	%%SERVER%%include/postgresql/server/regex/cclass.h	423	%%SERVER%%include/postgresql/server/regex/regcustom.h
366	%%SERVER%%include/postgresql/server/regex/cname.h	424	%%SERVER%%include/postgresql/server/regex/regerrs.h
367	%%SERVER%%include/postgresql/server/regex/regex.h	425	%%SERVER%%include/postgresql/server/regex/regex.h
368	%%SERVER%%include/postgresql/server/regex/regex2.h	426	%%SERVER%%include/postgresql/server/regex/regguts.h
369	%%SERVER%%include/postgresql/server/regex/utils.h
370	%%SERVER%%include/postgresql/server/rewrite/prs2lock.h	427	%%SERVER%%include/postgresql/server/rewrite/prs2lock.h
371	%%SERVER%%include/postgresql/server/rewrite/rewriteDefine.h	428	%%SERVER%%include/postgresql/server/rewrite/rewriteDefine.h
372	%%SERVER%%include/postgresql/server/rewrite/rewriteHandler.h	429	%%SERVER%%include/postgresql/server/rewrite/rewriteHandler.h
Lines 392-398 Link Here
392	%%SERVER%%include/postgresql/server/storage/lock.h	449	%%SERVER%%include/postgresql/server/storage/lock.h
393	%%SERVER%%include/postgresql/server/storage/lwlock.h	450	%%SERVER%%include/postgresql/server/storage/lwlock.h
394	%%SERVER%%include/postgresql/server/storage/off.h	451	%%SERVER%%include/postgresql/server/storage/off.h
395	%%SERVER%%include/postgresql/server/storage/page.h
396	%%SERVER%%include/postgresql/server/storage/pg_sema.h	452	%%SERVER%%include/postgresql/server/storage/pg_sema.h
397	%%SERVER%%include/postgresql/server/storage/pg_shmem.h	453	%%SERVER%%include/postgresql/server/storage/pg_shmem.h
398	%%SERVER%%include/postgresql/server/storage/pmsignal.h	454	%%SERVER%%include/postgresql/server/storage/pmsignal.h
Lines 414-420 Link Here
414	%%SERVER%%include/postgresql/server/utils/acl.h	470	%%SERVER%%include/postgresql/server/utils/acl.h
415	%%SERVER%%include/postgresql/server/utils/array.h	471	%%SERVER%%include/postgresql/server/utils/array.h
416	%%SERVER%%include/postgresql/server/utils/ascii.h	472	%%SERVER%%include/postgresql/server/utils/ascii.h
417	%%SERVER%%include/postgresql/server/utils/bit.h
418	%%SERVER%%include/postgresql/server/utils/builtins.h	473	%%SERVER%%include/postgresql/server/utils/builtins.h
419	%%SERVER%%include/postgresql/server/utils/cash.h	474	%%SERVER%%include/postgresql/server/utils/cash.h
420	%%SERVER%%include/postgresql/server/utils/catcache.h	475	%%SERVER%%include/postgresql/server/utils/catcache.h
Lines 424-436 Link Here
424	%%SERVER%%include/postgresql/server/utils/dynahash.h	479	%%SERVER%%include/postgresql/server/utils/dynahash.h
425	%%SERVER%%include/postgresql/server/utils/dynamic_loader.h	480	%%SERVER%%include/postgresql/server/utils/dynamic_loader.h
426	%%SERVER%%include/postgresql/server/utils/elog.h	481	%%SERVER%%include/postgresql/server/utils/elog.h
427	%%SERVER%%include/postgresql/server/utils/fcache.h	482	%%SERVER%%include/postgresql/server/utils/errcodes.h
428	%%SERVER%%include/postgresql/server/utils/fmgroids.h	483	%%SERVER%%include/postgresql/server/utils/fmgroids.h
429	%%SERVER%%include/postgresql/server/utils/fmgrtab.h	484	%%SERVER%%include/postgresql/server/utils/fmgrtab.h
430	%%SERVER%%include/postgresql/server/utils/formatting.h	485	%%SERVER%%include/postgresql/server/utils/formatting.h
431	%%SERVER%%include/postgresql/server/utils/geo_decls.h	486	%%SERVER%%include/postgresql/server/utils/geo_decls.h
432	%%SERVER%%include/postgresql/server/utils/guc.h	487	%%SERVER%%include/postgresql/server/utils/guc.h
		488	%%SERVER%%include/postgresql/server/utils/guc_tables.h
433	%%SERVER%%include/postgresql/server/utils/hsearch.h	489	%%SERVER%%include/postgresql/server/utils/hsearch.h
		490	%%SERVER%%include/postgresql/server/utils/help_config.h
434	%%SERVER%%include/postgresql/server/utils/inet.h	491	%%SERVER%%include/postgresql/server/utils/inet.h
435	%%SERVER%%include/postgresql/server/utils/int8.h	492	%%SERVER%%include/postgresql/server/utils/int8.h
436	%%SERVER%%include/postgresql/server/utils/inval.h	493	%%SERVER%%include/postgresql/server/utils/inval.h
Lines 454-468 Link Here
454	%%SERVER%%include/postgresql/server/utils/tqual.h	511	%%SERVER%%include/postgresql/server/utils/tqual.h
455	%%SERVER%%include/postgresql/server/utils/tuplesort.h	512	%%SERVER%%include/postgresql/server/utils/tuplesort.h
456	%%SERVER%%include/postgresql/server/utils/tuplestore.h	513	%%SERVER%%include/postgresql/server/utils/tuplestore.h
		514	%%SERVER%%include/postgresql/server/utils/typcache.h
457	%%SERVER%%include/postgresql/server/utils/varbit.h	515	%%SERVER%%include/postgresql/server/utils/varbit.h
458	%%SERVER%%include/postgresql/server/pg_config.h
459	%%SERVER%%include/postgresql/server/pg_config_os.h
460	%%SERVER%%include/postgresql/server/c.h	516	%%SERVER%%include/postgresql/server/c.h
461	%%SERVER%%include/postgresql/server/dynloader.h	517	%%SERVER%%include/postgresql/server/dynloader.h
462	%%SERVER%%include/postgresql/server/fmgr.h	518	%%SERVER%%include/postgresql/server/fmgr.h
463	%%SERVER%%include/postgresql/server/funcapi.h	519	%%SERVER%%include/postgresql/server/funcapi.h
		520	%%SERVER%%include/postgresql/server/getaddrinfo.h
		521	%%SERVER%%include/postgresql/server/getopt_long.h
464	%%SERVER%%include/postgresql/server/miscadmin.h	522	%%SERVER%%include/postgresql/server/miscadmin.h
		523	%%SERVER%%include/postgresql/server/pg_config.h
		524	%%SERVER%%include/postgresql/server/pg_config_manual.h
		525	%%SERVER%%include/postgresql/server/pg_config_os.h
465	%%SERVER%%include/postgresql/server/pgstat.h	526	%%SERVER%%include/postgresql/server/pgstat.h
		527	%%SERVER%%include/postgresql/server/port.h
466	%%SERVER%%include/postgresql/server/postgres.h	528	%%SERVER%%include/postgresql/server/postgres.h
467	%%SERVER%%include/postgresql/server/postgres_ext.h	529	%%SERVER%%include/postgresql/server/postgres_ext.h
468	%%SERVER%%include/postgresql/server/postgres_fe.h	530	%%SERVER%%include/postgresql/server/postgres_fe.h





PREFIX=%%PREFIX%%
PGBIN=${PREFIX}/bin
logfile=/var/log/pgsql

case $1 in
start)
    touch ${logfile}
    chmod 600 ${logfile}
    chown pgsql:pgsql ${logfile}
    [ -x ${PGBIN}/pg_ctl ] && {
	su -l pgsql -c \
	    "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w -l ${logfile}"
	echo -n ' pgsql'
	su -l pgsql -c \
	    "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w"
    }
    ;;

stop)
    [ -x ${PGBIN}/pg_ctl ] && {
	su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast"
	echo -n ' pgsql'
	su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast"
    }
    ;;

restart)
    [ -x ${PGBIN}/pg_ctl ] && {
	exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast"
    }
    ;;

reload)
    [ -x ${PGBIN}/pg_ctl ] && {
	exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl reload"
    }
    ;;


    ;;

*)
    echo "usage: `basename $0` {start|stop|restart|reload|status}" >&2
    exit 64
    ;;
esac

Lines 13-17 Link Here

(-)files/pkg-message.server (+4 lines)
13	/usr/local/etc/rc.d/010.pgsql.sh start	13	/usr/local/etc/rc.d/010.pgsql.sh start
14		14
15	For postmaster settings, see ~pgsql/data/postgresql.conf	15	For postmaster settings, see ~pgsql/data/postgresql.conf
		16
		17	NB. FreeBSD's PostgreSQL port now by default logs to syslog
		18	See ~pgsql/data/postgresql.conf for more info
		19
16	For more tips, read ~pgsql/post-install-notes	20	For more tips, read ~pgsql/post-install-notes
17	======================================================================	21	======================================================================




--- src/backend/utils/misc/postgresql.conf.sample~	Wed Oct  8 05:49:38 2003
+++ src/backend/utils/misc/postgresql.conf.sample	Tue Nov 18 05:08:08 2003
@@ -136,9 +136,9 @@
 
 # - Syslog -
 
-#syslog = 0			# range 0-2; 0=stdout; 1=both; 2=syslog
-#syslog_facility = 'LOCAL0'
-#syslog_ident = 'postgres'
+syslog = 2			# range 0-2; 0=stdout; 1=both; 2=syslog
+syslog_facility = 'LOCAL0'
+syslog_ident = 'postgres'
 
 # - When to Log -
 
@@ -162,7 +162,7 @@
 				 # milliseconds.  Zero prints all queries.
 				 # Minus-one disables.
 
-#silent_mode = false		 # DO NOT USE without Syslog!
+silent_mode = true		 # DO NOT USE without Syslog!
 
 # - What to Log -
 

Return to bug 59402

Lines 9-38 Link Here

(-)files/pgsql.sh.tmpl (-9 / +11 lines)
9		9
10	PREFIX=%%PREFIX%%	10	PREFIX=%%PREFIX%%
11	PGBIN=${PREFIX}/bin	11	PGBIN=${PREFIX}/bin
12	logfile=/var/log/pgsql
13		12
14	case $1 in	13	case $1 in
15	start)	14	start)
16	touch ${logfile}
17	chmod 600 ${logfile}
18	chown pgsql:pgsql ${logfile}
19	[ -x ${PGBIN}/pg_ctl ] && {	15	[ -x ${PGBIN}/pg_ctl ] && {
20	su -l pgsql -c \
21	"[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w -l ${logfile}"
22	echo -n ' pgsql'	16	echo -n ' pgsql'
		17	su -l pgsql -c \
		18	"[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w"
23	}	19	}
24	;;	20	;;
25		21
26	stop)	22	stop)
27	[ -x ${PGBIN}/pg_ctl ] && {	23	[ -x ${PGBIN}/pg_ctl ] && {
28	su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast"
29	echo -n ' pgsql'	24	echo -n ' pgsql'
		25	su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast"
30	}	26	}
31	;;	27	;;
32		28
33	restart)	29	restart)
34	[ -x ${PGBIN}/pg_ctl ] && {	30	[ -x ${PGBIN}/pg_ctl ] && {
35	exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast -l ${logfile}"	31	exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast"
		32	}
		33	;;
		34
		35	reload)
		36	[ -x ${PGBIN}/pg_ctl ] && {
		37	exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl reload"
36	}	38	}
37	;;	39	;;
38		40
Lines 43-49 Link Here
43	;;	45	;;
44		46
45	*)	47	*)
46	echo "usage: `basename $0` {start\|stop\|restart\|status}" >&2	48	echo "usage: `basename $0` {start\|stop\|restart\|reload\|status}" >&2
47	exit 64	49	exit 64
48	;;	50	;;
49	esac	51	esac

Added Link Here

(-)files/patch-src:backend:utils:misc:postgresql.conf.sample (+24 lines)
1	--- src/backend/utils/misc/postgresql.conf.sample~ Wed Oct 8 05:49:38 2003
2	+++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 18 05:08:08 2003
3	@@ -136,9 +136,9 @@
4
5	# - Syslog -
6
7	-#syslog = 0 # range 0-2; 0=stdout; 1=both; 2=syslog
8	-#syslog_facility = 'LOCAL0'
9	-#syslog_ident = 'postgres'
10	+syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog
11	+syslog_facility = 'LOCAL0'
12	+syslog_ident = 'postgres'
13
14	# - When to Log -
15
16	@@ -162,7 +162,7 @@
17	# milliseconds. Zero prints all queries.
18	# Minus-one disables.
19
20	-#silent_mode = false # DO NOT USE without Syslog!
21	+silent_mode = true # DO NOT USE without Syslog!
22
23	# - What to Log -
24