database - PostgreSQL 9: could not fsync file "base/16386": Invalid argument -


i'm trying test small postgresql setup, cobbled quick local install. however, when i'm trying create personal db createdb, chokes on errors (notably, starts base/16384 first time, , increments each time run it). know what's going on here, or if there's trivial config missed cause this? thanks, , time-critical, please respond if know anything. thanks!

updates:
i'm running on centos 5 server, apologies don't have many further details (it's shared account on server). uname -a has following output:

linux {omitted} 2.6.18-194.11.4.el5 #1 smp tue sep 21 05:04:09 edt 2010 x86_64 x86_64 x86_64 gnu/linux

i installed postgresql source from:

http://wwwmaster.postgresql.org/download/mirrors-ftp/source/v9.0.1/postgresql-9.0.1.tar.bz2

built in home directory , installed prefix=$home/local/pgsql.

here's terminal readout me attempting create user's db on fresh data setup:

[htung@{omitted}:~]$ killall postgres
log: autovacuum launcher shutting down
log: received smart shutdown request
log: shutting down
log: database system shut down
[htung@{omitted}:~]$ rm -r tmp
mk[1]+ done ../local/pgsql/bin/postgres -d $home/tmp (wd: ~/tmp)
(wd now: ~)
[htung@{omitted}:~]$ mkdir tmp
[htung@{omitted}:~]$ local/pgsql/bin/initdb -d $home/tmp
files belonging database system owned user "htung".
user must own server process.

the database cluster initialized locale en_us.utf-8.
default database encoding has accordingly been set utf8.
default text search configuration set "english".

fixing permissions on existing directory /afs/{omitted}/htung/tmp ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32mb
creating configuration files ... ok
creating template1 database in /afs/{omitted}/htung/tmp/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading pl/pgsql server-side language ... ok
vacuuming database template1 ... ok
copying template1 template0 ... ok
copying template1 postgres ... ok

warning: enabling "trust" authentication local connections
can change editing pg_hba.conf or using -a option the
next time run initdb.

success. can start database server using:

local/pgsql/bin/postgres -d /afs/{omitted}/htung/tmp   

or
local/pgsql/bin/pg_ctl -d /afs/{omitted}/htung/tmp -l logfile start

[htung@{omitted}:~]$ local/pgsql/bin/postgres -d $home/tmp
log: database system shut down @ 2010-11-15 13:47:25 pst
log: autovacuum launcher started
log: database system ready accept connections

[1]+ stopped local/pgsql/bin/postgres -d $home/tmp
[htung@{omitted}:~]$ bg
[1]+ local/pgsql/bin/postgres -d $home/tmp &
[htung@{omitted}:~]$ local/pgsql/bin/createdb
error: not fsync file "base/16384": invalid argument
statement: create database htung;

createdb: database creation failed: error: not fsync file "base/16384": invalid argument
[htung@{omitted}:~]$

i guess you're possibly running se linux system here. i'd recommend either turn off selinux , see if works, or install rpms available postgresql website.


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

html - Instapaper-like algorithm -

c# - How to execute a particular part of code asynchronously in a class -