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
> 

Tue, 16 Nov 1999 23:13:14 -0600
"Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
Re: PostgreSQL install
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


Wed, 17 Nov 1999 00:27:03 -0500
Christopher Petrilli <petrilli@digicool.com>
Re: PostgreSQL install
"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

Wed, 17 Nov 1999 00:39:56 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Re: PostgreSQL install 