Re: How to tell if 64 bit vs 32 bit engine?

From: Zoltan Boszormenyi <zb(at)cybertec(dot)at>
To: Keaton Adams <kadams(at)mxlogic(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to tell if 64 bit vs 32 bit engine?
Date: 2008-04-18 16:20:53
Message-ID: 4808CA65.2060105@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Keaton Adams írta:
> I did search the archives for this.... But didn’t see a posting that
> directly answered the question.
>
> How do I tell if the 32 bit version of PostgreSQL is running on a 64
> bit machine, or if the 64 bit version was installed? Is there a pg_
> table that I can query or a config file I can look in to find out? I
> found nothing in postgresql.conf that would indicate this.
>
> Thanks,
>
> Keaton
>

select version();

It will tell you the compiler version and arch as well. You can deduce
from there.

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-18 17:10:17 Re: How to tell if 64 bit vs 32 bit engine?
Previous Message BRUSSER Michael 2008-04-18 16:18:07 Re: How to tell if 64 bit vs 32 bit engine?