Message-ID: <4CA581DA.5010009@ashisuto.co.jp>
Date: Fri, 01 Oct 2010 15:38:18 +0900
From: Kenichiro Tanaka <ketanaka@ashisuto.co.jp>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ja;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: I can't get postgres started.
References: <C8CAAD56.C89A%tsakai@gallo.ucsf.edu>
In-Reply-To: <C8CAAD56.C89A%tsakai@gallo.ucsf.edu>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

Hello

If  your listen_addresses is wrong,the same error can occur.

example)
$ cat postgresql.conf |grep listen_addresses
#listen_addresses = '*'         # what IP address(es) to listen on;
$ psql -h 192.168.23.133
psql: could not connect to server: Connection refused
         Is the server running on host "192.168.23.133" and accepting
         TCP/IP connections on port 1844?

Is your listen_addresses  right?


(2010/10/01 13:10), Tena Sakai wrote:
> Hi everybody,
>
> Sorry, I previously didn’t put subject line.
>
> I recently built postgres 8.4.4 from source and tested it.
> It seemed to work fine then, but I cannot seem to run psql
> today.  I built it to run on port 6543.  Do I need to specify the
> port number when I start it?
>
> Here’s the session dialog:
>
>   bash-3.2$ pg_ctl stop -D /usr/local/pgsql/data
>   LOG:  received smart shutdown request
>   LOG:  autovacuum launcher shutting down
>   LOG:  shutting down
>   waiting for server to shut down....LOG:  database system is shut down
>    done
>   server stopped
>   bash-3.2$
>
>   bash-3.2$ pg_ctl start -D /usr/local/pgsql/data
>   server starting
>   bash-3.2$ LOG:  database system was shut down at 2010-09-30 20:38:47 PDT
>   LOG:  autovacuum launcher started
>   LOG:  database system is ready to accept connections
>   bash-3.2$
>
>   bash-3.2$ psql canon
>   psql: could not connect to server: Connection refused
>         Is the server running on host "172.16.0.151" and accepting
>         TCP/IP connections on port 6543?
>   bash-3.2$
>
> Thank you for your help.
>
> Regards,
>
> Tena Sakai
> _tsakai@gallo.ucsf.edu_