Date: Tue, 18 Jun 2013 11:06:03 -0700 (PDT)
From: jmfox180 <mcano@stsa.info>
To: pgsql-admin@postgresql.org
Message-ID: <1371578763431-5759711.post@n5.nabble.com>
In-Reply-To: <20130617230803.GC1997@momjian.us>
References: <1371491646614-5759509.post@n5.nabble.com>
 <20130617230803.GC1997@momjian.us>
Subject: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql
 version 9.2."
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

so after trying i advance just a little bit but when running pg_upgrade for a
check or upgrade

i get:

pg_control values:

First log file ID after reset:        0
First log file segment after reset:   2
pg_control version number:            922
Catalog version number:               201204301
Database system identifier:           5890882831378718649
Latest checkpoint's TimeLineID:       1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/726
Latest checkpoint's NextOID:          12047
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        716
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Maximum data alignment:               4
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        2000
Date/time type storage:               floating-point numbers
Float4 argument passing:              by value
Float8 argument passing:              by reference
"/usr/local/pgsql.old/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
"/usr/local/pgsql.old/data/" -o "-p 5432 -c autovacuum=off -c
autovacuum_freeze_max_age=2000000000  -c listen_addresses='' -c
unix_socket_permissions=0700" start >> "pg_upgrade_server.log" 2>&1
*failure*
There were problems executing ""/usr/local/pgsql.old/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/usr/local/pgsql.old/data/" -o "-p 5432 -c
autovacuum=off -c autovacuum_freeze_max_age=2000000000  -c
listen_addresses='' -c unix_socket_permissions=0700" start >>
"pg_upgrade_server.log" 2>&1"
Consult the last few lines of "pg_upgrade_server.log" for
the probable cause of the failure.

pg_ctl failed to start the old server, or connection failed
Failure, exiting


when going to the log file:

  pg_upgrade run on Tue Jun 18 11:58:08 2013
-----------------------------------------------------------------

command: "/usr/local/pgsql.old/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
"/usr/local/pgsql.old/data/" -o "-p 5432 -c autovacuum=off -c $
waiting for server to start....LOG:  database system was shut down at
2013-06-18 11:30:47 CST
LOG:  database system is ready to accept connections
...........................................................could not start
server

 
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-issues-this-utility-can-only-upgrade-to-postgresql-version-9-2-tp5759509p5759711.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin