Created
December 10, 2012 12:57
-
-
Save riffraff/4250396 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mecbucpro:tmp postgres$ /Library/PostgreSQL/9.2/bin/pg_upgrade --old-port 5432 --new-port 5433 --old-datadir /Library/PostgreSQL/9.1/data/ --new-datadir /Library/PostgreSQL/9.2/data/ --old-bindir /Library/PostgreSQL/9.1/bin/ --new-bindir /Library/PostgreSQL/9.2/bin/ --verbose --link --retain --check --user=postgres | |
Running in verbose mode | |
Performing Consistency Checks | |
----------------------------- | |
Checking current, bin, and data directories ok | |
Checking cluster versions ok | |
pg_control values: | |
First log file ID after reset: 28 | |
First log file segment after reset: 215 | |
pg_control version number: 903 | |
Catalog version number: 201105231 | |
Database system identifier: 5722741746533352285 | |
Latest checkpoint's TimeLineID: 1 | |
Latest checkpoint's NextXID: 0/4374159 | |
Latest checkpoint's NextOID: 90539 | |
Latest checkpoint's NextMultiXactId: 1 | |
Latest checkpoint's NextMultiOffset: 0 | |
Latest checkpoint's oldestXID: 986 | |
Latest checkpoint's oldestXID's DB: 1 | |
Latest checkpoint's oldestActiveXID: 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 | |
pg_control values: | |
First log file ID after reset: 5 | |
First log file segment after reset: 57 | |
pg_control version number: 922 | |
Catalog version number: 201204301 | |
Database system identifier: 5819121212110535659 | |
Latest checkpoint's TimeLineID: 1 | |
Latest checkpoint's full_page_writes: on | |
Latest checkpoint's NextXID: 0/1364 | |
Latest checkpoint's NextOID: 28688 | |
Latest checkpoint's NextMultiXactId: 1 | |
Latest checkpoint's NextMultiOffset: 0 | |
Latest checkpoint's oldestXID: 989 | |
Latest checkpoint's oldestXID's DB: 1 | |
Latest checkpoint's oldestActiveXID: 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 | |
"/Library/PostgreSQL/9.1/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/Library/PostgreSQL/9.1/data/" -o "-p 5432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/private/tmp'" start >> "pg_upgrade_server.log" 2>&1 | |
connection to database failed: fe_sendauth: no password supplied | |
could not connect to old postmaster started with the command: | |
"/Library/PostgreSQL/9.1/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/Library/PostgreSQL/9.1/data/" -o "-p 5432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/private/tmp'" start | |
Failure, exiting | |
mecbucpro:tmp postgres$ /Library/PostgreSQL/9.2/bin/psql psql (9.2.2, server 9.1.3)WARNING: psql version 9.2, server version 9.1. | |
Some psql features might not work. | |
Type "help" for help. | |
postgres=# \q | |
mecbucpro:tmp postgres$ /Library/PostgreSQL/9.1/bin/psql | |
psql (9.1.3) | |
Type "help" for help. | |
postgres=# \q | |
mecbucpro:tmp postgres$ pwd | |
/tmp | |
mecbucpro:tmp postgres$ whoami | |
postgres | |
mecbucpro:tmp postgres$ echo $PGHOST | |
/tmp |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
tried setting password in .pgpass and using "trust" for all local connections in pg_hba.conf, but no dice