Two configuration issues...

From: "E(dot) Matthew Finnin" <emf(dot)storage(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Two configuration issues...
Date: 2006-04-01 22:09:18
Message-ID: c939097c0604011409l4dda638fp6972dcad702ed79e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have Postgres 8.1 on Kubuntu Breezy on powerpc. I used the apt-get
to install the package. The server ran fine right from the beginning
and I had no problems with psql. I then changed the location of my
data directory and I created a new user. I can still use psql, but
now I have two (maybe small) issues.

1. When I attempt /etc/init.d/postgresql-8.1 restart I get the error:

Stopping PostgreSQL 8.1 database server: main
Error: pid file is invalid, please manually kill the stale server process

...but the server starts up just fine. When I look at current process
I find four postmaster processes. I don't really know how to describe
it, but it looks like one lead process, two sub-processes, and one
sub-sub-process. Is this a problem? Did I forget to do something
when changing my data directory?

2. My other problem: When I am running as a non-root user and I type:
$ su postgres
I'm asked for a password and no matter what I type I have an
authorization failure. Now, I assumed this would be the password I
created for my superuser when running initdb -D. Is there anyway to
figure out what this password is or to change it? Or do I need to
just accept that I need to do su root before I do su postgres?

Thanks for any help or suggestions.

-eric

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Yadnyesh Joshi 2006-04-02 06:48:27 Semaphore trouble for installation
Previous Message Volkan YAZICI 2006-04-01 18:39:44 libpq Describe Extension [WAS: Bytea and perl]