I have Postgresql 8 running on Windows 2000 Pro.  I copied my DB as
complete folders from one machine to the next.  Postgresql docs and
others say it should work as no Dump/Restore is required for version
8.

PgAdmin can see the Server and successfully start the server.

Connecting to the Server always results in:

'could not connect to server: Connection refused (0x0000274D/10061)
 is the server running on host "127.0.0.1" and accepting
 TCP/IP connections on Port 5432?'

What I've Done to Troubleshoot:

1) Tried inserting 'tcpip_socket = true' into postgresql.conf - then
the server wouldn't even start.  Removed it and server started but
still no connection.

2) Tried various changes is pg_hba.conf - but the current config
worked perfectly on the last machine.

3) I looked into the pg_ident.conf and I think this may be the key. 
On the old machine, the computer username and/or password may have
been different for the computer User account.  I'm not familiar with
mapping and wouldn't know what usernames/passwords to put where - but
this seems like it may be the area to focus on.

Question:  How should I proceed to solve this?

---

Request for Question Clarification by sublime1-ga on 09 Aug 2005 20:52 PDT

dhost...

Scroll down to the section on 'The pg_ident.conf file'
on this page. It spells out how to set up usernames:
http://www.faqs.org/docs/ppbook/c15679.htm

Let me know where this takes you...

sublime1-ga

---

Clarification of Question by dhost-ga on 10 Aug 2005 08:36 PDT

Thank you, but this didn't seem to get me there.