Thread: Misplaced pg_upgrade_support.so ?
Hi, Maybe this is better asked on -general instead of -testers. First off, thank you for bringing this into contrib. I built beta2 this morning to give pg_upgrade a test run, and everything worked out great. The only thing I am not sure of is the expected location of pg_upgrade_support.so. It is a default build with the exception of "--prefix=/usr/local/pgsql-beta2"; pg_upgrade_support.so ended up in /usr/local/pgsql-beta2/lib. Here is what I saw when running pg_upgrade initially: %pg_upgrade -d /var/db/pgsql/data \ -D /var/db/pgsql/data2 \ -b /usr/local/pgsql-beta1/bin \ -B /usr/local/pgsql-beta2/bin Performing Consistency Checks ----------------------------- Checking old data directory (/var/db/pgsql/data) ok Checking new data directory (/var/db/pgsql/data2) ok pg_upgrade_support.so must be created and installed in \ /usr/local/pgsql-beta2/lib/postgresql/pg_upgrade_support.so Is this module ending up in the wrong location on install, or is pg_upgrade looking in the wrong place? Thanks and regards, -- Glen Barber
On 6/7/10 1:14 PM, Glen Barber wrote: [snip] > Is this module ending up in the wrong location on install, or is > pg_upgrade looking in the wrong place? > I've received a reply on -testers about this, in case anyone is using pg_upgrade with testing 9.0. http://archives.postgresql.org/pgsql-testers/2010-06/msg00000.php Regards, -- Glen Barber
Glen Barber wrote:
> Hi,
>
> Maybe this is better asked on -general instead of -testers.
>
> First off, thank you for bringing this into contrib.
>
> I built beta2 this morning to give pg_upgrade a test run, and everything
> worked out great. The only thing I am not sure of is the expected
> location of pg_upgrade_support.so. It is a default build with the
> exception of "--prefix=/usr/local/pgsql-beta2"; pg_upgrade_support.so
> ended up in /usr/local/pgsql-beta2/lib.
>
> Here is what I saw when running pg_upgrade initially:
>
> %pg_upgrade -d /var/db/pgsql/data \
> -D /var/db/pgsql/data2 \
> -b /usr/local/pgsql-beta1/bin \
> -B /usr/local/pgsql-beta2/bin
> Performing Consistency Checks
> -----------------------------
> Checking old data directory (/var/db/pgsql/data) ok
> Checking new data directory (/var/db/pgsql/data2) ok
>
>
> pg_upgrade_support.so must be created and installed in \
> /usr/local/pgsql-beta2/lib/postgresql/pg_upgrade_support.so
>
> Is this module ending up in the wrong location on install, or is
> pg_upgrade looking in the wrong place?
Odd. I am confused where that "/postgresql/" is coming from. Can I see
your output of:
pg_config --pkglibdir
Thanks.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
Hi Bruce, On 6/7/10 5:12 PM, Bruce Momjian wrote: > Glen Barber wrote: >> Hi, >> >> Maybe this is better asked on -general instead of -testers. >> >> First off, thank you for bringing this into contrib. >> >> I built beta2 this morning to give pg_upgrade a test run, and everything >> worked out great. The only thing I am not sure of is the expected >> location of pg_upgrade_support.so. It is a default build with the >> exception of "--prefix=/usr/local/pgsql-beta2"; pg_upgrade_support.so >> ended up in /usr/local/pgsql-beta2/lib. >> >> Here is what I saw when running pg_upgrade initially: >> >> %pg_upgrade -d /var/db/pgsql/data \ >> -D /var/db/pgsql/data2 \ >> -b /usr/local/pgsql-beta1/bin \ >> -B /usr/local/pgsql-beta2/bin >> Performing Consistency Checks >> ----------------------------- >> Checking old data directory (/var/db/pgsql/data) ok >> Checking new data directory (/var/db/pgsql/data2) ok >> >> >> pg_upgrade_support.so must be created and installed in \ >> /usr/local/pgsql-beta2/lib/postgresql/pg_upgrade_support.so >> >> Is this module ending up in the wrong location on install, or is >> pg_upgrade looking in the wrong place? > > Odd. I am confused where that "/postgresql/" is coming from. Can I see > your output of: > > pg_config --pkglibdir > > Thanks. > Sure thing: %pg_config --pkglibdir /usr/local/pgsql-beta2/lib/postgresql Let me know if I can provide any additional information. -- Glen Barber
Glen Barber wrote:
> >> exception of "--prefix=/usr/local/pgsql-beta2"; pg_upgrade_support.so
> >> ended up in /usr/local/pgsql-beta2/lib.
> >>
> >> Here is what I saw when running pg_upgrade initially:
> >>
> >> %pg_upgrade -d /var/db/pgsql/data \
> >> -D /var/db/pgsql/data2 \
> >> -b /usr/local/pgsql-beta1/bin \
> >> -B /usr/local/pgsql-beta2/bin
> >> Performing Consistency Checks
> >> -----------------------------
> >> Checking old data directory (/var/db/pgsql/data) ok
> >> Checking new data directory (/var/db/pgsql/data2) ok
> >>
> >>
> >> pg_upgrade_support.so must be created and installed in \
> >> /usr/local/pgsql-beta2/lib/postgresql/pg_upgrade_support.so
> >>
> >
> > pg_config --pkglibdir
> >
> > Thanks.
> >
>
> Sure thing:
>
> %pg_config --pkglibdir
> /usr/local/pgsql-beta2/lib/postgresql
>
> Let me know if I can provide any additional information.
That is interesting. I ran configure --prefix=/usr/local/pgsql-beta2
using CVS HEAD (which should match 9.0 beta2), and my output is
different:
$ ./pg_config --pkglibdir
/usr/var/local/pgsql-beta2/lib
Notice the "/postgresql" is missing. This is before running pg_upgrade.
I am attaching my entire pg_config output. Can I see yours? Thanks.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
BINDIR = /usr/var/local/pgsql-beta2/bin
DOCDIR = /usr/var/local/pgsql-beta2/share/doc
HTMLDIR = /usr/var/local/pgsql-beta2/share/doc
INCLUDEDIR = /usr/var/local/pgsql-beta2/include
PKGINCLUDEDIR = /usr/var/local/pgsql-beta2/include
INCLUDEDIR-SERVER = /usr/var/local/pgsql-beta2/include/server
LIBDIR = /usr/var/local/pgsql-beta2/lib
PKGLIBDIR = /usr/var/local/pgsql-beta2/lib
LOCALEDIR = /usr/var/local/pgsql-beta2/share/locale
MANDIR = /usr/var/local/pgsql-beta2/share/man
SHAREDIR = /usr/var/local/pgsql-beta2/share
SYSCONFDIR = /usr/var/local/pgsql-beta2/etc
PGXS = /usr/var/local/pgsql-beta2/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-tcl' '--with-perl' '--with-tclconfig=/u/lib' '--enable-thread-safety'
'--with-includes=/usr/local/include/readline/usr/contrib/include' '--with-libraries=/usr/local/lib /usr/contrib/lib'
'--with-openssl''--enable-cassert' '--prefix=/usr/local/pgsql-beta2'
CC = ccache gcc
CPPFLAGS = -I/usr/local/include/readline -I/usr/contrib/include
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -O1 -Wall -Wmissing-prototypes
-Wmissing-declarations-Wpointer-arith -Wcast-align
CFLAGS_SL = -fpic
LDFLAGS = -L/usr/local/lib -L/usr/contrib/lib -Wl,-rpath,'/usr/local/pgsql-beta2/lib' -O1 -Wall -Wmissing-prototypes
-Wmissing-declarations-Wpointer-arith -Wcast-align
LDFLAGS_SL =
LIBS = -lpgport -lssl -lcrypto -lz -lreadline -ltermcap -lgetopt -ldl -lutil -lm
VERSION = PostgreSQL 9.0beta2
On 6/7/10 6:59 PM, Bruce Momjian wrote:
> Glen Barber wrote:
>>>> exception of "--prefix=/usr/local/pgsql-beta2"; pg_upgrade_support.so
>>>> ended up in /usr/local/pgsql-beta2/lib.
>>>>
>>>> Here is what I saw when running pg_upgrade initially:
>>>>
>>>> %pg_upgrade -d /var/db/pgsql/data \
>>>> -D /var/db/pgsql/data2 \
>>>> -b /usr/local/pgsql-beta1/bin \
>>>> -B /usr/local/pgsql-beta2/bin
>>>> Performing Consistency Checks
>>>> -----------------------------
>>>> Checking old data directory (/var/db/pgsql/data) ok
>>>> Checking new data directory (/var/db/pgsql/data2) ok
>>>>
>>>>
>>>> pg_upgrade_support.so must be created and installed in \
>>>> /usr/local/pgsql-beta2/lib/postgresql/pg_upgrade_support.so
>>>>
>>>
>>> pg_config --pkglibdir
>>>
>>> Thanks.
>>>
>>
>> Sure thing:
>>
>> %pg_config --pkglibdir
>> /usr/local/pgsql-beta2/lib/postgresql
>>
>> Let me know if I can provide any additional information.
>
> That is interesting. I ran configure --prefix=/usr/local/pgsql-beta2
> using CVS HEAD (which should match 9.0 beta2), and my output is
> different:
>
> $ ./pg_config --pkglibdir
> /usr/var/local/pgsql-beta2/lib
>
> Notice the "/postgresql" is missing. This is before running pg_upgrade.
>
> I am attaching my entire pg_config output. Can I see yours? Thanks.
>
Interestingly, I apparently would have had this issue with beta1:
%pwd
/usr/local/pgsql-beta1/bin
%./pg_config --pkglibdir
/usr/local/pgsql-beta1/lib/postgresql
%cd ../../pgsql-beta2/bin/
%./pg_config --pkglibdir
/usr/local/pgsql-beta2/lib/postgresql
I've attached pg_config output for both. To rule out something off with
my environment, I'm currently setting up a test environment on a
different machine, where I'll check out HEAD as well as beta1 and beta2.
Unless, of course, I'm missing something very obvious in the attached
output.
Regards,
--
Glen Barber
Attachment
On 6/7/10 7:48 PM, Glen Barber wrote: [snip] >> > > Interestingly, I apparently would have had this issue with beta1: > > %pwd > /usr/local/pgsql-beta1/bin > %./pg_config --pkglibdir > /usr/local/pgsql-beta1/lib/postgresql > %cd ../../pgsql-beta2/bin/ > %./pg_config --pkglibdir > /usr/local/pgsql-beta2/lib/postgresql > > I've attached pg_config output for both. To rule out something off with > my environment, I'm currently setting up a test environment on a > different machine, where I'll check out HEAD as well as beta1 and beta2. > Unless, of course, I'm missing something very obvious in the attached > output. > After just realizing CONFIGURE isn't showing what I would expect to see, I rebuilt after removing the original source directories. It looks like I didn't 'gmake clean' before reconfiguring for the new target directories. Sorry for the noise. Thank you for taking the time to look. Regards, -- Glen Barber
Glen Barber wrote: > On 6/7/10 7:48 PM, Glen Barber wrote: > [snip] > >> > > > > Interestingly, I apparently would have had this issue with beta1: > > > > %pwd > > /usr/local/pgsql-beta1/bin > > %./pg_config --pkglibdir > > /usr/local/pgsql-beta1/lib/postgresql > > %cd ../../pgsql-beta2/bin/ > > %./pg_config --pkglibdir > > /usr/local/pgsql-beta2/lib/postgresql > > > > I've attached pg_config output for both. To rule out something off with > > my environment, I'm currently setting up a test environment on a > > different machine, where I'll check out HEAD as well as beta1 and beta2. > > Unless, of course, I'm missing something very obvious in the attached > > output. > > > > After just realizing CONFIGURE isn't showing what I would expect to see, > I rebuilt after removing the original source directories. It looks like > I didn't 'gmake clean' before reconfiguring for the new target directories. > > Sorry for the noise. Thank you for taking the time to look. No problem. Glad we confirmed the cause. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. +