[SQLObject] Acces postgresql...

[Philippe B. <pb...@pa...>]

Hello,

  I have two machine with postgresql, but the first with the
  port 5432 and the other with the port 5435 (I'm not
  database administrator)

  How to do modify the port in connectionForUri.. ??

  Thank you very much for your help.  

  I try this :
  'postgres://perso:se...@my...chine:5435/testdb'
   but it is  the same error...


  with the potsgresql port 5432 no problem :

>>> from sqlobject import *

>>> conn =
    connectionForURI('postgres://perso:se...@my...chine/testdb')
>>>
>>> conn.getConnection()
<connection object at 0x140542030>
>>>
>>> class Person(SQLObject):
...     _connection = conn
...     name = StringCol()
...
>>>
>>> Person.createTable()

    It's Ok :-)
          

    but with postgresql port 5435 I have this error :


>>> from sqlobject import *

...etc..

>>> conn.getConnection()
------------------------------------------------------------
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File
  "/home/python/lib/python2.3/site-packages/sqlobject/dbconnection.py", line 134, in getConnection
    newConn = self.makeConnection()
  File
  "/home/python/lib/python2.3/site-packages/sqlobject/postgres/pgconnection.py", line 65, in makeConnection
    raise self.module.OperationalError("%s; used connection
    string %r" % (e, self.dsn))
OperationalError: could not connect to server: Connection refused
        Is the server running on host "my.second.machine" and
        accepting
        TCP/IP connections on port 5432?
; used connection string 'dbname=testdb user=perso
password=secret host=my.second.machine'