| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Thomas Krebs" <thomas(at)krebs-haertl(dot)de> |
| Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [NOVICE] newbie problem on creating table |
| Date: | 2000-07-10 15:05:32 |
| Message-ID: | 668.963241532@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
"Thomas Krebs" <thomas(at)krebs-haertl(dot)de> writes:
>>>> It just returns "Error cannot create <tablename>.
I believe this error indicates that the kernel rejected Postgres'
attempt to create a file for the new table. Unfortunately we can't
see the exact kernel error message (that's fixed for 7.1, but it
won't help you for 7.0 unless you're prepared to alter and recompile
sources...).
I will make a wild guess that the problem is incorrect permissions on
the database directory. Take a look in $PGDATA/base/ and make sure the
database subdirectory is owned and writable by whatever user you are
running the postmaster as. (Which had better NOT be root!)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2000-07-10 15:11:51 | Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios... |
| Previous Message | Philip Warner | 2000-07-10 14:52:00 | RE: PostgreSQL & the BSD License |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ERIC Lawson - x52010 | 2000-07-10 16:41:16 | Re: order by accents? |
| Previous Message | Travis Bauer | 2000-07-10 13:07:20 | Re: [NOVICE] newbie problem on creating table |