Hi Marc,
sorry about double posting. I though others may like to be aware of a gotcha
for unwary players - like me.
As I mentioned - no problems at all compiling 6.5.
Moved the original local/pgsql directory out of the way and installed the
new.
I came in this afternoon and did the following:
cd pgsql
chown -R *
bin/ipcclean
postmaster -i ( whoopeee, it started... no error messages)
as it is now running in command line mode, ie, not in the background, log in
as postgres on another terminal and
psql -e template1 < db.out
yahoooo, it did it.. :-)
quit
back to other terminal and ^c to stop the postmaster running
back to rc.d and start pgsql.sh as the root user - the .sh script switches
to postgres and runs the postmaster.
starts no worries
back to the PC, open the bookshp - search for a book - and FAST - wow.
Leaves 6.4 for dead.
looking good for launch...
Thanks for the pointers folks -
much appreciated.
Bob
>
> Hi Robert...
>
> I did all my testing on FreeBSD 4.0, without any
> problems...regression tests were "as expected" and everything...haven't
> tried my 3.2-STABLE machine yet though, that is *after* my holidays...
>
> There have been several changes to the shared memory aspects of
> the code...if I remember correctly, the default has been lowered to 32
> segments (vs 64?)...but it pre-allocates on start up. If there aren't
> enough segments, it will die...
>
> Check ipcs...anything left laying around as 'used'?
>
> On Wed, 16 Jun 1999, Robert Chalmers wrote:
>
> > Hi,
> > been running 6.4 for ages now, and looking to upgrade...
> >
> > I just made 6.5 on a FreeBSD 2.2 box, and everything seems to do fine.
> >
> > made it while 'root'
> > Installed it while user 'root', into '/usr/loocal/pgsql', having moved
pgsql
> > to pgsql-6.4.
> >
> > switch to user 'postgres' and do 'initdb' - seems fine. creates
everything
> >
> > do the '$postmaster -i' and it fails ??? First up it was telling me that
> > there was no "postgresql" database. Now it just gives an error to do
with
> > shemget and dies anyway...
> >
> > Everything compiles fine. It installs fine. initdb works fine. But - -
it
> > wont start.
> >
> > does anyone have any clues...
> >
> > thanks
> > Bob
> >
> >
> > --- http://4qir.quantum-radio.net.au - Where Only The Dedicated
Survive!
> > 4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some
of
> > the
> > original DJ's - back on air - and supporting not only the original Vets,
in
> > comprehensive AFVN Archives, but putting together segments for the
fighting
> > men and
> > women of todays services all around the world. World Music, for people
of
> > the world.
> >
> >
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick:
Scrappy
> Systems Administrator @ hub.org
> primary: [EMAIL PROTECTED] secondary:
scrappy@{freebsd|postgresql}.org
>
>
