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

From: 德哥 <digoal(at)126(dot)com>
To: "Andres Freund" <andres(at)2ndquadrant(dot)com>
Cc: "Heikki Linnakangas" <hlinnakangas(at)vmware(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Date: 2014-04-16 11:31:33
Message-ID: 6d12d083.29b08.1456a4e6244.Coremail.digoal@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

this is my config.
pg94(at)db-172-16-3-150-> pg_config
BINDIR = /home/pg94/pgsql9.4devel/bin
DOCDIR = /home/pg94/pgsql9.4devel/share/doc
HTMLDIR = /home/pg94/pgsql9.4devel/share/doc
INCLUDEDIR = /home/pg94/pgsql9.4devel/include
PKGINCLUDEDIR = /home/pg94/pgsql9.4devel/include
INCLUDEDIR-SERVER = /home/pg94/pgsql9.4devel/include/server
LIBDIR = /home/pg94/pgsql9.4devel/lib
PKGLIBDIR = /home/pg94/pgsql9.4devel/lib
LOCALEDIR = /home/pg94/pgsql9.4devel/share/locale
MANDIR = /home/pg94/pgsql9.4devel/share/man
SHAREDIR = /home/pg94/pgsql9.4devel/share
SYSCONFDIR = /home/pg94/pgsql9.4devel/etc
PGXS = /home/pg94/pgsql9.4devel/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/home/pg94/pgsql9.4devel' '--with-pgport=1933' '--with-perl' '--with-tcl' '--with-python' '--with-openssl' '--with-pam' '--without-ldap' '--with-libxml' '--with-libxslt' '--enable-thread-safety' '--with-wal-blocksize=64' '--with-blocksize=32' '--enable-dtrace' '--enable-debug'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -L../../../src/common -Wl,--as-needed -Wl,-rpath,'/home/pg94/pgsql9.4devel/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lz -lreadline -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 9.4devel

--
公益是一辈子的事,I'm Digoal,Just Do It.

在 2014-04-16 19:27:32,"Andres Freund" <andres(at)2ndquadrant(dot)com> 写道:
>On 2014-04-16 19:19:18 +0800, 德哥 wrote:
>> pg94(at)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: write() 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
>
>--
> Andres Freund http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2014-04-16 11:34:38 Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Previous Message Heikki Linnakangas 2014-04-16 11:28:52 Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi