My postgresql is dead

dext · 2010-04-25 14:32:14

After last pacman -Syu (postgre* are ignored) I can't use Postgresql:

"pg_dump: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory"

I know, that I just need to install actual Potgresql package, but in this case I have to dump databases - in PostgreSQL documentation stands, that it is necessary to dump data bases and load them after upgrade.

But at this point pg_dump doesn't work...

I think I need to rebuild postgresql, but where I can get Postgre 8.4.1 PKGBUILD? Or maybe you have better idea?

EDIT: new title

Last edited by dext (2010-04-26 19:13:19)

n0dix · 2010-04-25 14:41:09

dext wrote:

"pg_dump: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory"

Related issue with library libssl, http://bbs.archlinux.org/viewtopic.php?pid=740340.

Last edited by n0dix (2010-04-25 14:41:30)

dext · 2010-04-25 19:09:52

But I can install new Postgresql package, but I need to do dump first with Postgre v 8.4.1. So I'm quite sure, that I have to rebuild it, but how can I get Postgresql 8.4.1 PKGBUILD?

tomk · 2010-04-25 21:23:42

You can get it from Arch's subversion repo.

dext · 2010-04-26 19:03:00

I got postgresql, but I can't find postgresql-libs, there is not such thing in SVN, http://www.archlinux.org/packages/extra … esql-libs/ has link to postgresql package. I've tried modify URL by my self - no success.

SanskritFritz · 2010-04-26 19:09:16

Could you please choose your subject more carefully? I was shocked to read that postgresql is dead. Turned out, not the project, only your instance. A huge difference

Arch Linux

#1 2010-04-25 14:32:14

My postgresql is dead

#2 2010-04-25 14:41:09

Re: My postgresql is dead

#3 2010-04-25 19:09:52

Re: My postgresql is dead

#4 2010-04-25 21:23:42

Re: My postgresql is dead

#5 2010-04-26 19:03:00

Re: My postgresql is dead

#6 2010-04-26 19:09:16

Re: My postgresql is dead

Board footer