From: Kenichiro Tanaka <ketanaka@ashisuto.co.jp>
To: pgsql-admin@postgresql.org
Subject: Re: I can't get postgres started.
Date: Fri, 01 Oct 2010 15:38:18 +0900
Message-ID: <4CA581DA.5010009@ashisuto.co.jp> (raw)
In-Reply-To: <C8CAAD56.C89A%tsakai@gallo.ucsf.edu>
References: <C8CAAD56.C89A%tsakai@gallo.ucsf.edu>
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_
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ketanaka@ashisuto.co.jp
Subject: Re: I can't get postgres started.
In-Reply-To: <4CA581DA.5010009@ashisuto.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox