| Lists: | pgsql-bugs |
|---|
| From: | John Bester <john(at)softco(dot)co(dot)za> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | pg_upgradecluster 9.5 to 10.3 |
| Date: | 2018-05-12 05:37:52 |
| Message-ID: | 31b09530-1cb9-46ca-81ad-156a0c2d9fcc@softco.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
I just upgraded an Ubuntu 16.04 LTS server to 18.04 LTS and aprt of that upgrade was
to upgrade a Postgres 9.5 database to 10.3. The pg_upgradecluster executed without
any errors, but in the new databases only public schemas were copied - all other
schemas are gone.
--
John Bester
Nexti SA PTY LTD
Tel. (023) 313 3011
john(at)softco(dot)co(dot)za
| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | John Bester <john(at)softco(dot)co(dot)za> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: pg_upgradecluster 9.5 to 10.3 |
| Date: | 2018-05-12 06:40:59 |
| Message-ID: | 20180512064058.GB19285@msg.df7cb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Re: John Bester 2018-05-12 <31b09530-1cb9-46ca-81ad-156a0c2d9fcc(at)softco(dot)co(dot)za>
> I just upgraded an Ubuntu 16.04 LTS server to 18.04 LTS and aprt of that
> upgrade was
> to upgrade a Postgres 9.5 database to 10.3. The pg_upgradecluster executed
> without
> any errors, but in the new databases only public schemas were copied - all
> other
> schemas are gone.
Hi John,
you still have the full terminal output from that command?
Do you still have the 9.5 cluster around? What happens if you remove
the 10 cluster and up upgrade the 9.5 cluster again?
Christoph