mac install question

On Wed, Jul 23, 2008 at 1:58 PM, epicwinter@hotmail.com
<epicwinter@hotmail.com> wrote:

Please excuse my lack of mac knowledge. I installed postgresql 8.3 using the mac os x 1 click installer onto my brand new powerbook. The install appeared to go very smooth. If I go to Postgresql under Applications it appears as if I can start and stop postgres and open pgadmin. I even created a test database under pgadmin with no errors. So everything appears cool but...

I can't seem to run any of the postgresql commands from a shell. If I open a terminal and try to run psql or createdb or any of the commands I get this error:

/Library/PostgreSQL/8.3/bin/createdb test
dyld: Library not loaded: /Users/buildfarm/pginstaller/server/staging/osx/lib/libpq.5.dylib

That would seem to indicate that the installer doesn't set things up
properly for command-line access. You should talk to whoever created
it, since it isn't (to my knowledge) part of the official Postgres
distribution.

-Doug

Date: Wed, 23 Jul 2008 14:12:45 -0400
From: doug@mcnaught.org
To: epicwinter@hotmail.com
Subject: Re: [GENERAL] mac install question
CC: pgsql-general@postgresql.org

On Wed, Jul 23, 2008 at 1:58 PM, epicwinter@hotmail.com
<epicwinter@hotmail.com> wrote:

Please excuse my lack of mac knowledge. I installed postgresql 8.3 using the mac os x 1 click installer onto my brand new powerbook. The install appeared to go very smooth. If I go to Postgresql under Applications it appears as if I can start and stop postgres and open pgadmin. I even created a test database under pgadmin with no errors. So everything appears cool but...

I can't seem to run any of the postgresql commands from a shell. If I open a terminal and try to run psql or createdb or any of the commands I get this error:

/Library/PostgreSQL/8.3/bin/createdb test
dyld: Library not loaded: /Users/buildfarm/pginstaller/server/staging/osx/lib/libpq.5.dylib

That would seem to indicate that the installer doesn't set things up
properly for command-line access. You should talk to whoever created
it, since it isn't (to my knowledge) part of the official Postgres
distribution.

-Doug

Well I got it from a link on postgresql.org. Of course it does say that it is a beta installer.

http://www.postgresql.org/download/macosx

_________________________________________________________________
Keep your kids safer online with Windows Live Family Safety.
http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_safety_072008

On Wed, Jul 23, 2008 at 2:19 PM, epicwinter@hotmail.com
<epicwinter@hotmail.com> wrote:

Well I got it from a link on postgresql.org. Of course it does say that it
is a beta installer.
http://www.postgresql.org/download/macosx

Well, hopefully the maintainer reads this mailing list then. :)

-Doug

He does, though he's currently on vacation, being forced to top-post
in the gmail mobile interface :-p

Can the OP send me (privately) the bitrock_installer log from /tmp please?
Thanks, Dave

On 7/23/08, Douglas McNaught <doug@mcnaught.org> wrote:

On Wed, Jul 23, 2008 at 2:19 PM, epicwinter@hotmail.com
<epicwinter@hotmail.com> wrote:

Well I got it from a link on postgresql.org. Of course it does say that
it
is a beta installer.
http://www.postgresql.org/download/macosx

Well, hopefully the maintainer reads this mailing list then. :)

-Doug

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On Jul 23, 2008, at 2:19 PM, epicwinter@hotmail.com wrote:

Date: Wed, 23 Jul 2008 14:12:45 -0400
From: doug@mcnaught.org
To: epicwinter@hotmail.com
Subject: Re: [GENERAL] mac install question
CC: pgsql-general@postgresql.org

On Wed, Jul 23, 2008 at 1:58 PM, epicwinter@hotmail.com
<epicwinter@hotmail.com> wrote:

Please excuse my lack of mac knowledge. I installed postgresql

