Re: Still lockin up...

LinuxPPC 2000 Q4 Kernel 2.2.18hpmac, PGsql 6.5.3.

John Burski wrote:

> Which operating system and version of PostgreSQL are you using?
>
> Herb Pabst wrote:
>
> > Well, I'm happy to say that the Box was no locking up. PGsql was running in
> > the first terminal. One of you Guru's suggested that I open another terminal
> > and was able to su and start psql. Now for the learning! I need to find out
> > how to edit the rc files so PGsql starts on boot. Can someone point me to the
> > correct docs, I can't seem to find the info due to my newbee condition. :<)
> >
> > Herbie Pabst
> >
> > ps. When I use "top" to check memory usage I see that the cache has been
> > growing about 8mb per day then memory usage stops 2mb short of total physical
> > ram. Any Ideas?
> >
> > Rasputin wrote:
> >
> > > * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [010127 19:57]:
> > > > Herbie Pabst <herbie(at)nextearth(dot)com> writes:
> > > > > Thank you for replying. I now have gotten as far as doing "initdb" and
> > > > > have a template1 in "base" directory. Now when I run Postmaster it asks
> > > > > for a data path, I use "-D" option and supply the path and run
> > > > > postmaster but if locks up the computer and pgsql never starts.
> > >
> > > Show us the whole command line.
> > > > It's hardly likely that it "locks up the computer".
> > >
> > > To be fair, Tom , I've had similar problems on some platforms
> > > where the /etc/rc.d initscripts are b0rken, and the
> > > " su - pgsql " line has been messed up so that it execs into
> > > a postmaster shell.
> > >
> > > If this is the case, the system will hang on bootup, because init
> > > expects these scripts to return (whic hwon't happen unitl after
> > > postmaster exits).
> > >
> > > Herbie, if you are running postgres from the command line, stop it :)
> > > If not , tell us where you got it and what script you're running.
> > >
> > > > Are you typing
> > > > "postmaster" in a shell window and expecting the command to terminate?
> > > > It won't, nor will it automatically launch a psql for you. The
> > > > postmaster is just a daemon that you are supposed to start up as a
> > > > background process. See the admin guide, eg
> > > > http://www.postgresql.org/devel-corner/docs/postgres/postmaster-start.htm
> > > > (note that these docs are for 7.1, but they mostly apply to the 7.0
> > > > version that I suppose you are running).
> > > >
> > > > regards, tom lane
> > >
> > > --
> > > Rasputin
> > > Jack of All Trades :: Master of Nuns
>
> --
> John Burski
> Chief IT Cook and Bottlewasher
> 911 Emergency Products, St. Cloud, MN
> (320) 656 0076 www.911ep.com
>
> ++++++++++++++++++++++++++++++++++
> + How's your cheese holding out? +
> ++++++++++++++++++++++++++++++++++