Home > mailing lists

Re: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore - Mailing list pgsql-general

From	Greg Smith
Subject	Re: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore
Date	January 4, 2010 21:03:02
Msg-id	4B426565.40207@2ndquadrant.com Whole thread Raw
In response to	Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore (Matthias Dietrich <rainboxx@googlemail.com>)
List	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@2ndQuadrant.com  www.2ndQuadrant.com

From: Matthias Dietrich
Date: 04 January 2010, 20:35:54
Subject: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore

From: Erik Jones
Date: 04 January 2010, 21:23:24
Subject: Re: Innotop for postgresl