Zoltan Boszormenyi <zb@xxxxxxxxxxx> 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