8.3 using the mac os x 1 click installer onto my brand new
powerbook. The install appeared to go very smooth. If I go to
Postgresql under Applications it appears as if I can start and stop
postgres and open pgadmin. I even created a test database under
pgadmin with no errors. So everything appears cool but...

I can't seem to run any of the postgresql commands from a shell.

If I open a terminal and try to run psql or createdb or any of the
commands I get this error:

/Library/PostgreSQL/8.3/bin/createdb test
dyld: Library not loaded: /Users/buildfarm/pginstaller/server/

staging/osx/lib/libpq.5.dylib

That would seem to indicate that the installer doesn't set things up
properly for command-line access. You should talk to whoever created
it, since it isn't (to my knowledge) part of the official Postgres
distribution.

-Doug

Well I got it from a link on postgresql.org. Of course it does say
that it is a beta installer.
http://www.postgresql.org/download/macosx

The package is improperly linked so the command-line tools are useless
on any machine other than the buildfarm setup. Dave Page (CC'd) is
apparently the maintainer.

Cheers,
M

Thanks for the log. It shows that the otool utility couldn't be found
(which should be a fatal error but that's another issue.

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

In any case, re-running the installer, with otool in the standard
location should fixup the installation.

On 7/23/08, epicwinter@hotmail.com <epicwinter@hotmail.com> wrote:

Here is the log. Is there a better way to install postgres that you would
recommend?
----------------------------------------

Date: Wed, 23 Jul 2008 20:01:07 +0100
From: dpage@pgadmin.org
To: doug@mcnaught.org
Subject: Re: [GENERAL] mac install question
CC: epicwinter@hotmail.com; pgsql-general@postgresql.org

He does, though he's currently on vacation, being forced to top-post
in the gmail mobile interface :-p

Can the OP send me (privately) the bitrock_installer log from /tmp please?
Thanks, Dave

On 7/23/08, Douglas McNaught wrote:

On Wed, Jul 23, 2008 at 2:19 PM, epicwinter@hotmail.com
wrote:

Well I got it from a link on postgresql.org. Of course it does say that
it
is a beta installer.
http://www.postgresql.org/download/macosx

Well, hopefully the maintainer reads this mailing list then. :)

-Doug

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
With Windows Live for mobile, your contacts travel with you.
http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_mobile_072008

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

it's a command line utility.

On 7/23/08, epicwinter@hotmail.com <epicwinter@hotmail.com> wrote:

Frankly i have no idea what otool is?

Date: Wed, 23 Jul 2008 20:45:23 +0100
From: dpage@pgadmin.org
To: epicwinter@hotmail.com
Subject: Re: [GENERAL] mac install question
CC: pgsql-general@postgresql.org

Thanks for the log. It shows that the otool utility couldn't be found
(which should be a fatal error but that's another issue.

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

In any case, re-running the installer, with otool in the standard
location should fixup the installation.

On 7/23/08, epicwinter@hotmail.com <epicwinter@hotmail.com> wrote:

Here is the log. Is there a better way to install postgres that you
would
recommend?
----------------------------------------

Date: Wed, 23 Jul 2008 20:01:07 +0100
From: dpage@pgadmin.org
To: doug@mcnaught.org
Subject: Re: [GENERAL] mac install question
CC: epicwinter@hotmail.com; pgsql-general@postgresql.org

He does, though he's currently on vacation, being forced to top-post
in the gmail mobile interface :-p

Can the OP send me (privately) the bitrock_installer log from /tmp
please?
Thanks, Dave

On 7/23/08, Douglas McNaught wrote:

On Wed, Jul 23, 2008 at 2:19 PM, epicwinter@hotmail.com
wrote:

Well I got it from a link on postgresql.org. Of course it does say
that
it
is a beta installer.
http://www.postgresql.org/download/macosx

Well, hopefully the maintainer reads this mailing list then. :)

-Doug

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
With Windows Live for mobile, your contacts travel with you.
http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_mobile_072008

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

_________________________________________________________________
Stay in touch when you're away with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_messenger2_072008

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

that'll make it work, but doesn't fix the problem. :-(
On 7/23/08, epicwinter@hotmail.com <epicwinter@hotmail.com> wrote:

Well scott's suggestion seemed to work:

Ryan,

Try setting:

export DYLD_LIBRARY_PATH=/Library/PostgreSQL/8.3/lib:$DYLD_LIBRARY_PATH

and running the command again.

--

Scott Mead

Sr. Systems Engineer

EnterpriseDB

Date: Wed, 23 Jul 2008 20:50:13 +0100
From: dpage@pgadmin.org
To: epicwinter@hotmail.com
Subject: Re: [GENERAL] mac install question
CC: pgsql-general@postgresql.org

it's a command line utility.

On 7/23/08, epicwinter@hotmail.com <epicwinter@hotmail.com> wrote:

Frankly i have no idea what otool is?

Date: Wed, 23 Jul 2008 20:45:23 +0100
From: dpage@pgadmin.org
To: epicwinter@hotmail.com
Subject: Re: [GENERAL] mac install question
CC: pgsql-general@postgresql.org

Thanks for the log. It shows that the otool utility couldn't be found
(which should be a fatal error but that's another issue.

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

In any case, re-running the installer, with otool in the standard
location should fixup the installation.

On 7/23/08, epicwinter@hotmail.com <epicwinter@hotmail.com> wrote:

Here is the log. Is there a better way to install postgres that you
would
recommend?
----------------------------------------

Date: Wed, 23 Jul 2008 20:01:07 +0100
From: dpage@pgadmin.org
To: doug@mcnaught.org
Subject: Re: [GENERAL] mac install question
CC: epicwinter@hotmail.com; pgsql-general@postgresql.org

He does, though he's currently on vacation, being forced to top-post
in the gmail mobile interface :-p

Can the OP send me (privately) the bitrock_installer log from /tmp
please?
Thanks, Dave

On 7/23/08, Douglas McNaught wrote:

On Wed, Jul 23, 2008 at 2:19 PM, epicwinter@hotmail.com
wrote:

Well I got it from a link on postgresql.org. Of course it does
say
that
it
is a beta installer.
http://www.postgresql.org/download/macosx

Well, hopefully the maintainer reads this mailing list then. :)

-Doug

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
With Windows Live for mobile, your contacts travel with you.
http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_mobile_072008

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

_________________________________________________________________
Stay in touch when you're away with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_messenger2_072008

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

_________________________________________________________________
Keep your kids safer online with Windows Live Family Safety.
http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_safety_072008

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

dpage@pgadmin.org writes:

Thanks for the log. It shows that the otool utility couldn't be found
(which should be a fatal error but that's another issue.

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

Looks like you lose. I'm not sure where to look for definitive package
contents on Macs, but the file timestamp on /usr/bin/otool shows it was
built at the same time as ar, as, gcc, gprof, size, RezWack, and a bunch
of other /usr/bin programs that look like they'd only come as part of
xcode not in the base install.

What are you using it for that you need it to be present at install
time?

regards, tom lane

On 23 Jul 2008, at 21:47, Tom Lane <tgl@sss.pgh.pa.us> wrote:

dpage@pgadmin.org writes:

Thanks for the log. It shows that the otool utility couldn't be found
(which should be a fatal error but that's another issue.

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

Looks like you lose. I'm not sure where to look for definitive
package
contents on Macs, but the file timestamp on /usr/bin/otool shows it
was
built at the same time as ar, as, gcc, gprof, size, RezWack, and a
bunch
of other /usr/bin programs that look like they'd only come as part of
xcode not in the base install.

What are you using it for that you need it to be present at install
time?

The linker hardcodes library paths into exes and libs. We examine
these paths at install time using otool and rewrite them from the
staging paths on the build machine to whatever directory the user
chose to install to using install_name_tool(1).

The other option would be to rewrite the paths to be relative at build
time I guess.

/D

Dave Page wrote:

The linker hardcodes library paths into exes and libs. We examine these
paths at install time using otool and rewrite them from the staging
paths on the build machine to whatever directory the user chose to
install to using install_name_tool(1).

Yep, the mac linker seems to default to absolute rpath linking, which I
personally find *really* frustrating.

The other option would be to rewrite the paths to be relative at build
time I guess.

That's the approach most Mac apps take, and is supported by the @
relative path syntax in install_name_tool.

--
Craig Ringer

dpage@pgadmin.org wrote:

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

I have a few installs here.

otool is included inside /Developer/usr/bin
my working 10.4 that the dev tools is installed on also includes otool
at /usr/bin

A minimal 10.3 install has otool at /usr/bin

A clean 10.5 install does not have otool

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

Dave Page <dpage@pgadmin.org> writes:

What are you using it for that you need it to be present at install
time?

The linker hardcodes library paths into exes and libs. We examine
these paths at install time using otool and rewrite them from the
staging paths on the build machine to whatever directory the user
chose to install to using install_name_tool(1).

The other option would be to rewrite the paths to be relative at build
time I guess.

Relative paths sound like the best solution to me, assuming they work.

regards, tom lane

On Jul 24, 2008, at 1:51 AM, Tom Lane wrote:

Relative paths sound like the best solution to me, assuming they work.

Relative paths work fine. I use this all the time for distributing
psql. It looks something like this:

install_name_tool -change /path/to/postgresql/lib/libpq.dylib
@executable_path/../lib/libpq.dylib psql

John DeSoi, Ph.D.

Shane Ambler wrote:

dpage@pgadmin.org wrote:

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

I have a few installs here.

now that I think about it - it may be a dev tools only thing.

otool is included inside /Developer/usr/bin
my working 10.4 that the dev tools is installed on also includes otool
at /usr/bin

This has been running for a few years so otool at /usr/bin may have come
from anywhere.

A minimal 10.3 install has otool at /usr/bin

I have two 10.3 systems here the one that has otool is an emergency boot
setup by TechTool Pro. A normal 10.3 install does not have otool.

A clean 10.5 install does not have otool

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

On Thu, Jul 24, 2008 at 12:55 PM, John DeSoi <desoi@pgedit.com> wrote:

On Jul 24, 2008, at 1:51 AM, Tom Lane wrote:

Relative paths sound like the best solution to me, assuming they work.

Relative paths work fine. I use this all the time for distributing psql. It
looks something like this:

install_name_tool -change /path/to/postgresql/lib/libpq.dylib
@executable_path/../lib/libpq.dylib psql

Yeah, we do that in pgAdmin. In the installer though we have far more
executables and libraries in various locations, and scripting the
required changes (without hardcoding for specific filenames which is a
recipe for future bugs) will be much more tricky.

The other downside is that I won't be able to set the library install
name correctly of course. I'll have to change that to just the
filename.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On Thu, Jul 24, 2008 at 3:57 PM, Shane Ambler <pgsql@sheeky.biz> wrote:

Shane Ambler wrote:

dpage@pgadmin.org wrote:

Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)

I have a few installs here.

now that I think about it - it may be a dev tools only thing.

Yeah, was afraid of that. Thanks for checking.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

On Thu, Jul 24, 2008 at 6:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Dave Page <dpage@pgadmin.org> writes:

What are you using it for that you need it to be present at install
time?

The linker hardcodes library paths into exes and libs. We examine
these paths at install time using otool and rewrite them from the
staging paths on the build machine to whatever directory the user
chose to install to using install_name_tool(1).

The other option would be to rewrite the paths to be relative at build
time I guess.

Relative paths sound like the best solution to me, assuming they work.

For info, the latest version of the installer (download from
http://www.enterprisedb.com/products/pgdownload.do) fixes this
problem.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com