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