Обсуждение: Starting the database server (2)
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. <bold>1. When I create the database cluster I get this message:</bold> (everything is installed correctly) <italic>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 </italic> When I enter this command line, it ask me a password. I enter the postgres password and I get this message: <italic>sudo: no passwd entry for pgsql!</italic> <bold>2. If I try the command as all the tutorials recommand: </bold> $ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data I get the following error message: <italic>Fatal: no such group 'pgsql' postmaster: cannot create UNIX stream port </italic> <bold>3. I finally tried starting it from the command: </bold> $ /usr/local/pgsql/bin/pg_ctl restart -w -D /usr/local/pgsql/data I received the following messge error: <italic>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 </italic> 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. JavierHi 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
Javier , are u able to su - to the user who owns the folder /usr/local/pgsql/data ? check the user,group for that folder , do a ls -l /usr/local/pgsql and post the results. regds mallah. > 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 ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
On Tue, 26 Nov 2002, Javier Perez wrote: > 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! > Well bearing in mind your comments: > ... 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 think Grass has a errrr...bad installation system. For a start do you have a user called pgsql and does it belong in a group called pgsql? Who owns /usr/local/pgsql/data? (i.e. who did you run initdb as?) Is /sw/var/log/postgresql/logfile writable by pgsql (or the user from the last question)? It could be as simple as changing pgsql in the above sudo sequence to use the correct username or you could have to start fixing up the sudo configuration and then still have other configuration changes to make. Even then you may still have problems judging from the other steps you tried. Although I must admit I didn't read those too closely. In my view the Grass install is ... and has cocked up things for you, therefore you'll probably find you have more than that sudo change to make things work. -- Nigel J. Andrews
Javier Perez <javier.perez@jpmguides.com> writes: > ... > 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. AFAICT, the copy of Postgres you have has been modified by the makers of that CD. I suggest you contact them and ask them exactly how they expect you to start Postgres --- because it sure looks from here like your installation is broken :-( regards, tom lane