[Moosefs-users] (FYI) fail to build postgresql on MFS disk

[Anh K. H. <ky...@vi...>]

Hi,

I am trying to build `postgresql-9.0.3` on a Lenny system. The source is located on a MFS disk. The build process is good (binaries are created), but the tests fails (for example, test "numeric_big" as below); and many sql statements cannot be executed. Please note that during the test, Debian system will run a temporary database server to feed SQL statements.

I move source to a NFS disk, and things go well. So this post may help anyone who intends to build `postgresql` on MFS disk. If you need any information, just let me know.

Regards,

Logs:

*** /home/debian/psql.source/postgresql-9.0-9.0.3/src/test/regress/expected/numeric_big.out     2011-01-27 18:21:31.000000000 -0800
--- /home/debian/psql.source/postgresql-9.0-9.0.3/src/test/regress/results/numeric_big.out      2011-02-07 20:17:12.000000000 -0800
***************
*** 500,505 ****
--- 500,506 ----
  CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
  CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON num_exp_power_10_ln (id);
  VACUUM ANALYZE num_exp_add;
+ WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat": Operation not permitted
  VACUUM ANALYZE num_exp_sub;
  VACUUM ANALYZE num_exp_div;
  VACUUM ANALYZE num_exp_mul;

-- 
Anh Ky Huynh @ UTC+7