<!-- $PostgreSQL: pgsql/doc/src/sgml/installation.sgml,v 1.291 2007/08/20 08:53:12 petere Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/installation.sgml,v 1.292 2007/08/25 20:29:25 tgl Exp $ -->

<chapter id="installation">

<title><![%standalone-include[<productname>PostgreSQL</>]]>

</indexterm>

<listitem>

<para>

PostgreSQL includes its own time zone database, which it

requires for date and time operations. This time zone

database is in fact compatible with the time zone database

provided by many operating systems such as FreeBSD, Linux,

and Solaris, so it would be redundant to install it again.

When this option is used, the operating system supplied time

zone database in <replaceable>DIRECTORY</replaceable> is used

instead of the one included in the PostgreSQL source

distribution. <filename>/usr/share/zoneinfo/</filename> is a

<productname>PostgreSQL</> includes its own time zone database,

which it requires for date and time operations. This time zone

database is in fact compatible with the <quote>zic</> time zone

database provided by many operating systems such as FreeBSD,

Linux, and Solaris, so it would be redundant to install it again.

When this option is used, the system-supplied time zone database

in <replaceable>DIRECTORY</replaceable> is used instead of the one

included in the PostgreSQL source distribution.

<replaceable>DIRECTORY</replaceable> must be specified as an

absolute path. <filename>/usr/share/zoneinfo</filename> is a

likely directory on some operating systems. Note that the

installation routinedoes not detect mismatching or erroneous

timezone data.Youare advised to run the regression tests

to verify that the time zone data you have pointed to works

correctly.

installation routinewill not detect mismatching or erroneous time

zone data.If you use this option, youare advised to run the

regression teststo verify that the time zone data you have

pointed to workscorrectly with <productname>PostgreSQL</>.

</para>

<para>

This option is mainly aimed at binary package distributors

who know their target operating system well. The main

advantage of using this option is that the PostgreSQL package

won't need to be upgraded whenever any of the many local

daylight-saving time rules changes. Another completely

incidental advantage is that PostgreSQL can be

cross-compiled<indexterm><primary>cross

compilation</primary></indexterm> straightforwardly if the

time-zone database does not need to be built during the

daylight-saving time rules change. Another advantage is that

PostgreSQL can be cross-compiled<indexterm><primary>cross

compilation</primary></indexterm> more straightforwardly if the

time zone database files do not need to be built during the

installation.

</para>

</listitem>

POSIXRULES = US/Eastern

all: SUBSYS.o submake-libpgport zic

ifneq (,$(with_system_tzdata))

overrideCPPFLAGS += '-DSYSTEMTZDIR="$(with_system_tzdata)"'

all: SUBSYS.o

ifeq (,$(with_system_tzdata))

all: submake-libpgport zic

SUBSYS.o:$(OBJS)

$(LD)$(LDREL)$(LDOUT) SUBSYS.o$(OBJS)

ifeq (,$(with_system_tzdata))

zic:$(ZICOBJS)

$(CC)$(CFLAGS)$(ZICOBJS)$(LDFLAGS)$(LIBS) -o$@$(X)

install: all installdirs

ifeq (,$(with_system_tzdata))

./zic -d '$(DESTDIR)$(datadir)/timezone' -p '$(POSIXRULES)' $(TZDATAFILES)

ln -s '$(with_system_tzdata)' '$(DESTDIR)$(datadir)/timezone'

$(MAKE) -C tznames $@

installdirs:

uninstall:

ifeq (,$(with_system_tzdata))

rm -rf '$(DESTDIR)$(datadir)/timezone'

$(MAKE) -C tznames $@

cleandistcleanmaintainer-clean:

staticpg_tzgmt_timezone_data;

staticchartzdir[MAXPGPATH];

staticbooldone_tzdir= false;

staticboolscan_directory_ci(constchar*dirname,

constchar*fname,intfnamelen,

char*canonname,intcanonnamelen);

pg_TZDIR(void)

{

staticbooldone_tzdir= false;

staticchartzdir[MAXPGPATH];

if (done_tzdir)

returntzdir;

done_tzdir= true;

returntzdir;

returnSYSTEMTZDIR;

}