Обсуждение: Starting the database server (2)

Поиск
Список
Период
Сортировка

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.


<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

Re: Starting the database server (2)

От
Дата:

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/



Re: Starting the database server (2)

От
"Nigel J. Andrews"
Дата:
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


Re: Starting the database server (2)

От
Tom Lane
Дата:
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