Running pg_upgrade under Debian

From: rob stone <floriparob(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Running pg_upgrade under Debian
Date: 2015-04-17 22:09:43
Message-ID: 1429308583.2928.18.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm trying to upgrade from 9.3 to 9.4 on my laptop and encountering this
error:-

postgres(at)roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade
-b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.4/bin
-d /home/postgres/data93/userqueries
-D /home/postgres/data94/userqueries -U pguserqueries

check for "/home/postgres/data93/userqueries/base" failed: No such file
or directory

Failure, exiting
postgres(at)roblaptop:/usr/lib/postgresql/9.4/bin$

postgres(at)roblaptop:/usr/lib/postgresql/9.4/bin$ ./pg_upgrade --version
pg_upgrade (PostgreSQL) 9.4.1

I have two tablespaces defined for this data -- one to hold the tables
and another for the indices.

There is no "base" file or directory.

Do I just create a dummy directory named "base"?

If there is supposed to be a directory or file named "base" why wasn't
it created by initdb?

Regards,
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pawel Veselov 2015-04-17 22:24:07 Re: Help with slow table update
Previous Message Andreas Joseph Krogh 2015-04-17 21:29:54 Re: How to keep pg_largeobject from growing endlessly