Ubuntu – PostgreSQL 9.1 adminpack install

There is a PPA having 1.14.0beta1 version but it does not have 11.10 support:

https://launchpad.net/~rhonda/+archive/pgadmin3

So you can try to add this PPA as 11.04 or download directly the packages and install them by hand:

https://launchpad.net/~rhonda/+archive/pgadmin3/+packages

Delete it. .pgpass is just a file. Enter the passwords on the command line if you don't want to store them. psql will never create or modify .pgpass, so you must've set it up yourself.

It makes no sense to store .pgpass encrypted; you'd need a password to decrypt it, and the whole point of .pgpass is for automating password logins.

The solution here is don't use a .pgpass file if you don't really need the passwordless login and aren't willing to accept the security compromises it imposes. Since it sounds like your .pgpass was created by PgAdmin-III, tell it not to save passwords and it won't create .pgpass. It gave you a big warning the first time you told it to save a password, telling you that it would store the password in clear text, for exactly this reason.

If you need strong and secure passwordless logins, use Kerberos / GSSAPI.

That said, anyone who has super-user rights can get your passwords no matter what you do. They can capture your typing with a keylogger. They can modify libpq to save the passwords to a file as they're entered. Lots of options. If you don't trust the superuser(s) on your machine, find somewhere else to work from, because you've already lost.