On 04/02/16 05:21, John R Pierce wrote:
> On 2/3/2016 7:06 PM, jpaul@aconex.com wrote:
>> /usr/lib/postgresql/9.5/bin/pg_upgrade --old-datadir
>> '/etc/postgresql/8.4/main' --new-datadir '/etc/postgresql/9.5/main'
>
> I don't use Ubuntu, but the data directories shouldn't be in /etc, thats
> where the powergresql.conf files are located in their wrappered
> systems. The data directories should be in /var/something.
>
>
>
Correct
The default schema is
/var/lib/postgresql/<major_version>/<cluster_name>/
the --new-datadir should be
/var/lib/postgresql/9.5/main
--
Federico Campoli
Brandwatch | Senior Database Administrator
federico@brandwatch.com |
New York | San Francisco | *Brighton* | Berlin | Stuttgart