pg_upgrade and ubuntu

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrade and ubuntu
Date: 2014-11-14 19:10:56
Message-ID: 60BB2C7C-6399-411C-AC7B-3F994215318D@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-11-14 19:25:49 Re: pg_upgrade and ubuntu
Previous Message John R Pierce 2014-11-14 18:45:52 Re: Two instances of Postgres with single data directory