Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C1D739FB6F4 for ; Thu, 19 Jul 2007 05:50:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12131-04 for ; Thu, 19 Jul 2007 05:50:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by postgresql.org (Postfix) with ESMTP id 033689FB614 for ; Thu, 19 Jul 2007 05:50:24 -0300 (ADT) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.13.6/8.13.6) with ESMTP id l6J8oLKg071787 for ; Thu, 19 Jul 2007 11:50:21 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.13.6/8.13.6/Submit) id l6J8oKbI071786 for pgsql-admin@postgresql.org; Thu, 19 Jul 2007 11:50:20 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: How to check running database is 32 bit Date: Thu, 19 Jul 2007 11:50:20 +0300 User-Agent: KMail/1.9.3 References: <713822.93775.qm@web60513.mail.yahoo.com> In-Reply-To: <713822.93775.qm@web60513.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200707191150.20463.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/214 X-Sequence-Number: 26195 =D3=F4=E9=F2 =D0=DD=EC=F0=F4=E7 19 =C9=EF=FD=EB=E9=EF=F2 2007 11:27, =EF/= =E7 nilesh khode =DD=E3=F1=E1=F8=E5: > Hello, > > I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 > Bit). > > I already had running Postgresql 64 bit under /var/lib/pgsql. I installed > 32 bit 2nd Postgresql using Tarball under /usr/local/pgsql. I want to cro= ss > check whether it is 32 bit or 64 bit. So how shld I check the same? In SELECT version(); it should say smth about the architecture. If this does not help, write a C function that checks the sizeof(void *), a= nd=20 compile it in both systems (64,32), and then install it on both postgresql'= s. Then at calling time, check its value, if its 4 then it is on a 32 bit syst= em, if it is 8 then it is on a 64 bit system. > > Thanks, > Nilesh > > > > > > > > _________________________________________________________________________= __ >_________ Get the free Yahoo! toolbar and rest assured with the added > security of spyware protection. > http://new.toolbar.yahoo.com/toolbar/features/norton/index.php > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend =2D-=20 Achilleas Mantzios