Bug 300124

Summary:	postgresql-server-8.4.2-r1 does not start
Product:	Gentoo Linux	Reporter:	Dmitry Grigoriev <dimgel>
Component:	[OLD] Server	Assignee:	Gentoo Linux bug wranglers <bug-wranglers>
Status:	RESOLVED INVALID
Severity:	major	CC:	alunduil, casta
Priority:	High
Version:	unspecified
Hardware:	AMD64
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Dmitry Grigoriev 2010-01-08 03:48:32 UTC

After upgrading postgresql-base & postgresql-server yesterday from 8.4.1 to 8.4.2-r1, I got:

# /etc/init.d/postgresql-8.4 start
 * Starting PostgreSQL ...
waiting for server to start...............................................................could not start server  [ !! ]
 * The pid-file doesn't exist but pg_ctl reported a running server.
 * Please check whether there is another server running on the same port or read the log-file.  [ !! ]

Reproducible: Always

Steps to Reproduce:

Comment 1 Alex Brandt (RETIRED) gentoo-dev

2010-01-08 05:55:57 UTC

What if you zap the service first: /etc/init.d/postgresql-8.4 zap?

Does it allow you to start the service after that?

Comment 2 Guillaume Castagnino 2010-01-08 07:10:20 UTC

Same problem here : seems that 8.4.2-r1 enables HAVE_INT64_TIMESTAMP wheras previous version did not (see your postmaster.log)

So you need to dump your data (with the old version), then restore after upgrade !

Comment 3 Guillaume Castagnino 2010-01-08 07:13:13 UTC

Sorry, I forget this : you should have see the "pg_legacytimestamp" USE flag
Enable it to have a working DB without dump/restore ;)

Comment 4 Dmitry Grigoriev 2010-01-08 10:13:35 UTC

"zap" did not not help. What helped:

1. downgrade to 8.4.2
2. # pg_dumpall -Upostgres > postgresql-8.4.2.sql
3. re-upgrade to 8.4.2-r1
4. # cd /var/lib/postgresql; mv 8.4 8.4.2
5. # emerge --config =dev-db/postgresql-server-8.4.2-r1
6. # /etc/init.d/postgresql-8.4 start
7. # psql -Upostgres -f postgresql-8.4.2.sql postgres

Guillaume Castagnino, thank you. I'm closing this ticket.