| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Jonathan Vanasco <postgres(at)2xlp(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_upgrade and ubuntu |
| Date: | 2014-11-14 20:57:42 |
| Message-ID: | 54666CC6.5060701@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/14/14 2:10 PM, Jonathan Vanasco wrote:
> I ran into an issue migrating from 9.1 to 9.3 on ubuntu using pg_upgrade
>
> the default ubuntu package, and the one from postgresql.org, both store `postgresql.conf` in etc as `/etc/postgresql/VERSION/main/postgresql.conf`
>
> however, the pg_upgrade script expects it in the `datadir`.
>
> the simple solution seems to be just symlinking the /etc files into the data dirs.
>
> it took me a while to realize this was the error.
>
> it might make sense to upgrade the docs with a note about what should be in the data dir to enable an upgrade.
On Debian/Ubuntu, use pg_upgradecluster --method upgrade. See the man
page for details.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2014-11-15 04:57:27 | Re: NEW in after insert trugger contained incorrect data |
| Previous Message | David G Johnston | 2014-11-14 19:37:10 | Re: pg_upgrade and ubuntu |