Back to my pg_upgrade stoppage problem

Поиск
Список
Период
Сортировка
От John Scalia
Тема Back to my pg_upgrade stoppage problem
Дата
Msg-id 54B934A3.9020604@gmail.com
обсуждение исходный текст
Ответы Re: Back to my pg_upgrade stoppage problem
Список pgsql-admin
Hi all,

I'm back to trying to figure out the pg_upgrade stoppage problem on my V9.4.0 upgrade from V9.3.3. As stated earlier,
myenvironment is CentOS 6.5 kernel and the server is  
virtualized, but has been running 9.3.3 for some time now. I ran pg_upgrade on this system as follows, I apologize for
thelength of the message but I putting the entire screen  
capture into this. You can see at the end that it got hung up trying to create a temporary table, but the server has
beenon this step for nearly an hour now. It had successfully  
performed several queries prior to this, and those were successful.

  [ postgres@csgha2] /usr/pgsql-9.4/bin/pg_upgrade -b /usr/pgsql-9.3/bin -B /usr/pgsql-9.4/bin -d
/var/lib/pgsql/9.3/data-D /var/lib/pgsql/9.4/data -v 
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
pg_control values:

First log segment after reset:        000000080000004200000034
pg_control version number:            937
Catalog version number:               201306121
Database system identifier:           5999528689196325886
Latest checkpoint's TimeLineID:       8
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/3223
Latest checkpoint's NextOID:          42583
Latest checkpoint's NextMultiXactId:  2
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        1798
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  3222
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 0
Maximum data alignment:               8
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:        1996
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           0
Current pg_control values:

pg_control version number:            942
Catalog version number:               201409291
Database system identifier:           6104926301746638117
Latest checkpoint's TimeLineID:       1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/1810
Latest checkpoint's NextOID:          13004
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        1800
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Maximum data alignment:               8
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:        1996
Size of a large-object chunk:         2048
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           0


Values to be changed:

First log segment after reset:        000000010000000000000002
"/usr/pgsql-9.3/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql/9.3/data" -o "-p 50432 -b  -c
listen_addresses=''-c unix_socket_permissions=0700 -c  
unix_socket_directories='/var/lib/pgsql/9.4/data'" start >> "pg_upgrade_server.log" 2>&1
executing: SELECT datcollate, datctype FROM pg_catalog.pg_database WHERE    datname = 'template0'
executing: SELECT pg_catalog.pg_encoding_to_char(encoding) FROM pg_catalog.pg_database WHERE    datname = 'template0'
executing: SELECT c.relname, c.relfilenode FROM pg_catalog.pg_class c,          pg_catalog.pg_namespace n WHERE
c.relnamespace= n.oid AND           n.nspname = 'pg_catalog'  
AND            c.relname = 'pg_database' ORDER BY c.relname
executing: SELECT d.oid, d.datname, pg_catalog.pg_tablespace_location(t.oid) AS spclocation FROM pg_catalog.pg_database
d LEFT OUTER JOIN pg_catalog.pg_tablespace t  ON  
d.dattablespace = t.oid WHERE d.datallowconn = true ORDER BY 2
executing: CREATE TEMPORARY TABLE info_rels (reloid) AS SELECT c.oid FROM pg_catalog.pg_class c JOIN
pg_catalog.pg_namespacen ON c.relnamespace = n.oid LEFT OUTER JOIN  
pg_catalog.pg_index i         ON c.oid = i.indexrelid WHERE relkind IN ('r', 'm', 'i', 'S') AND  i.indisvalid IS
DISTINCTFROM false AND  i.indisready IS DISTINCT FROM false AND    
((n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_toast_temp_' AND     n.nspname NOT IN ('pg_catalog',
'information_schema','binary_upgrade', 'pg_toast') AND         c.oid >=  
16384)   OR (n.nspname = 'pg_catalog' AND     relname IN ('pg_largeobject', 'pg_largeobject_loid_pn_index',
'pg_largeobject_metadata','pg_largeobject_metadata_oid_index') )); 

Thanks in advance,
Jay


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: PostgreSQL Dump rate is too slow
Следующее
От: Michael Heaney
Дата:
Сообщение: Huge pages not working on PG 9.4