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