Thanks John - I'll look into this when I have my Mac to hand. Gotta say I'm slightly surprised to see you here offering advice, though of course you're more than welcome :-)
Regards. Dave. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John DeSoi > Sent: 16 March 2006 14:29 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Mac version can't dump/restore > > I get this error when trying to dump a database: > > /Applications/pgAdmin3.app/Contents/SharedSupport/helper/pg_dump -i - > h localhost -p 5432 -U user -F c -b -v -f "/temp/test" test > dyld: Library not loaded: /usr/local/pgsql/lib/libpq.4.dylib > Referenced from: > /Applications/pgAdmin3.app/Contents/SharedSupport/ > helper/pg_dump > Reason: image not found > > Process returned exit code -1. > > > The problem is the pg_dump utility hard codes the path of > libpq. This > is not very workable because not only can that be customized, some > one using pgAdmin might not have PostgreSQL installed at all on the > local machine. > > Here is how I setup pgEdit on the Mac which may be a good solution. > > 1. Put libpq.dylib in the same folder with pg_dump/pg_restore and > include it in the distribution. > 2. Use install_name_tool on each postgresql executable to have it > reference the library relative to the executable folder. Example: > > install_name_tool -change /usr/local/pgsql/lib/libpq.4.dylib > @executable_path/libpq.4.1.dylib pg_restore > > > Also, I noticed that the pgAdmin package has PkgInfo at the same > level as the Contents folder. I thought it should be in the Contents > folder. > > > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
