Fwd: No connection could be made because the target machine actively refused it...

Hi Amit,

Yes, you're absolutely right. I was running the commands in psql rather
than the shell.
It wasn't obvious from the tutorial that I was following that I was
supposed to run the pg_restore command from the shell and not psql.
Strange that running that command in psql never gave me any form of error
and that the log was showing an error of 'No connection could be made
because the target machine actively refused it'.
Anyway, I can run queries now and I'm starting to get acquainted with the
environment, so thanks very much for your help.

Regards,
Frank.

---------- Forwarded message ----------
From: Amit Langote <amitlangote09(at)gmail(dot)com>
Date: 31 May 2013 05:10
Subject: Re: [NOVICE] No connection could be made because the target
machine actively refused it...
To: Frank Moore <francis(dot)moore(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>

> postgres# CREATE DATABASE dvdrental;
> postgres# pg_restore --dbname=dvdrental --verbose dvdrental.tar
>

It appears that you are running pg_restore inside psql. Have you tried
running it in shell and not psql?

--
Amit Langote