From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
---|---|
To: | Matthias Dietrich <rainboxx(at)googlemail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore |
Date: | 2010-01-04 22:02:13 |
Message-ID: | 4B426565.40207@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bergbom Staffan | 2010-01-04 22:14:24 | Question on how to conditionally commit or rollback a sql-request |
Previous Message | Erik Jones | 2010-01-04 21:59:52 | Re: Innotop for postgresl |