Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Date
Msg-id 20140416112732.GE17874@awork2.anarazel.de
Whole thread Raw
In response to BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi  (digoal@126.com)
Responses Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
List pgsql-bugs
Tree view 
On 2014-04-16 19:19:18 +0800, =E5=BE=B7=E5=93=A5 wrote:
> pg94@db-172-16-3-150-> strace -c initdb
> The files belonging to this database system will be owned by user "pg94=
".
> This user must also own the server process.

strace -c isn't particularly helpful here, we'd need normal strace, not
the summary.

> creating template1 database in /home/pg94/pg_root/base/1 ... LOG:  writ=
e() in XLogFileInit returned 40960: Success
> FATAL:  could not write to file "pg_xlog/xlogtemp.832": No space left
> on device

You compiled postgres with nonstandard options? Specifically you seem to
have used a nonstandard wal blocksize?

Greetings,

Andres Freund

--=20
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi