Re: Can't get pg_upgrade work for 8.4

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

 



Seems that the problem resides in the pg_ctl packaged with Ubuntu 10.04, the only way we found to fix this was to recompile Postgresql 8.4.9 from sources using the following patch, than instruct pg_upgrade (9.1.2) to use the hand compiled pg_ctl instead of the original one (a raw symlink did the job).

Here's the patch, maybe someone could need it.


*** pg_ctl.c.orig       2011-12-27 14:52:27.000000000 +0000
--- pg_ctl.c    2011-12-27 15:20:25.000000000 +0000
***************
*** 503,509 ****
         * probably timeout first
         */
        snprintf(connstr, sizeof(connstr),
! "dbname=postgres port=%s connect_timeout=5", portstr);

        for (i = 0; i < wait_seconds; i++)
        {
--- 503,509 ----
         * probably timeout first
         */
        snprintf(connstr, sizeof(connstr),
! "dbname=postgres port=%s connect_timeout=5 host=localhost", portstr);

        for (i = 0; i < wait_seconds; i++)
        {


Happy new year!

--
Alexander Fortin
http://about.me/alexanderfortin/

--
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