Are There Any Good Postgresql Clients for Linux

PostgreSQL client -- How To Start It?

Postgresql has no built in gui.

to check if it is running run the following from a terminal

ps aux | grep postgres

You can use psql to access from the command line.

to install psql

aptitude install postgresql-client

then to run

psql -h dbhost -U username dbname

If you want a gui intall package pgadmin

aptitude install pgadmin3

Can you recommend a PostgreSQL Visual Database Designer for Linux?

pgDesigner is a database design application for PostgreSQL, for
versions 7.x and 8.x.

pgDesigner provides the following features:

Complete datamodel editor
Support for PostgreSQL objects: tables, views, relations,
tablespaces, procedures, triggers, types, domains and sequences
Automatic updating of relations between tables.
Wizard for the construction of views.
Report generator, with statistics
Printing the diagram
SQL export
Creation of the database
Management of the project on a diagram chart

good postgresql client for windows?

I like Postgresql Maestro. I also use their version for MySql. I'm pretty statisfied with their product. Or you can use the free tool PgAdmin.

Good Postgres graphical client for Windows

Use PgAdmin.

However - I don't think you'll find much that won't use a large amount of memory when you have a result set with 1.5 million rows...

PgAdmin has the ability to limit automatically the number of rows returned - so you can get an overview, but not sit for an hour waiting for your results to turn up. If you write a query to return that many rows though, than you are going to have problems.

(You can also look at the limit SQL command, to restrict how many results you get back)

What PostgreSQL admin GUI interface support SSH tunnelling?

Tell PgAdmin3 to connect locally and tell that local connection to do a port forward using SSH. Works for OSX.

http://www.ur-ban.com/blog/2010/10/25/ssh-tunnels-with-postgres-pgadmin/

http://www.postgresonline.com/journal/archives/38-PuTTY-for-SSH-Tunneling-to-PostgreSQL-Server.html