[ADMIN] Starting the database server (2)

[Javier Perez]

Hi guys,

I still have a problem to start the database server as I wrote in the first mail. I read many and many tutorials, but nothing is working to start the postmaster.

1. When I create the database cluster I get this message:

(everything is installed correctly)

Success. You can now start the database server using:
sudo -u root sudo -u pgsql /usr/local/pgsql/bin/pg_ctl \ -D /usr/local/pgsql/data -l /sw/var/log/postgresql/logfile start

When I enter this command line, it ask me a password. I enter the postgres password and I get this message:

sudo: no passwd entry for pgsql!


2. If I try the command as all the tutorials recommand:

$ /usr/local/pgsql/bin/postmaster   -D   /usr/local/pgsql/data

I get the following error message:
Fatal: no such group 'pgsql'
postmaster: cannot create UNIX stream port

3. I finally tried starting it from the command:

$ /usr/local/pgsql/bin/pg_ctl restart -w -D /usr/local/pgsql/data

I received the following messge error:

pg_clt: cannot find /usr/local/pgsql/data/postmaster.pid
Is postmaster running?
starting postmaster anyway
cat: /usr/local/pgsql/data/postmaster.opts: No such file or directory
/usr/local/pgsql/bin/pg_ctl: : command not found
waiting for postmaster to start................................................................................failed
pg_ctl: postmaster does not start

This was all what happened when I wrote the command line. Actually I don't know why I don't have both files postmaster.pid and postmaster.opts? Do you think my PostgreSQL isn't correctly installed?

I work on MacOSX 10.2 and I installed PostgreSQL 7.2.2. In my case PostgreSQL was include in a CD pack with another open source called Grass. It's a GIS (geographical information system). When I installed this open source, it automatically installed PostgreSQL and I couldn't choose anything during the installation. I think I don't need to compile PostgreSQL after this. I tell you this because I don't know if this has an influence with my problems for starting postmaster.

I hope someone can help me to resolve this problem to launch the postmaster.

Thanks for you help.
Javier