Simon Riggs <simon@xxxxxxxxxxxxxxx> writes: > On Thu, Jun 16, 2011 at 7:44 AM, bakkiya <bakkiya@xxxxxxxxx> wrote: >> Space,permission are not an issue. > Then presumably you have your stats_temp_directory parameter set to a > path where that is not true. But the error message is showing the specific file path that the stats collector tried to open. I'm wondering whether the OP is confused about which data directory is in use. It's pretty hard to explain "No such file or directory" by any theory other than that pg_stat_tmp isn't really there in the server's CWD. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
