From: | schoetbi <tobias(dot)schoenit(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_upgrade 9.5.1: pg_upgrade_support missing |
Date: | 2016-03-03 08:31:04 |
Message-ID: | 1456993864762-5890380.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I tried to delete all binary_upgrade schematas using this:
$ psql -tc "SELECT datname FROM pg_database" -U postgres -p 5433 | xargs -I
{} psql -d {} -U postgres -p 5433 -tc "drop schema if exists binary_upgrade
cascade;"
But got this:
output is not a tty
So I got the dblist from pgadmin and saved to file:
That worked:
$ cat dblist.txt | xargs -I {} psql -d {} -U postgres -p 5433 -tc "drop
schema if exists binary_upgrade cascade;"
pg_upgrade succeeded with the step:
Checking for presence of required libraries ok
But then I got:
Checking database user is the install user
Only the install user can be defined in the new cluster.
Failure, exiting
But this is the next story ;-) I can assure that deleting the schematas from
the source db solves my initial problem.
Thanks for your help,
Tobias Schönit
--
View this message in context: http://postgresql.nabble.com/pg-upgrade-9-5-1-pg-upgrade-support-missing-tp5890202p5890380.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | David Bennett | 2016-03-03 10:35:58 | Re: CStringGetTextDatum and other conversions in server-side code |
Previous Message | Andres Freund | 2016-03-03 07:49:28 | Re: Confusing with commit time usage in logical decoding |