Skip to content

Instantly share code, notes, and snippets.

@riffraff
Created December 10, 2012 12:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save riffraff/4250396 to your computer and use it in GitHub Desktop.
Save riffraff/4250396 to your computer and use it in GitHub Desktop.
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
@riffraff
Copy link
Author

tried setting password in .pgpass and using "trust" for all local connections in pg_hba.conf, but no dice

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment