> Does your user have permissions to create files in
> $PGDATA/base/database_name? This is the directory where PostgreSQL stores
> its data. If you have not altered the location of your databases you could
> also look in /usr/local/pgsql/databases/base/database_name.
Nope. None only the "postgres" user has permission to write there. This
would make sense since the postmaster is doing everything, not the user.
The user is making requests of the postmaster via the psql program.
> PostgreSQL wants to create a file for each table.
/var/lib/pgsql/base/zztong/*
There is a file there named "mytemp" but it is empty.
Bruce Tong | Got me an office; I'm there late at night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong@laxmi.ev.net | -- Joe Walsh for the 21st Century