From dpandey@secf.com Fri Apr 22 05:34:17 2005 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 ECA9553A44; Fri, 22 Apr 2005 02:34:17 -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 09436-02; Fri, 22 Apr 2005 05:34:13 +0000 (GMT) Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id F30D053A3A; Fri, 22 Apr 2005 02:34:11 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000694570.msg; Thu, 21 Apr 2005 22:33:28 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" , Subject: How to install Postgres that supports 64-bit integer/date-time. Date: Fri, 22 Apr 2005 11:00:02 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0030_01C5472A.7728AC80" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVG/FU7TisXNYg7SBS1zmCBFn+D2g== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Thu, 21 Apr 2005 22:33:28 -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, Thu, 21 Apr 2005 22:33:34 -0700 Message-Id: <20050422053411.F30D053A3A@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/954 X-Sequence-Number: 76867 This is a multi-part message in MIME format. ------=_NextPart_000_0030_01C5472A.7728AC80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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_0030_01C5472A.7728AC80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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”<= /font>

 

Thanks

 

------=_NextPart_000_0030_01C5472A.7728AC80-- From dpandey@secf.com Fri Apr 22 07:46:53 2005 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-- From smarlowe@g2switchworks.com Fri Apr 22 14:50:19 2005 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 1CAF353AB0; Fri, 22 Apr 2005 11:50:19 -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 56178-03; Fri, 22 Apr 2005 14:50:14 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 426F753988; Fri, 22 Apr 2005 11:50:12 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 22 Apr 2005 09:50:14 -0500 Subject: Re: [SQL] How to install Postgres that supports 64-bit From: Scott Marlowe To: dpandey@secf.com Cc: 'PostgreSQL' , pgsql-general@postgresql.org In-Reply-To: <20050422053411.F30D053A3A@svr1.postgresql.org> References: <20050422053411.F30D053A3A@svr1.postgresql.org> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1114181414.13303.48.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 22 Apr 2005 09:50:14 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/983 X-Sequence-Number: 76896 On Fri, 2005-04-22 at 00:30, Dinesh Pandey wrote: > How to install Postgres 8.0.1 that supports 64-bit integer/date-time. >=20 > =20 >=20 > # ./configure --prefix=3D/usr/local/pgsql > --with-tclconfig=3D/usr/local/lib --with-tcl=20 >=20 > checking build system type... sparc-sun-solaris2.8 >=20 > checking host system type... sparc-sun-solaris2.8 >=20 > checking which template to use... solaris >=20 > checking whether to build with 64-bit integer date/time support... no >=20 > checking whether NLS is wanted... no >=20 > checking for default port number... 5432 >=20 > checking for gcc... gcc >=20 > =20 >=20 > while installation I am getting this message:=E2=80=9D checking whether t= o > build with 64-bit integer date/time support... no=E2=80=9D >=20 --enable-integer-datetimes enable 64-bit integer date/time support