Arch Linux

DeatzoSeol

Member

Registered: 2012-06-12

Posts: 10

PostgreSQL 9.2 → 9.3 'pg_dumpall' issue

Okay. So I wanted to upgrade postgresql from 9.2 to 9.3. I do have postgresql-old-upgrade.

I init a new 9.3 database and run pg_upgrade:
   

su - postgres -c "pg_upgrade -d /var/lib/postgres/data-9.2 -D /var/lib/postgres/data -b /opt/pgsql-9.2/bin -B /usr/bin"

Just like it says on the wiki.

And then something incredibly strange happens:
   

check for "/usr/bin/pg_dumpall" failed: No such file or directory

Oops. Guess for some reason pg_dumpall isn't present in the system, even after reinstalling the package.

And since nobody's complaint yet and there's no bug report for it (yet?), I assume there's something else going on than the package being broken?

twelveeighty

Member

Registered: 2011-09-04

Posts: 1,452

Re: PostgreSQL 9.2 → 9.3 'pg_dumpall' issue

Check postgresql-libs:

# pacman -Qo /usr/bin/pg_dumpall 
/usr/bin/pg_dumpall is owned by postgresql-libs 9.3.1-3

Last edited by twelveeighty (2013-10-30 03:20:37)

Scimmia

Fellow

Registered: 2012-09-01

Posts: 13,727

Re: PostgreSQL 9.2 → 9.3 'pg_dumpall' issue

% pkgfile /usr/bin/pg_dumpall
extra/postgresql-libs