Re: Postgres postmaster

On Tue, Mar 06, 2001 at 04:29:47PM -0800, some SMTP stream spewed forth:
> David Olbersen wrote this :
> >Well actually in this instance 'postmaster' refers to 1/2 of the database
> >backend. It's a program (typically installed in /usr/local/pgsql/bin ) that
> >handles input.
> >
> >You really should RTFM.
> You really should Read The F*^&*^ Question.

Heh. Does anybody else still feel like helping?
I would hate to step on some sore toes, I mean, sheesh... ;-)

> >
> >-- Dave
> ------------------------------------------------------------------
> [root@hoss workshop]# cd /usr/local/pgsql/bin
> bash: /usr/local/pgsql/bin: No such file or directory
> [root@hoss workshop]# cd /usr/pgsql/bin
> bash: /usr/pgsql/bin: No such file or directory
> [root@hoss workshop]# find / -name pgsql -print
> find: /proc/6/fd: Permission denied
> [root@hoss workshop]#
> -------------------------------------------------------------------

This is the first of several problems.
Find out where your PostgreSQL installation resides.
If nothing else, try running (as root):
find / -name postmaster
which should find the 'postmaster' binary.
(Someone please speak up if you know of a better way of ascertaining
said location.)

*Snip a bunch of useless mess about novice mess. We are here to help
each other afterall. Why can we not be decent?*

> Central issue of my original post:
> -----------------------------------------------------------------
> Shouldn't these details have been taken care of by the rpm, and if not,

I do not know.
RPMs are not on my list of Good Things.

> what do I do to fix this?

1) Find the location of your PostgreSQL installation.
Usually, this is '/usr/local/pgsql' (at least, on FreeBSD).

2) Go to that directory and (as the PostgreSQL user on your system, which
could be 'pgsql' or whatever) run `initdb` as per the instructions
in the PostgreSQL documentation (found at www.postgresql.org). (If you
have trouble *after* reading
what documentation is available, *then* come to the list, because
up the nose of the Universe if you think I am about to copy the online
documentation to you in an e-mail. If, for some reason, the documentation
is unavailable to you, let me know, and we will work from there.)

3) See if the rpm installed a startup script (in /usr/local/etc/rc.d
under FreeBSD using the ports collection) in the standard rc location
for your operating system. If it did, then (as root) try starting
postmaster using the startup script in the customary way for your OS.

4) Obviously, try connecting to the database (using `psql` for example).

Write back with your results.


Live life and enjoy it!
_Zorba the Greek_, Nikos Kazantzakis

> You really should Read The F*^&*^ Question.

Say, do you always ask for help like this?
Is it usually effective?
I rather feel like kicking you in the head, but that would
not serve well for the Project, now, would it?


Besides, you would probably rather read the manual than deal with us old
bastards anyway.

dan