Matthias Dietrich wrote:
How can I dump the data from the 32bit database? Does someone has built a postgres binary for this issue?
You can build one yourself following the "Reverting to 32-bit Binaries" instructions at
http://devoh.com/posts/2009/08/postgresql-snow-leopard (which follow up the build from source instructions at
http://devoh.com/posts/2008/10/installing-postgresql-on-mac-os-x-10.5-leopard )
You probably don't want to overwrite the system PostgreSQL just yet though. You can relocate where it compiles into with:
CFLAGS="-arch i386" ./configure --enable-thread-safety --with-bonjour --prefix=<install location>
Then run make/make install, point PGDATA toward your existing database, and start the server.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.com