Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."

From: jmfox180 <mcano(at)stsa(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Date: 2013-06-18 18:06:03
Message-ID: 1371578763431-5759711.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ziggy Skalski 2013-06-18 21:02:23 Re: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Previous Message Bambi Bellows 2013-06-18 17:53:03 Re: Pg max_connection