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 德哥
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 6d12d083.29b08.1456a4e6244.Coremail.digoal@126.com
Whole thread Raw
In response to Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
this is my config.
pg94@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@2ndquadrant.com> 写道: >On 2014-04-16 19:19:18 +0800, 德哥 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:  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


pgsql-bugs by date:

Previous
From: 德哥
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: 德哥
Date:
Subject: Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi