tags 628786 unreproducible moreinfo thanks Re: Josip Rodin 2011-06-01 <20110601105638.ga2...@entuzijast.net> > Package: postgresql-contrib-9.0 > Version: 9.0.4-1~bpo60+1 > > Hi, > > I needed to get SHA-1 support in PostgreSQL. Googling says pgcrypto is the > contrib module to use. So I installed this package, reloaded the server, > digest() wasn't available, restarted it, ditto. More googling then told me > there's /usr/share/postgresql/9.0/contrib/pgcrypto.sql that I need to apply > first. Why couldn't the package or at least mention that? > Only /usr/share/doc/postgresql-contrib-9.0/README is shipped, and it's > apparently completely generic and useless.
Hi Joy, the README is useless, agreed. > So, anyway, I tried applying that file, > > % sudo -H -u postgres psql test-sha < > /usr/share/postgresql/9.0/contrib/pgcrypto.sql > SET > ERROR: nemoguć pristup datoteci "$libdir/pgcrypto": No such file or > directory Works here with 9.0.4-1. The bpo version also ships the right file, as evidenced on http://packages.debian.org/squeeze-backports/amd64/postgresql-contrib-9.0/filelist: /usr/lib/postgresql/9.0/lib/pgcrypto.so Did you tweak the lib settings in the server config? > But the new output is: > > ERROR: neuspjelo čitanje biblioteke > "/usr/lib/postgresql/9.0/lib/pgcrypto.so": > /usr/lib/postgresql/9.0/lib/pgcrypto.so: undefined symbol: > cstring_to_text_with_len > > (the foreign string is "failed to read library" or similar) > > Surely this library isn't supposed to be this hard/impossible to use :) What does ldd /usr/lib/postgresql/9.0/lib/pgcrypto.so say? Christoph -- c...@df7cb.de | http://www.df7cb.de/
signature.asc
Description: Digital signature
