Re: starting postgres on red hat

On Thu, Sep 11, 2008 at 10:57 AM, Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> wrote:
>
> I installed Red Hat 5.2 EL. During the install I select postgresql and this versoin was installed: postgresql-8.1.11-1.el5_1.1.
>
> 1. I started postgresql as follows:
> initdb -D /var/lib/pgsql/data

There's an initidb function built into the /etc/init.d/postgresql
script you can use:

sudo /etc/init.d/postgresql initdb

both work similarly.

> 2. I started the database server as follows:
> /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
>
> 3. I started the postmaster as follows:
> service postgresql start

These two steps do the same thing. the db server was already started
in step2. The preferred way is how you did it in step 3.

> When I check that it is all running with ps command I get:
> 324 pts/1 S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
>
> When I did the same setps in fedora 8 the postmaster was started on a port
> 1703 ? S 0:01 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
>
> Why is there no -p 5432 on the red hat box? I assume the port is needed. What do I need to do to have the postmaster running on port 5432 like on the fedora box?

Because pgsql is reading it from the postgresql.conf file.

Stick to the /etc/init.d/postgresql way of starting and stopping.

To set pgsql to start automatically on bootup, use chkconfig:

chkconfig postgresql on
chkconfig --list postgresql