Thread: RE: [GENERAL] Thing that makes me go "Hmmm"

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.  PostgreSQL
wants to create a file for each table.  I was able to create table mptemp
using the code below.

> -----Original Message-----
> From:    Bruce Tong [SMTP:zztong@laxmi.ev.net]
> Sent:    Monday, May 03, 1999 1:10 PM
> To:    Michael J Davis
> Cc:    PostgreSQL General
> Subject:    RE: [GENERAL] Thing that makes me go "Hmmm"
>
> > Are you out of disk space?
>
> Ooo, I didn't think of that... Nope. 49% used.
>
> > try
> >     CREATE TABLE mytemp
> >     (
> >       id    int4 unique not null,
> >       mystr varchar(50)
> >     );
>
> Cannot create mytemp
>
>
> 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
>
>

> 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