Steve Baldwin <steve.baldwin@xxxxxxxxx> writes: > If I make a connection to that DB from most clients I see log entries like > this: > ... > If however I use psql I see two connection log entries - sometimes almost a > second apart. For example: These log entries show that you're using password-based authentication. I believe what is happening is that psql tries to connect, discovers that it needs a password, and then tries again after it's got a password. The delay would correspond to the time for you to type your password (I take it you're a fast typist). If you don't like the extra log entries, there's a command-line switch that forces psql to prompt for password before connecting the first time. Of course, that might result in prompting for a password that's not really needed. regards, tom lane
