The error I get:

./pgadmin3: error while loading shared libraries: libpq.so.4: cannot open shared object file: No such file or directory

Now this is where people say RTFM, add the location of the library to the /etc/ld.so.conf- but I did that already. In fact, ldconfig -v says it's already installed!
...
/usr/local/pgsql/lib:
...
libpq.so.4 -> libpq.so.4.0

This is absolutely crazy. Please help. This is almost as bad as the phppgadmin's meaningless "login failed" message.

Do you really have the library file?
Try also:
(should mention that the lib can't be found.)
and
to locate the file.

The path to this library probably needs to be in your $LD_LIBRARY_PATH variable or something like that as well.

Adding it to some conf file may not do the trick. You may need to make your system re-read the conf file to actually start using the lib.

Thank you.

Yes it is definately there. My system didn't seem to have a $LD_LIBRARY_PATH variable because I typed in "echo $LD_LIBRARY_PATH" and nothing came out. So anyway I typed in LD_LIBRARY_PATH=/usr/local/pgsql/bin"

ran ldd pgadmin3 again, and it still says that the library is file not found.

I'm just not understanding what is going on here, it's in my conf file and ldconfig says it is there, what more does linux want?

As far as rereading the conf, isn't that what ldconfig does and if it shows it as loaded (with the -v switch) then isn't it supposed to work?

Isn't there a "lib" directory? "bin" is typically used to store the binary (compiled) programs, not the libraries.

Yeah, you may be right about ldconfig. I personnally haven't used it yet, so I can't help you with that.
Maybe you can try adding the lib path to your $PATH as well?