Re: [GENERAL] Boneheaded Setup?

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  (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@eskimo.com