can't re-start postgresql

From: mjbjr(at)beaudesign(dot)com
To: <pgsql-general(at)postgresql(dot)org>
Subject: can't re-start postgresql
Date: 2001-05-31 08:04:46
Message-ID: Pine.LNX.4.30.0105310026390.12112-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had a system, that was running postgres-7.1-1, lockup, and I had to
reboot. Since the reboot, I can't get postgresql restarted.

As user 'postgres':

[postgres(at)localhost postgres]$ date
Thu May 31 00:40:09 PDT 2001

((current date))

[postgres(at)localhost postgres]$ echo $PGDATA
/var/lib/pgsql/data

((dat dir is set))

[ ... postgres]$ /usr/bin/postmaster > /tmp/postgres_logfile 2>&1 &
[1] 12117

[postgres(at)localhost postgres]$ ps aux | grep 12117
postgres 12119 0.0 0.1 1332 512 pts/5 S 00:34 0:00 grep 12117

((hmm, no pid))

[postgres(at)localhost postgres]$ cat /tmp/postgres_logfile
Found a pre-existing shared memory block (ID 4224672) still in use.
If you're sure there are no old backends still running,
remove the shared memory block with ipcrm(1), or just
delete "/var/lib/pgsql/data/postmaster.pid".

[postgres(at)localhost postgres]$ cat /var/lib/pgsql/data/postmaster.pid
15058
/var/lib/pgsql/data
5432001 4224672

[postgres(at)localhost postgres]$ ps aux | grep 15058
postgres 12123 0.0 0.1 1332 512 pts/5 S 00:37 0:00 grep 15058

[postgres(at)localhost postgres]$ ls -l /var/lib/pgsql/data/postmaster.pid
-rw------- 1 postgres postgres 46 May 13 00:37
/var/lib/pgsql/data/postmaster.pid

(( ah, that postmaster.pid is from the last running postmaster: ))

[postgres(at)localhost postgres]$ ipcrm shm 4224672
shmctl : Identifier removed

((**appears** to have worked))

[postgres(at)localhost postgres]$ ps aux | grep 12130
postgres 12132 0.0 0.1 1332 512 pts/5 S 00:45 0:00 grep 12130

((but no))

[postgres(at)localhost postgres]$ ipcs -m 4224672

((returns a ton of addr info))

*******

Anyhow, the gist of it appears to be...

postmaster can't get restarted because of a shared mem problem, and that
while it appears to be removed ('ipcrm'), i get the same postgresql
startup error(s). So it appears it is not being removed.

Any ideas on how to rectify the situation?

Thank you

--
- Martin J. Brown, Jr. -
- mjbjr(at)beaudesign(dot)com -

PGP Public Key ID: 0xCED9BD8A Key Server: http://www.keyserver.net/en/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Borzov 2001-05-31 09:12:07 Postgres docs in .chm format --- is this possible?
Previous Message rui zhong 2001-05-31 04:22:07 How to set constraint on ...?