SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Guru johnjohn2's Avatar
    Join Date
    Apr 2004
    Location
    here
    Posts
    746
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    postmaster service won't start postgresql

    I have postgresql (cygwin install) on W2K server. It's a test server and I didn't have battery backup. Over the weekend we had a power failure. And of course now, (since it was shut down dirty) the postmaster service won't start. Does anyone have any ideas?

  2. #2
    SitePoint Zealot sanka69's Avatar
    Join Date
    Apr 2003
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This problem has hunted me since I started using Postgres on Windows. That is, assuming it's the same problem;
    Check in your log files for something like this:

    Code:
    FATAL:  pre-existing shared memory block (key 5432001, ID 0) is still in use
    HINT:  If you're sure there are no old server processes still running, 
    remove the shared memory block with the command "ipcrm", or just
    delete the file "/usr/share/postgresql/data/postmaster.pid".
    And that's the problem. When postgres is shutdown, this file doesn't appear to be deleted. To make matters slightly more irritating, deleting this file can't be done from explorer either. You need to go into a cygwin bash and "rm -f postmaster.pid".

    There might be a work around for this, but unfortuntely I don't know what it is.

    Hope this helps,
    Richard

  3. #3
    SitePoint Guru johnjohn2's Avatar
    Join Date
    Apr 2004
    Location
    here
    Posts
    746
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks. Worked perfectly. I was able to delete it from explorer, using the postgres user I setup that has ownership of those files.

    Quote Originally Posted by sanka69
    This problem has hunted me since I started using Postgres on Windows. That is, assuming it's the same problem;
    Check in your log files for something like this:

    Code:
    FATAL:  pre-existing shared memory block (key 5432001, ID 0) is still in use
    HINT:  If you're sure there are no old server processes still running, 
    remove the shared memory block with the command "ipcrm", or just
    delete the file "/usr/share/postgresql/data/postmaster.pid".
    And that's the problem. When postgres is shutdown, this file doesn't appear to be deleted. To make matters slightly more irritating, deleting this file can't be done from explorer either. You need to go into a cygwin bash and "rm -f postmaster.pid".

    There might be a work around for this, but unfortuntely I don't know what it is.

    Hope this helps,
    Richard


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •