pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedinstalling uuid generators
8+ messages / 4 participants
[nested] [flat]
* installing uuid generators
@ 2010-03-15 23:58 Rob Sargent <robjsargent@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Rob Sargent @ 2010-03-15 23:58 UTC (permalink / raw)
To: pgsql-sql
Stop me if you've heard this one before :)
Given that pg_config --libdir yields "/usr/lib64"
to where/what would you expect
"AS '$libdir/uuid-ossp', 'uuid_generate_v5'"
to resolve?
The loader script,
~/tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql, generates
"tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql:9: ERROR: could
not access file "$libdir/uuid-ossp": No such file or directory"
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 09:20 Richard Huxton <dev@archonet.com>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Richard Huxton @ 2010-03-16 09:20 UTC (permalink / raw)
To: Rob Sargent <robjsargent@gmail.com>; +Cc: pgsql-sql
On 15/03/10 23:58, Rob Sargent wrote:
> Stop me if you've heard this one before :)
>
> Given that pg_config --libdir yields "/usr/lib64"
> to where/what would you expect
>
> "AS '$libdir/uuid-ossp', 'uuid_generate_v5'"
>
> to resolve?
>
> The loader script,
> ~/tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql, generates
> "tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql:9: ERROR: could
> not access file "$libdir/uuid-ossp": No such file or directory"
Could it be that $libdir doesn't contain uuid-ossp when the .sql script
is being executed?
It's also worth checking that the pg_config you are executing is the one
associated with postgresql-8.4.2 - make sure your PATH is set
appropriately. I'm not sure that it would give this error, but I keep
making the mistake of setting my PATH with the three versions I have on
my dev box.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 18:08 Rob Sargent <robjsargent@gmail.com>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 8+ messages in thread
From: Rob Sargent @ 2010-03-16 18:08 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
On 03/16/2010 03:20 AM, Richard Huxton wrote:
> On 15/03/10 23:58, Rob Sargent wrote:
>> Stop me if you've heard this one before :)
>>
>> Given that pg_config --libdir yields "/usr/lib64"
>> to where/what would you expect
>>
>> "AS '$libdir/uuid-ossp', 'uuid_generate_v5'"
>>
>> to resolve?
>>
>> The loader script,
>> ~/tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql, generates
>> "tools/postgresql-8.4.2/contrib/uuid-ossp/uuid-ossp.sql:9: ERROR: could
>> not access file "$libdir/uuid-ossp": No such file or directory"
>
> Could it be that $libdir doesn't contain uuid-ossp when the .sql script
> is being executed?
>
> It's also worth checking that the pg_config you are executing is the one
> associated with postgresql-8.4.2 - make sure your PATH is set
> appropriately. I'm not sure that it would give this error, but I keep
> making the mistake of setting my PATH with the three versions I have on
> my dev box.
>
Thanks for your suggestions. You were exactly right. I was pointed at
an 8.3 server in the hinterland, not my own. Terribly sorry for the
noise. (Of course that fact was staring at me from the sql prompt, which
contains servername :/)
I'm still left worried about the correct procedure for getting uuid-oosp
installed properly on SUSE 11. Does the server release's contrib
contain uuid-ossp? I didn't see it on my desktop release. (I don't
want to have to tell my mates to go through the issues I had building
the lib etc.)
Now I have to clean up after myself for having dropped links to that .so
everywhere!
Thanks again.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 20:11 Richard Huxton <dev@archonet.com>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Richard Huxton @ 2010-03-16 20:11 UTC (permalink / raw)
To: Rob Sargent <robjsargent@gmail.com>; +Cc: pgsql-sql
On 16/03/10 18:08, Rob Sargent wrote:
> I'm still left worried about the correct procedure for getting uuid-oosp
> installed properly on SUSE 11. Does the server release's contrib
> contain uuid-ossp? I didn't see it on my desktop release. (I don't
> want to have to tell my mates to go through the issues I had building
> the lib etc.)
I'd be surprised if there wasn't a -contrib or -extras rpm with the
relevant files. The community rpms should have them if the "official"
Suse ones don't
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 20:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 8+ messages in thread
From: Tom Lane @ 2010-03-16 20:26 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: Rob Sargent <robjsargent@gmail.com>; pgsql-sql
Richard Huxton <dev@archonet.com> writes:
> On 16/03/10 18:08, Rob Sargent wrote:
>> I'm still left worried about the correct procedure for getting uuid-oosp
>> installed properly on SUSE 11. Does the server release's contrib
>> contain uuid-ossp? I didn't see it on my desktop release. (I don't
>> want to have to tell my mates to go through the issues I had building
>> the lib etc.)
> I'd be surprised if there wasn't a -contrib or -extras rpm with the
> relevant files. The community rpms should have them if the "official"
> Suse ones don't
If there is a contrib rpm but it doesn't seem to contain uuid-ossp,
the likely reason is that the maintainer never got around to adding
--with-ossp-uuid to the build options. (I know it took me a while
to add that to the Fedora build :-(.) You could confirm or deny
that theory by looking at the output of pg_config --configure.
If so, file a bug report with SUSE asking for that to be added.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 23:14 Rob Sargent <robjsargent@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Rob Sargent @ 2010-03-16 23:14 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Richard Huxton <dev@archonet.com>; pgsql-sql
On 03/16/2010 02:26 PM, Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
>> On 16/03/10 18:08, Rob Sargent wrote:
>>> I'm still left worried about the correct procedure for getting uuid-oosp
>>> installed properly on SUSE 11. Does the server release's contrib
>>> contain uuid-ossp? I didn't see it on my desktop release. (I don't
>>> want to have to tell my mates to go through the issues I had building
>>> the lib etc.)
>
>> I'd be surprised if there wasn't a -contrib or -extras rpm with the
>> relevant files. The community rpms should have them if the "official"
>> Suse ones don't
>
> If there is a contrib rpm but it doesn't seem to contain uuid-ossp,
> the likely reason is that the maintainer never got around to adding
> --with-ossp-uuid to the build options. (I know it took me a while
> to add that to the Fedora build :-(.) You could confirm or deny
> that theory by looking at the output of pg_config --configure.
> If so, file a bug report with SUSE asking for that to be added.
>
> regards, tom lane
As Tom suspected the SUSE build doesn't name ossp stuff, to wit:
$ pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/packages/postgresql
HTMLDIR = /usr/share/doc/packages/postgresql
INCLUDEDIR = /usr/include/pgsql
PKGINCLUDEDIR = /usr/include/pgsql
INCLUDEDIR-SERVER = /usr/include/pgsql/server
LIBDIR = /usr/lib64
PKGLIBDIR = /usr/lib64/postgresql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/postgresql
SYSCONFDIR = /usr/etc/postgresql
PGXS = /usr/lib64/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr' '--libdir=/usr/lib64' '--bindir=/usr/bin'
'--includedir=/usr/include/pgsql' '--datadir=/usr/share/postgresql'
'--mandir=/usr/share/man' '--docdir=/usr/share/doc/packages'
'--disable-rpath' '--enable-nls' '--enable-thread-safety'
'--enable-integer-datetimes' '--without-python' '--without-perl'
'--without-tcl' '--with-openssl' '--with-pam' '--with-krb5'
'--with-gssapi' '--with-ldap' '--with-libxml' '--with-libxslt'
'--with-system-tzdata=/usr/share/zoneinfo' 'CFLAGS=-fmessage-length=0
-O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables
-fasynchronous-unwind-tables -g '
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2
-fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall
-Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -fno-strict-aliasing -fwrapv
CFLAGS_SL = -fpic
LDFLAGS = -Wl,--as-needed
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err
-lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm
VERSION = PostgreSQL 8.4.2
And I guess --without-perl explains some the machinations necessary to
get bucardo working.
Thanks to all.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 23:29 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Tom Lane @ 2010-03-16 23:29 UTC (permalink / raw)
To: Rob Sargent <robjsargent@gmail.com>; +Cc: Richard Huxton <dev@archonet.com>; pgsql-sql
Rob Sargent <robjsargent@gmail.com> writes:
> As Tom suspected the SUSE build doesn't name ossp stuff, to wit:
> CONFIGURE = '--prefix=/usr' '--libdir=/usr/lib64' '--bindir=/usr/bin'
> '--includedir=/usr/include/pgsql' '--datadir=/usr/share/postgresql'
> '--mandir=/usr/share/man' '--docdir=/usr/share/doc/packages'
> '--disable-rpath' '--enable-nls' '--enable-thread-safety'
> '--enable-integer-datetimes' '--without-python' '--without-perl'
> '--without-tcl' '--with-openssl' '--with-pam' '--with-krb5'
> '--with-gssapi' '--with-ldap' '--with-libxml' '--with-libxslt'
> '--with-system-tzdata=/usr/share/zoneinfo' 'CFLAGS=-fmessage-length=0
> -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables
> -fasynchronous-unwind-tables -g '
--without-perl? --without-python? What are these people thinking?
(Personally I don't like --without-tcl either, but I know not so
many people care about that one anymore.)
File an RFE, or find a more clueful distro.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: installing uuid generators
@ 2010-03-16 23:42 Jorge Godoy <jgodoy@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Jorge Godoy @ 2010-03-16 23:42 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Rob Sargent <robjsargent@gmail.com>; Richard Huxton <dev@archonet.com>; pgsql-sql
Perl and Python are external packages, not part of the main package.
Here's the list:
S | Name | Summary
| Type
--+----------------------------------------+-------------------------------------------------------------------------+-----------
i | postgresql | Basic Clients and Utilities for
PostgreSQL | package
| postgresql | Basic Clients and Utilities for
PostgreSQL | srcpackage
i | postgresql | postgresql security update
| patch
i | postgresql-contrib | Contributed Extensions and
Additions to PostgreSQL | package
i | postgresql-devel | PostgreSQL development header
files and libraries | package
i | postgresql-docs | HTML Documentation for
PostgreSQL | package
| postgresql-ip4r | IPv4 and IPv4 range index types
for PostgreSQL | srcpackage
| postgresql-ip4r | IPv4 and IPv4 range index types
for PostgreSQL | package
| postgresql-jdbc | JDBC Drivers for PostgreSQL
| package
| postgresql-jdbc | JDBC Drivers for PostgreSQL
| srcpackage
i | postgresql-libs | Shared Libraries Required for
PostgreSQL Clients | package
| postgresql-libs-32bit | Shared Libraries Required for
PostgreSQL Clients | package
| postgresql-pl | The PL/Tcl, PL/Perl, and
PL/Python Procedural Languages for PostgreSQL | srcpackage
| postgresql-plperl | The PL/Tcl, PL/Perl, and
PL/Python procedural languages for PostgreSQL | package
i | postgresql-plpython | The PL/Python Procedural
Languages for PostgreSQL | package
| postgresql-pltcl | PL/Tcl Procedural Language for
PostgreSQL | package
i | postgresql-server | The Programs Needed to Create
and Run a PostgreSQL Server | package
| python-storm-postgresql | PostgreSQL backend for
python-storm | package
And no, uuid-ossp isn't there.
--
Jorge Godoy <jgodoy@gmail.com>
On Tue, Mar 16, 2010 at 20:29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Rob Sargent <robjsargent@gmail.com> writes:
> > As Tom suspected the SUSE build doesn't name ossp stuff, to wit:
>
> > CONFIGURE = '--prefix=/usr' '--libdir=/usr/lib64' '--bindir=/usr/bin'
> > '--includedir=/usr/include/pgsql' '--datadir=/usr/share/postgresql'
> > '--mandir=/usr/share/man' '--docdir=/usr/share/doc/packages'
> > '--disable-rpath' '--enable-nls' '--enable-thread-safety'
> > '--enable-integer-datetimes' '--without-python' '--without-perl'
> > '--without-tcl' '--with-openssl' '--with-pam' '--with-krb5'
> > '--with-gssapi' '--with-ldap' '--with-libxml' '--with-libxslt'
> > '--with-system-tzdata=/usr/share/zoneinfo' 'CFLAGS=-fmessage-length=0
> > -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables
> > -fasynchronous-unwind-tables -g '
>
> --without-perl? --without-python? What are these people thinking?
> (Personally I don't like --without-tcl either, but I know not so
> many people care about that one anymore.)
>
> File an RFE, or find a more clueful distro.
>
> regards, tom lane
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2010-03-16 23:42 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-15 23:58 installing uuid generators Rob Sargent <robjsargent@gmail.com>
2010-03-16 09:20 ` Richard Huxton <dev@archonet.com>
2010-03-16 18:08 ` Rob Sargent <robjsargent@gmail.com>
2010-03-16 20:11 ` Richard Huxton <dev@archonet.com>
2010-03-16 20:26 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-16 23:14 ` Rob Sargent <robjsargent@gmail.com>
2010-03-16 23:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-16 23:42 ` Jorge Godoy <jgodoy@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox