pg_upgrade: "pg_ctl failed to start the new server"

From: "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com>
To: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrade: "pg_ctl failed to start the new server"
Date: 2012-06-13 15:19:41
Message-ID: CABRB-Lun=qy_WZCmf_v0zjhQuHXrmjYy7vQ_qWiqq8Mmzg+FQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to upgrade Postgres 9.0 to 9.1 with pg_upgrade. Both
versions are installed from the PGDG Yum repo:

-bash-4.1$ /usr/pgsql-9.0/bin/postgres -V
postgres (PostgreSQL) 9.0.8
-bash-4.1$ /usr/pgsql-9.1/bin/postgres -V
postgres (PostgreSQL) 9.1.4

I can successfully start and connect to both 9.0 and 9.1. When I run
pg_upgrade, it fails with the error "pg_ctl failed to start the new
server," however it apparently does start the new server (output
below). Any ideas? This is a freshly installed CentOS 6.2 machine
with the 9.0 DB copied over from another machine via streaming
replication (which I have since ended and the server is now
standalone).

Thanks.

# su - postgres
-bash-4.1$ ps ax | grep postg
4354 pts/0 S 0:00 su - postgres
4389 pts/0 S+ 0:00 grep postg
-bash-4.1$ /usr/pgsql-9.1/bin/pg_upgrade -c -b /usr/pgsql-9.0/bin/ -B
/usr/pgsql-9.1/bin/ -d /var/lib/pgsql/9.0/data/ -D
/var/lib/pgsql/9.1/data/
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok
Checking database user is a superuser ok
Checking for prepared transactions ok
Checking for reg* system oid user data types ok
Checking for contrib/isn with bigint-passing mismatch ok

pg_ctl failed to start the new server
Failure, exiting
-bash-4.1$ ps ax | grep postg
4354 pts/0 S 0:00 su - postgres
4445 pts/0 S 0:00 /usr/pgsql-9.1/bin/postgres -D
/var/lib/pgsql/9.1/data -p 5432 -b
4446 ? Ss 0:00 postgres: logger process
4448 ? Ss 0:00 postgres: writer process
4449 ? Ss 0:00 postgres: wal writer process
4450 ? Ss 0:00 postgres: stats collector process
4453 pts/0 S+ 0:00 grep postg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-06-13 16:20:21 Re: Re: [GENERAL] pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index
Previous Message Leif Biberg Kristensen 2012-06-13 15:15:49 Re: Trying to execute several queries involving temp tables in a PHP script