Re: Mac version can't dump/restore

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: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of John DeSoi
> Sent: 16 March 2006 14:29
> To: pgadmin-support(at)postgresql(dot)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
>