From: Dinesh Pandey <dpandey@secf.com>
To: 'PostgreSQL' <pgsql-sql@postgresql.org>
To: pgsql-general@postgresql.org
Subject: FW: How to install Postgres that supports 64-bit integer/date-time.
Date: Fri, 22 Apr 2005 13:13:46 +0530
Message-ID: <20050422074644.525EC5337D@svr1.postgresql.org> (raw)
Continued...
I solved this problem by myself.
A. For 64 bit development you need these packages installed on Solaris
server:
SUNWarcx, SUNWbtoox, SUNWdplx, SUNWscpux, SUNWsprox,
SUNWtoox, SUNWlmsx, SUNWlmx, SUNWlibCx
Pls confirm these using the following command.
pkginfo SUNWarcx
pkginfo SUNWbtoox
pkginfo SUNWdplx
pkginfo SUNWscpux
pkginfo SUNWsprox,
pkginfo SUNWtoox
pkginfo SUNWlmsx
pkginfo SUNWlmx
pkginfo SUNWlibCx
B. Install missing Solaris packages.
Insert Solaris software CD 1/2.
Log in as root.
pkgadd -d /cdrom/Solaris_9/Product <<package name>>
eject cdrom
C. Check Solaris OS mode and supported bits
isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
D. To compile a 64-bit application on an UltraSparc with a recent Sun
Compiler.
getconf -a | grep v9
XBS5_LP64_OFF64_CFLAGS: -xarch=v9
XBS5_LP64_OFF64_LDFLAGS: -xarch=v9
..
..
E. The transitional compilation environment is obtained with the
following compiler and linker flags:
getconf LFS64_CFLAGS -D_LARGEFILE64_SOURCE
F. The large file compilation environment is obtained with (A 64-bit
application automatically has large file support built in by default.)
getconf LFS_CFLAGS -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64
G. Re-Configure the Postgres with 64-bit integer date/time support from
its source:
bash-2.03# cd postgres 8.0.1/
bash-2.03# ./configure --enable-integer-datetimes
--prefix=/usr/local/pgsql --with-perl --with-tclconfig=/usr/local/lib
--with-tcl
checking build system type... sparc-sun-solaris2.8
checking host system type... sparc-sun-solaris2.8
checking which template to use... solaris
checking whether to build with 64-bit integer date/time
support... yes
checking whether NLS is wanted... no
checking for default port number... 5432
..
..
bash-2.03# make install
Kindly let me know if you need any further clarification or any problem
occurs.
Thanks
Dinesh Pandey
_____
From: Dinesh Pandey [mailto:dpandey@secf.com]
Sent: Friday, April 22, 2005 11:00 AM
To: 'PostgreSQL'; 'pgsql-general@postgresql.org'
Subject: How to install Postgres that supports 64-bit integer/date-time.
How to install Postgres 8.0.1 that supports 64-bit integer/date-time.
# ./configure --prefix=/usr/local/pgsql --with-tclconfig=/usr/local/lib
--with-tcl
checking build system type... sparc-sun-solaris2.8
checking host system type... sparc-sun-solaris2.8
checking which template to use... solaris
checking whether to build with 64-bit integer date/time support... no
checking whether NLS is wanted... no
checking for default port number... 5432
checking for gcc... gcc
while installation I am getting this message:" checking whether to build
with 64-bit integer date/time support... no"
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dpandey@secf.com, pgsql-general@postgresql.org
Subject: Re: FW: How to install Postgres that supports 64-bit integer/date-time.
In-Reply-To: <20050422074644.525EC5337D@svr1.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox