"Richard Watt" <warren_tf_mcarthur@hotmail.com> writes:
> I tried to create a test database with createdb, and this is the message I get:
>
> createdb: could not connect to database template1: could not connect to server: Connection refused
> Is the server running on host <IP address> and accepting
> TCP/IP connections on port 5321?
Double check that the postmaster is really listening to 5321 and not
some other port ("netstat -l -n --inet" is a good way). It seems
possible there's a stray PGPORT setting somewhere you didn't notice.
If that's not it, I'd guess that the kernel's ipfilter rules are set to
reject traffic to 5321. You'll need to punch a hole in the firewall
rules.
In any case, "connection refused" is a kernel-level failure message;
your connection request did not get delivered to the postmaster at all.
So you should be looking at generic communications problems rather
than Postgres-specific ideas.
regards, tom lane