I run PostgreSQL on an Ubuntu server. Through ArcCatalog 10.1 I can connect to the database (although it is empty right now). When trying to "Enable Geodatabase" I get the following error:
You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.
I've copied st_geometry.so from the ArcGIS install location on my Windows machine to the Ubuntu server. I placed the file in /usr/lib/postgresql/9.1/lib/, alongside a set of other .so files (including postgis.so). Still, I get the same error message. Is there something else I have to do in order to have the ST_GEOMETRY library "installed"? I don't even want to use that geometry type -- I want PostGIS in my database. An option to disable ST_GEOMETRY would be fabulous.
I haven't committed the PG documentation to memory, so I don't recall the command to report the EXT directory with which the 'configure' script was executed, but it's embedded in the postgres binaries. I run dual-boot, so I don't have access to my Linux install at the moment.
You can test the architecture of binaries with the 'file' command. Generally, if the package doesn't have "64" in it, it isn't 64-bit, but there are scores of naming conventions (which is precisely why I always build my own PG binaries from source).