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

Re: [GENERAL] Boneheaded Setup?

From: Simon Drabble <simon(at)eskimo(dot)com>
To: Shawn Pursley <shawn(dot)pursley(at)acorncomputers(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Boneheaded Setup?
Date: 1999-08-24 16:45:37
Message-ID: Pine.LNX.3.96.990824124143.17871A-100000@dragon (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-generalpgsql-interfaces
On Tue, 24 Aug 1999, Shawn Pursley wrote:

> Simon, et al...
> 
> >From the regress_log
> 
> /usr/bin/postmaster does not find the database system.  Expected to find it
> in \
> the PGDATA directory "/usr/local/pgsql/data", but unable to open file with
> path\
> name "/usr/local/pgsql/data/base/template1/pg_class".
> 
> No data directory -- can't proceed.
> 
> 
> It appears that part of my problem is the fact that postgres is not the
> owner and therefore cannot read what's in the base/.  What next?
> 
> TIA,
> Shawn

As root, recursively chown the files in $PGDATA to postgres - this will allow
you to start the postmaster process. You will also need to (as postgres) run
createuser <powner> (if you haven't already) to allow powner to access the db
system.

# chown -r postgres /usr/local/pgsql/

$ su - postgres
$ createuser
Enter name of user to add ---> 

etc.


Simon.



-- 
 "This message will expire soon. Please contact your vendor for an update."
   
   Simon Drabble                      It's like karma for your brain.
   simon(at)eskimo(dot)com


In response to

Responses

pgsql-announce by date

Next:From: Shawn PursleyDate: 1999-08-24 17:14:54
Subject: Re: [GENERAL] Boneheaded Setup?
Previous:From: Shawn PursleyDate: 1999-08-24 16:38:14
Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ...

pgsql-interfaces by date

Next:From: Rusty BrooksDate: 1999-08-24 16:54:32
Subject: Re: [INTERFACES] pgaccess
Previous:From: Shawn PursleyDate: 1999-08-24 16:38:14
Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ...

pgsql-general by date

Next:From: Rick HenryDate: 1999-08-24 16:48:31
Subject: RE: [GENERAL] newbe question
Previous:From: Shawn PursleyDate: 1999-08-24 16:38:14
Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ...

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