Обсуждение: Startup Failure
Greetings all - when I attempt to start my Postgresql-7.0.2 server I receive the following error: FATAL: StreamServerPort: bind() failed: Operation not permitted Is another postmaster already running on that port? If not, remove socket node (/tmp/.s.PGSQL.5432) and retry. /usr/local/pgsql/bin/postmaster: cannot create UNIX stream port I am running Mandrake Linux 7.0 with kernel 2.3.50 on a dual Pentium 200 MMX system, 256Mb RAM. Thanks in advance for any help! Joel
Joel Lansden wrote: > > Greetings all - > > when I attempt to start my Postgresql-7.0.2 server I receive the following > error: > > FATAL: StreamServerPort: bind() failed: Operation not permitted > Is another postmaster already running on that port? > If not, remove socket node (/tmp/.s.PGSQL.5432) and retry. > /usr/local/pgsql/bin/postmaster: cannot create UNIX stream port Is another postmaster running? (ps ax|grep postmaster) Are the PostgreSQL RPM's that come with Mandrake 7 installed? (rpm -qa|grep postgresql) -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
A stupid question : did you see if there was a postmaster process running ? I had this problem that I was unable to kill the postmaster process (with 'kill -9 ...') 1. I stooped the postgres with '/etc/rc.d/postgres stop' that reported that it was done ok. Then when I tried to start it again a got 'postmaster allready running' and 'ps aux | grep postmaster' I found out that it was still running. 2. I tried with 'kill -9' -> still running. 3. then I tried init 2 -> init 1 -> init S = still running 4. reboot reported that postgres directory was still in use when it unmounted it. !!!?????? It has not reoccurred. it's been week now. Joel Lansden wrote: > > Greetings all - > > when I attempt to start my Postgresql-7.0.2 server I receive the following > error: > > FATAL: StreamServerPort: bind() failed: Operation not permitted > Is another postmaster already running on that port? > If not, remove socket node (/tmp/.s.PGSQL.5432) and retry. > /usr/local/pgsql/bin/postmaster: cannot create UNIX stream port > > I am running Mandrake Linux 7.0 with kernel 2.3.50 on a dual Pentium 200 > MMX system, 256Mb RAM. > > Thanks in advance for any help! > > Joel -- --"Would you fly on airplane controlled by MS Windows ?"-- -------------------------------------------------------------------- | Michael Holopainen | Valuraudantie 25 | Tel: +358-(0)9-35093825 | | | 00700 Helsinki | Fax : +358-(0)9-35093850 | | Laserle Oy | Finland | email: michael@laserle.fi| --------------------------------------------------------------------