Thread: Re: PostgreSQL install
Hey Hackers - I wouldn't normally forward an install problem from general to the hackers list, but Chris is the database guy at Digital Creations, the company behind Zope, the really cool web app. building tool, that Sybase recently endorsed as their offical web frontend. Any of you FreeBSD types recognize the problem? Ross On Tue, Nov 16, 1999 at 11:49:03PM -0500, Christopher Petrilli wrote: > On 11/16/99 11:35 PM, Ross J. Reedstrom at reedstrm@wallace.ece.rice.edu > wrote: > > > Chris - > > Did I see you post to postgresql-general, looking for help with an install > > on one of the BSDs? I seem to have had a snafu with my email clients, and > > lost a few emails today (Mutt doesn't lock files properly...) so I can't > > find the exact mail. If you haven't resolved the build/install problem, > > let me know: a number of the core developers run various BSD flavors > > (www.postgresql.org is FreeBSD, for example) so this should be easily > > resolvable, although I run linux, myself. > > Yeah, basically it looks like: > > ./configure > make > make install > instaldb I seem to remember from your other post that you did get this last command right: initdb However, it is critical that initdb be run as the postgres user, rather than as root. Other than that, I don't know. I'll forward your message to the hackers list. Ah, one last thought: how do you set up access to shared libraries on FreeBSD? the make install will have dropped several libs in /usr/local/pgsql/lib that the executables need access to. > > Dosn't create the PG_VERSION files, nor the pg_user tables correctly... I > tried it on 3 different FreeBSD3.3 machines each downloaded seperately... > bizarre. And as I recall, this is the pgsql-6.5.3 tar ball. > > Chris > -- > | Christopher Petrilli Python Powered Digital Creations, Inc. > | petrilli@digicool.com http://www.digicool.com >
On 11/17/99 12:13 AM, Ross J. Reedstrom at reedstrm@wallace.ece.rice.edu wrote: > Hey Hackers - > I wouldn't normally forward an install problem from general to the > hackers list, but Chris is the database guy at Digital Creations, the > company behind Zope, the really cool web app. building tool, that Sybase > recently endorsed as their offical web frontend. Any of you FreeBSD > types recognize the problem? Flattry flattery.... we're jus evaluating options for support in the future, no commitments, of course, but we've had some people ask, and so we feel the need to understand it better. I've only used Postgres (under Stonebraker) and Illustra. > On Tue, Nov 16, 1999 at 11:49:03PM -0500, Christopher Petrilli wrote: >> On 11/16/99 11:35 PM, Ross J. Reedstrom at reedstrm@wallace.ece.rice.edu >> wrote: >> >>> Chris - >>> Did I see you post to postgresql-general, looking for help with an install >>> on one of the BSDs? I seem to have had a snafu with my email clients, and >>> lost a few emails today (Mutt doesn't lock files properly...) so I can't >>> find the exact mail. If you haven't resolved the build/install problem, >>> let me know: a number of the core developers run various BSD flavors >>> (www.postgresql.org is FreeBSD, for example) so this should be easily >>> resolvable, although I run linux, myself. >> >> Yeah, basically it looks like: >> >> ./configure >> make >> make install >> instaldb > > I seem to remember from your other post that you did get this last command > right: initdb Yeah, that part was from memory :-) > However, it is critical that initdb be run as the postgres user, rather > than as root. Other than that, I don't know. I'll forward your message > to the hackers list. Yup, run as uid 'postgres'. > Ah, one last thought: how do you set up access to shared libraries > on FreeBSD? the make install will have dropped several libs in > /usr/local/pgsql/lib that the executables need access to. I put LD_LIBRARY_PATH to be correct. This is in the startup for the user, so it should always be correct. >> >> Dosn't create the PG_VERSION files, nor the pg_user tables correctly... I >> tried it on 3 different FreeBSD3.3 machines each downloaded seperately... >> bizarre. > > And as I recall, this is the pgsql-6.5.3 tar ball. Yup, off the main FTP site... just ./configure and go with it... Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
"Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu> writes:
>> Yeah, basically it looks like:
>> ./configure
>> make
>> make install
>> instaldb
> I seem to remember from your other post that you did get this last command
> right: initdb
Two other thoughts: (1) is initdb in your path, and is the *right
version* the first one in your path (I've been burnt by that on
upgrades). (2) I think that initdb requires USER, PGLIB, PGDATA
env variables to be set properly for reliable operation; also PATH
had better find the new version of postgres, psql, etc before any
older versions.
If that doesn't strike gold, a copy of the failing initdb session's
printout would be useful.
regards, tom lane