custom port unhandled while using psycopg

[Marcin.Kasperski@…]

I tried using trac-admin with the following database string: postgres://USER:PWD@localhost:5433/DBNAME but it occured that I get connection failures mentioning … port 5432.

Quick look at the code of site-packages/trac/db.py shows why:

        if psycopg:
            dsn = []
            if path:
                dsn.append('dbname=' + path)
            if user:
                dsn.append('user=' + user)
            if password:
                dsn.append('password=' + password)
            if host:
                dsn.append('host=' + host)
            cnx = psycopg.connect(' '.join(dsn))

There is no if for port option!

Observed on trac from debian unstable (0.9.1)

[Allan]

I reported this same bug two months ago, with no response: #2167

[Matthew Good]

Well, then this can be closed as a duplicate.