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 digoal@126.com
Subject BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Date
Msg-id 20140414014442.15385.74268@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      10013
Logged by:          digoal.zhou
Email address:      digoal@126.com
PostgreSQL version: Unsupported/Unknown
Operating system:   CentOS 6.4 x64
Description:

I use recent postgresql snapshot from
http://git.postgresql.org/gitweb/?p=postgresql.git;a=snapshot;h=e0c91a7ff015fab0ccbb0f75b6819f29ae00295e;sf=tgz
but when initdb, error reported.

pg94@db-172-16-3-150-> df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sdc1              29G  9.0G   19G  33% /
tmpfs                  48G     0   48G   0% /dev/shm
/dev/sdc3              98G   29G   64G  31% /opt
/dev/sdd1             183G   32G  143G  19% /ssd1
/dev/sda1             221G  7.5G  202G   4% /ssd3
/dev/sdb1             221G   36G  174G  18% /ssd4
pg94@db-172-16-3-150-> df -i
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/sdc1            1921360  199173 1722187   11% /
tmpfs                12381887       1 12381886    1% /dev/shm
/dev/sdc3            6479872  442050 6037822    7% /opt
/dev/sdd1            12173312    1479 12171833    1% /ssd1
/dev/sda1            14655488    2313 14653175    1% /ssd3
/dev/sdb1            14655488    2095 14653393    1% /ssd4


pg94@db-172-16-3-150-> initdb -D /home/pg94/pg_root --debug
Running in debug mode.
The files belonging to this database system will be owned by user "pg94".
This user must also own the server process.

VERSION=9.4devel
PGDATA=/home/pg94/pg_root
share_path=/home/pg94/pgsql9.4devel/share
PGPATH=/home/pg94/pgsql9.4devel/bin
POSTGRES_SUPERUSERNAME=pg94
POSTGRES_BKI=/home/pg94/pgsql9.4devel/share/postgres.bki
POSTGRES_DESCR=/home/pg94/pgsql9.4devel/share/postgres.description
POSTGRES_SHDESCR=/home/pg94/pgsql9.4devel/share/postgres.shdescription
POSTGRESQL_CONF_SAMPLE=/home/pg94/pgsql9.4devel/share/postgresql.conf.sample
PG_HBA_SAMPLE=/home/pg94/pgsql9.4devel/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=/home/pg94/pgsql9.4devel/share/pg_ident.conf.sample
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/pg94/pg_root ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
creating template1 database in /home/pg94/pg_root/base/1 ... DEBUG:
invoking IpcMemoryCreate(size=152027136)
DEBUG:  SlruScanDirectory invoking callback on pg_notify/0000
DEBUG:  removing file "pg_notify/0000"
DEBUG:  dynamic shared memory system will support 288 segments
DEBUG:  created dynamic shared memory control segment 1804289383 (2316
bytes)
DEBUG:  transaction ID wrap limit is 2147483650, limited by database with
OID 1
DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID
1
DEBUG:  creating and filling new WAL file
FATAL:  could not write to file "pg_xlog/xlogtemp.3590": No space left on
device
DEBUG:  shmem_exit(1): 0 before_shmem_exit callbacks to make
DEBUG:  shmem_exit(1): 4 on_shmem_exit callbacks to make
DEBUG:  cleaning up dynamic shared memory control segment with ID
1804289383
DEBUG:  proc_exit(1): 3 callbacks to make
DEBUG:  exit(1)
DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
DEBUG:  proc_exit(-1): 0 callbacks to make
child process exited with exit code 1
initdb: removing data directory "/home/pg94/pg_root"

pgsql-bugs by date:

Previous
From: kona ajay
Date:
Subject: cant insert into a postgre sql table from c# please help to solve this......... |Thanks very much in advance
Next
From: kona ajay
Date:
Subject: cant insert into a post gre sql table...Can u please help in fixing this