Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Soni M <diptatapa(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Date: 2021-01-15 09:33:36
Message-ID: 21740f0009198f64a262086451d6f026233777e9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Soni M 2021-01-15 09:40:39 Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error
Previous Message Soni M 2021-01-15 09:13:10 could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error