Обсуждение: How to check running database is 32 bit
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 cross check whether it is 32 bit or 64 bit. So how shld I check the same? 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
Στις Πέμπτη 19 Ιούλιος 2007 11:27, ο/η nilesh khode έγραψε: > 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 cross > 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 *), and 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 system, 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 -- Achilleas Mantzios
Could I just suggest that you upgrade to 10.2? 10.1, especially the 64 bit version, is a bit rough in places. Steve. On Thu, 19 Jul 2007 01:27:26 -0700 (PDT) nilesh khode <nilesh_khode@yahoo.com> wrote: > 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 cross check whether it is 32 bit or 64 bit. So how shld I check the same? > > 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