X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 64B3453DF5; Fri, 22 Apr 2005 04:46:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41421-10; Fri, 22 Apr 2005 07:46:46 +0000 (GMT) Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 525EC5337D; Fri, 22 Apr 2005 04:46:44 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000695307.msg; Fri, 22 Apr 2005 00:47:03 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" , Subject: FW: How to install Postgres that supports 64-bit integer/date-time. Date: Fri, 22 Apr 2005 13:13:46 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004B_01C5473D.1FCF3EA0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVG/FU7TisXNYg7SBS1zmCBFn+D2gAEk5/g X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 22 Apr 2005 00:47:03 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDAV-Processed: mail.secf.com, Fri, 22 Apr 2005 00:47:06 -0700 Message-Id: <20050422074644.525EC5337D@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.363 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200504/960 X-Sequence-Number: 76873 This is a multi-part message in MIME format. ------=_NextPart_000_004B_01C5473D.1FCF3EA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 <> 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 ------=_NextPart_000_004B_01C5473D.1FCF3EA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Continued= …..

&nbs= p;

I solved = this problem by myself.

 <= /p>

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.

        &nbs= p; Insert Solaris software CD 1/2.

 

Log in as = root.

        &nbs= p;

pkgadd -d = /cdrom/Solaris_9/Product <<package name>>

 

eject = cdrom

 

 

C.     Check Solaris OS mode and supported = bits

isainfo -v   = 

       &nbs=
p;   64-bit sparcv9 =
applications
           =
32-bit sparc applications
 

D.     To compile a 64-bit application on an UltraSparc with = a recent Sun Compiler.

       &nbs=
p;   getconf -a | grep v9
 
       &nbs=
p;   =
XBS5_LP64_OFF64_CFLAGS:        &n=
bsp;       =
-xarch=3Dv9
           =
XBS5_LP64_OFF64_LDFLAGS:        &=
nbsp;      =
-xarch=3Dv9
           =
….
           =
….
 

E.     The transitional compilation environment is obtained = with the following compiler and linker = flags:

       &nbs=
p;   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.)

       &nbs=
p;   getconf LFS_CFLAGS      =
-D_LARGEFILE_SOURCE =
-D_FILE_OFFSET_BITS=3D64
 

G.     Re-Configure the Postgres with 64-bit integer = date/time support  from its source:

       &nbs=
p;   bash-2.03# cd postgres =
8.0.1/
           =
bash-2.03# ./configure =
--enable-integer-datetimes --prefix=3D/usr/local/pgsql --with-perl =
--with-tclconfig=3D/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.<= /p>

 

How to install Postgres 8.0.1 that supports 64-bit = integer/date-time.

 

# ./configure --prefix=3D/usr/local/pgsql = --with-tclconfig=3D/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

 

------=_NextPart_000_004B_01C5473D.1FCF3EA0--