You are not logged in.

#1 2008-10-10 08:13:42

zenlord
Member
From: Belgium
Registered: 2006-05-24
Posts: 1,221
Website

postgresql update to 8.3.4: pg_ctl error with empty postmaster.pid

OK,

Dumb, dumb, dumb. I updated to the latest postgresql yesterday (8.3.3 to 8.3.4 - minor upgrade, so I didn't really think it over) and now postgresql won't start anymore:

#  /etc/rc.d/postgresql start
:: Starting PostgreSQL                                                               [BUSY]
pg_ctl: invalid data in PID file "/var/lib/postgres/data/postmaster.pid" [FAIL]

The pid-file is empty. I read in the change logs that there was a bugfix, probably related to this problem:

Fix pg_ctl to properly preserve postmaster command-line arguments across a restart (Bruce)

But I don't see any questions related to mine in the PGSQL mailing lists since the update. Does anyone know what to do? First thing I'll try is to reinstall the old version...

Zl.

Offline

#2 2008-10-10 08:58:19

zenlord
Member
From: Belgium
Registered: 2006-05-24
Posts: 1,221
Website

Re: postgresql update to 8.3.4: pg_ctl error with empty postmaster.pid

Hmmm... Keeps on adding up: I recently flushed my cached packages. Does anyone have a 8.3.3 i686-package for me?

Zl.

Offline

#3 2008-10-10 09:08:59

zenlord
Member
From: Belgium
Registered: 2006-05-24
Posts: 1,221
Website

Re: postgresql update to 8.3.4: pg_ctl error with empty postmaster.pid

Nevermind -  found the packages and downgraded both postgresql and postgresl-libs to 8.3.3. But still the problem persists.

Help?

Offline

#4 2008-10-10 09:15:45

zenlord
Member
From: Belgium
Registered: 2006-05-24
Posts: 1,221
Website

Re: postgresql update to 8.3.4: pg_ctl error with empty postmaster.pid

Problem solved: renaming thepostmaster.pid-file and restarting the server (in 8.3.3) worked. I won't be experimenting with this any further, because this dbase is very important to my company. Does anyone know how this could happen? Or is it something that has to be changed prior to the upgrade?

Zl.

Offline

#5 2009-01-26 10:06:58

rostoQ
Member
Registered: 2008-06-25
Posts: 40

Re: postgresql update to 8.3.4: pg_ctl error with empty postmaster.pid

I tried to set postgresql up today, and it doesnt work at all, same error as yours additionally to some permission problems i had to solve regarding /var/lib/postgres. Anyway, nothing helps and i dont have a 8.3.3 pac...

EDIT: problem is on both x86 and arch 64 installs

Last edited by rostoQ (2009-01-26 10:07:35)

Offline

Board footer

Powered by FluxBB