Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error - Mailing list pgsql-general

From Laurenz Albe
Subject Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Date
Msg-id 21740f0009198f64a262086451d6f026233777e9.camel@cybertec.at
Whole thread Raw
In response to could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error  (Soni M <diptatapa@gmail.com>)
Responses Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error  (Soni M <diptatapa@gmail.com>)
List pgsql-general
On Fri, 2021-01-15 at 16:13 +0700, Soni M wrote:
> We filled out the wal archive disk, and then those messages appear
> 
> [...]PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": Input/output error"
> 
> And now I cannot start postgres
> 
> [...]PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error"
> 
> Any idea to solve this ?

Did you add more disk space?

You won't be able to start PostgreSQL unless you do that.

And no, don't start deleting files in the data directory.

What you can do is move the *complete* data directory to another location
with more disk space and start it there.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Soni M
Date:
Subject: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Next
From: Soni M
Date:
Subject: Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error