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

Post a Comment

Popular posts from this blog

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

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

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

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more