Two configuration issues...
От | E. Matthew Finnin |
---|---|
Тема | Two configuration issues... |
Дата | |
Msg-id | c939097c0604011409l4dda638fp6972dcad702ed79e@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Two configuration issues...
|
Список | 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
В списке pgsql-novice по дате отправления: