Re: I can't get postgres started.

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 = 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(at)gallo(dot)ucsf(dot)edu

On 9/30/10 11:38 PM, "Kenichiro Tanaka" <ketanaka(at)ashisuto(dot)co(dot)jp> wrote:

> 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(at)gallo(dot)ucsf(dot)edu_
>
>