On Thu, Sep 11, 2008 at 10:57 AM, Marc Fromm <Marc.Fromm@xxxxxxx> 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
