Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] newbie problem on creating table

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

pgsql-novice by date

Next:From: ERIC Lawson - x52010Date: 2000-07-10 16:41:16
Subject: Re: order by accents?
Previous:From: Travis BauerDate: 2000-07-10 13:07:20
Subject: Re: [NOVICE] newbie problem on creating table

pgsql-general by date

Next:From: Jan WieckDate: 2000-07-10 15:11:51
Subject: Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...
Previous:From: Philip WarnerDate: 2000-07-10 14:52:00
Subject: RE: PostgreSQL & the BSD License

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group