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

Re: [GENERAL] Boneheaded Setup?

From: "Shawn Pursley" <shawn(dot)pursley(at)acorncomputers(dot)com>
To: "Simon Drabble" <simon(at)eskimo(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:25:08
Message-ID: 006f01beee4d$3bfa3b60$9f5305c7@go.servicetransport.com (view raw or flat)
Thread:
Lists: pgsql-announcepgsql-generalpgsql-interfaces
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.

[postgres(at)pusher pgsql]$ cd /usr/local/pgsql/data/
[postgres(at)pusher data]$ ls -la
total 53

drwxrwsr-x   3 powner   postgres     1024 Aug 12 17:05 ./
drwxrwsr-x   8 postgres postgres     1024 Aug 18 09:10 ../
-rw-------   1 powner   postgres        4 Aug 12 16:12 PG_VERSION
drwx--S---   4 powner   postgres     1024 Aug 17 11:27 base/
-rw-------   1 powner   postgres     8192 Aug 17 11:27 pg_database
-r--------   1 powner   postgres     3407 Aug 12 16:12 pg_geqo.sample
-rw-------   1 powner   postgres        0 Aug 12 16:12 pg_group
-rw--w----   1 powner   postgres     5191 Aug 12 17:05 pg_hba.conf
-rw--w----   1 powner   postgres     5192 Aug 12 16:12 pg_hba.conf~
-rw-------   1 powner   postgres     8192 Aug 18 11:00 pg_log
-rw-rw-rw-   1 powner   postgres       51 Aug 12 16:12 pg_pwd
-rw-------   1 powner   postgres     8192 Aug 12 16:12 pg_shadow
-rw-------   1 powner   postgres     8192 Aug 18 11:00 pg_variable
[postgres(at)pusher data]$ cd base/
bash: cd: base/: Permission denied
[postgres(at)pusher data]$ ps
  PID TTY          TIME CMD
  678 pts/0    00:00:00 bash
 1272 pts/0    00:00:00 ps

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
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.

[postgres(at)pusher pgsql]$ cd /usr/local/pgsql/data/
[postgres(at)pusher data]$ ls -la
total 53

drwxrwsr-x   3 powner   postgres     1024 Aug 12 17:05 ./
drwxrwsr-x   8 postgres postgres     1024 Aug 18 09:10 ../
-rw-------   1 powner   postgres        4 Aug 12 16:12 PG_VERSION
drwx--S---   4 powner   postgres     1024 Aug 17 11:27 base/
-rw-------   1 powner   postgres     8192 Aug 17 11:27 pg_database
-r--------   1 powner   postgres     3407 Aug 12 16:12 pg_geqo.sample
-rw-------   1 powner   postgres        0 Aug 12 16:12 pg_group
-rw--w----   1 powner   postgres     5191 Aug 12 17:05 pg_hba.conf
-rw--w----   1 powner   postgres     5192 Aug 12 16:12 pg_hba.conf~
-rw-------   1 powner   postgres     8192 Aug 18 11:00 pg_log
-rw-rw-rw-   1 powner   postgres       51 Aug 12 16:12 pg_pwd
-rw-------   1 powner   postgres     8192 Aug 12 16:12 pg_shadow
-rw-------   1 powner   postgres     8192 Aug 18 11:00 pg_variable
[postgres(at)pusher data]$ cd base/
bash: cd: base/: Permission denied
[postgres(at)pusher data]$ ps
  PID TTY          TIME CMD
  678 pts/0    00:00:00 bash
 1272 pts/0    00:00:00 ps

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

----- Original Message -----
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>
Sent: Tuesday, August 24, 1999 11:12 AM
Subject: Re: [GENERAL] Boneheaded Setup?


> On Tue, 24 Aug 1999, Shawn Pursley wrote:
>
> > I've currently got pgsql up and running but I have a couple of problems
and
> > I'm wondering if someone can help me.
> >
> > Here's what I'm getting where postgres should run the postmaster and
powner
> > is the common user account:
> >
> > [postgres(at)pusher pgsql]$ nohup postmaster > regress.log 2>&1 &
> > [1] 691
> > [postgres(at)pusher pgsql]$ su powner
> > Password:
> > [powner(at)pusher pgsql]$ psql template1
> > Connection to database 'template1' failed.
> > connectDB() failed: Is the postmaster running and accepting connections
at
> > 'UNIX
> >  Socket' on port '5432'?
> >
> > I setup just about everything that the docs said to, staying away from
root,
> > etc.  If I run that postmaster command from the powner user, then I can
> > access pgsql, but only as that user.
> >
> >
> > Shawn Pursley(shawn(dot)pursley(at)service-transport(dot)com)
> >
>
>
> what does the log say? can you do a ps and see the postmaster process
running?
>
>
> 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 16:38:14
Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ...
Previous:From: Simon DrabbleDate: 1999-08-24 16:12:49
Subject: Re: [GENERAL] Boneheaded Setup?

pgsql-interfaces by date

Next:From: Shawn PursleyDate: 1999-08-24 16:38:14
Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ...
Previous:From: Robert HiltibidalDate: 1999-08-24 16:14:38
Subject: pgaccess

pgsql-general by date

Next:From: Hub.Org News AdminDate: 1999-08-24 16:37:59
Subject:
Previous:From: Daniel P├ęderDate: 1999-08-24 16:22:14
Subject: RE: [GENERAL] newbe question

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