Re: pg_upgrade (9.1 to 9.2) bombing on casts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jul 11, 2013 at 9:55 PM, Wells Oliver <wellsoliver@xxxxxxxxx> wrote:
> Command executed:
>
> time \
> /usr/lib/postgresql/9.2/bin/pg_upgrade -k \
>     -b /usr/lib/postgresql/9.1/bin \
>     -B /usr/lib/postgresql/9.2/bin \
>     -d /data/postgresql/9.1/test \
>     -D /data/postgresql/9.2/main \
>     -o '-D /etc/postgresql/9.1/test' \
>     -O '-D /etc/postgresql/9.2/main'

In future I suggest you to use --check (from docs: check clusters
only, don't change any data) when performing pg_upgrade first. I will
show you all the errors but will not affect your cluster. And you can
use safe it on a running instance BTW.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@xxxxxxxxx


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux