On Nov 27, 2006, at 10:41 AM, Tony Caduto wrote:
I then updated the postgresql.conf file with "listen_addresses =
'*' and changed the port from 5432 (currently being used for a 7.3
server) to 5435.
Have you tried setting the port back to default and see what happens?
Is it possible for you to stop the 7.3 server for a moment to test
this theory?
The only thing you have different is the port, so I am thinking
that it has something to do with that.
Hmm... are you sure there isn't already something listening on port
5435?
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match