From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: Kenichiro Tanaka <ketanaka@ashisuto.co.jp>, "pgsql-admin@postgresql.org"
	<pgsql-admin@postgresql.org>
Date: Fri, 1 Oct 2010 10:46:11 -0700
Subject: Re: I can't get postgres started.
Thread-Topic: [ADMIN] I can't get postgres started.
Thread-Index: ActheLvl1e6MYYGqQ62qoSY2FBGNBwAF8z9l
Message-ID: <C8CB6C73.C8C4%tsakai@gallo.ucsf.edu>
In-Reply-To: <4CA581DA.5010009@ashisuto.co.jp>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-Entourage/13.4.0.100208
acceptlanguage: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi Devrim,
Hi Kenichiro,

Thank you!

> Did you change the port number in postgresql.conf? Specifying
> --with-pgport only embeds port number to binaries, not to
> postgresql.conf.

In my postgresql.conf there was a line
  port =3D 6543
But it was commented out.  I took the # out.

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

My listen_address was set as localhost (and also commented
out, which I decommented), but my PGHOST environment variable
was set as machine.  I fixed PGHOST as localhost.

With these two fixes it is now working.

Thank you again.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu


On 9/30/10 11:38 PM, "Kenichiro Tanaka" <ketanaka@ashisuto.co.jp> wrote:

> Hello
>=20
> If  your listen_addresses is wrong,the same error can occur.
>=20
> example)
> $ cat postgresql.conf |grep listen_addresses
> #listen_addresses =3D '*'         # 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?
>=20
> Is your listen_addresses  right?
>=20
>=20
> (2010/10/01 13:10), Tena Sakai wrote:
>> Hi everybody,
>>=20
>> Sorry, I previously didn=B9t put subject line.
>>=20
>> 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?
>>=20
>> Here=B9s the session dialog:
>>=20
>>   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$
>>=20
>>   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 P=
DT
>>   LOG:  autovacuum launcher started
>>   LOG:  database system is ready to accept connections
>>   bash-3.2$
>>=20
>>   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$
>>=20
>> Thank you for your help.
>>=20
>> Regards,
>>=20
>> Tena Sakai
>> _tsakai@gallo.ucsf.edu_
>=20
>=20