Zoltan Boszormenyi <zb(at)cybertec(dot)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