General: Unable to start the postgresql after copying postgresql.log

From: neela <neelat100(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: General: Unable to start the postgresql after copying postgresql.log
Date: 2018-10-10 10:18:06
Message-ID: 0421f20b-9443-e19d-022f-1d7790b5c183@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Dear sir/mam,
I'm using postgresql 9.4.6 version.
I've copied the postgresql.log as postgresql.log_bk.
While copying the postgresql.log, I've restarted the postgresql
process.
Then the process got failed and I've got the following error,

psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

And then I've check with log, it gives the result as follow,
FATAL: pre-existing shared memory block is still in use
HINT: If you're sure there are no old server processes still running,
remove the shared memory block or just delete the file
"postmaster.pid".

After that unable to restart the postgresql, it always fails.
After rebooting it gets succeed and truncating postmaster.pid gets
succeed.
Kindly help me how to fix this.

--
with regards,
Neelaveni

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavan Teja 2018-10-10 13:59:57 Re: General: Unable to start the postgresql after copying postgresql.log
Previous Message Jim Finnerty 2018-10-09 17:31:21 Re: IMMEDIATE constraint enforcement does not comply with the SQL standard