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

Zoltan Boszormenyi <zb@cybertec.at> writes:
> Keaton Adams �rta:
>> 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?

> select version();
> It will tell you the compiler version and arch as well. You can deduce
> from there.

Or, if that doesn't seem very helpful, file(1) applied to the postgres
executable will tell you if it's a 32-bit or 64-bit executable.

            regards, tom lane