Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-05 Thread Jim Nasby
On 1/4/16 7:40 PM, Adrian Klaver wrote: or even better yet could you post the section of the log above the error? The server log itself might be useful, especially if full query logging was turned on. Dunno how easy/possible that is with pg_upgrade. -- Jim Nasby, Data Architect, Blue Treble C

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-04 Thread Michael Paquier
On Tue, Jan 5, 2016 at 6:58 AM, Adrian Klaver wrote: > On 01/04/2016 12:53 PM, Arthur Pemberton wrote: >> >> Yes, I have tried it without --jobs, just to simplify. >> > > That would have been too easy. Not sure what is going on. > > So are there any other errors, warnings, etc between?: > > Checki

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-04 Thread Arthur Pemberton
Maybe there was a verbose settings that would have given me that, but what I pasted was literally all the output I got. In the end, I did a pg_dumpapp On Mon, Jan 4, 2016 at 8:40 PM, Adrian Klaver wrote: > On 01/04/2016 02:37 PM, Arthur Pemberton wrote: > >> Nothing useful. I'm just going to giv

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-04 Thread Adrian Klaver
On 01/04/2016 02:37 PM, Arthur Pemberton wrote: Nothing useful. I'm just going to give up and use pg_dump to a new machine. Hopefully that allows me to bypass this issue. Did that help? To help someone else troubleshoot this, did the error you get occur after the pg_upgrade line: Restoring

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-04 Thread Arthur Pemberton
Nothing useful. I'm just going to give up and use pg_dump to a new machine. Hopefully that allows me to bypass this issue. On Mon, Jan 4, 2016 at 4:58 PM, Adrian Klaver wrote: > On 01/04/2016 12:53 PM, Arthur Pemberton wrote: > >> Yes, I have tried it without --jobs, just to simplify. >> >> > Th

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-04 Thread Adrian Klaver
On 01/04/2016 12:53 PM, Arthur Pemberton wrote: Yes, I have tried it without --jobs, just to simplify. That would have been too easy. Not sure what is going on. So are there any other errors, warnings, etc between?: Checking cluster versions ok and SQL com

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-04 Thread Arthur Pemberton
Yes, I have tried it without --jobs, just to simplify. # /usr/pgsql-9.3/bin/pg_config BINDIR = /usr/pgsql-9.3/bin DOCDIR = /usr/share/doc/pgsql HTMLDIR = /usr/share/doc/pgsql INCLUDEDIR = /usr/pgsql-9.3/include PKGINCLUDEDIR = /usr/pgsql-9.3/include INCLUDEDIR-SERVER = /usr/pgsql-9.3/include/serve

[GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-03 Thread Arthur Pemberton
I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with packages from Postgres' yum repo. I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't get very far however, I get the following error, and Google doesn't seem to help. -bash-4.1$ /usr/pgsql-9.4/bin/pg_u

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-03 Thread Adrian Klaver
On 01/03/2016 12:03 AM, Arthur Pemberton wrote: I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with packages from Postgres' yum repo. I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't get very far however, I get the following error, and Google doesn't

[GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

2016-01-03 Thread Arthur Pemberton
I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with packages from Postgres' yum repo. I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't get very far however, I get the following error, and Google doesn't seem to help. -bash-4.1$ /usr/pgsql-9.4/bin/pg_u