Dpkg Error After Upgrading Database

carlosinfl · 10-12-2011, 08:52 AM

I ran a system upgrade on Wheezy over the weekend and noticed PostgreSQL was due to be updated so I accepted considering it was a minor update / patch and then I noticed I was getting some strange error when I used 'psql' utility after the update:

Code:

cmennens@slave:~$ psql -l
Can't exec "dpkg-architecture": No such file or directory at /usr/bin/psql line 103.
Use of uninitialized value $multiarch in scalar chomp at /usr/bin/psql line 104.
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------

Anyone know if there's a fix / patch or something I'm missing here? Beyond the annoying error, there's no impact from what I can see on PostgreSQL. I can still manage my database using the 'psql' utility but I just get this error above in 'red'.

widget · 10-12-2011, 08:29 PM

When ever I get a dpkg error the first thing I try is, as root;

Code:

dpkg --configure -a

dpkg will attempt to install the package again.

If that doesn't work, again as root;

Code:

apt-get -f install

no package name or anything that is the entire command.

If that doesn't work some more research on the problem commences.