From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Running pg_upgrade under Debian |
Date: | 2015-04-17 22:25:08 |
Message-ID: | 20150417222508.GF2412@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Apr 18, 2015 at 08:09:43AM +1000, rob stone wrote:
> 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
For what it's worth: Debian provides a
pg_upgradecluster
tailored to its specific setup of PostgreSQL clusters. That
has worked well for me across several major version bumps.
Karsten
> 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
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
From | Date | Subject | |
---|---|---|---|
Next Message | rob stone | 2015-04-17 23:08:20 | Re: Running pg_upgrade under Debian |
Previous Message | Pawel Veselov | 2015-04-17 22:24:07 | Re: Help with slow table update |