pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedI can't get postgres started.
4+ messages / 3 participants
[nested] [flat]
* I can't get postgres started.
@ 2010-10-01 04:10 Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 2 replies; 4+ messages in thread
From: Tena Sakai @ 2010-10-01 04:10 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I can't get postgres started.
@ 2010-10-01 05:14 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
1 sibling, 0 replies; 4+ messages in thread
From: Devrim GÜNDÜZ @ 2010-10-01 05:14 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-admin
On Thu, 2010-09-30 at 21:10 -0700, Tena Sakai wrote:
> 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?
Did you change the port number in postgresql.conf? Specifying
--with-pgport only embeds port number to binaries, not to
postgresql.conf.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I can't get postgres started.
@ 2010-10-01 06:38 Kenichiro Tanaka <ketanaka@ashisuto.co.jp>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
1 sibling, 1 reply; 4+ messages in thread
From: Kenichiro Tanaka @ 2010-10-01 06:38 UTC (permalink / raw)
To: pgsql-admin
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_
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I can't get postgres started.
@ 2010-10-01 17:46 Tena Sakai <tsakai@gallo.ucsf.edu>
parent: Kenichiro Tanaka <ketanaka@ashisuto.co.jp>
0 siblings, 0 replies; 4+ messages in thread
From: Tena Sakai @ 2010-10-01 17:46 UTC (permalink / raw)
To: Kenichiro Tanaka <ketanaka@ashisuto.co.jp>; pgsql-admin
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@gallo.ucsf.edu
On 9/30/10 11:38 PM, "Kenichiro Tanaka" <ketanaka@ashisuto.co.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@gallo.ucsf.edu_
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-10-01 17:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-01 04:10 I can't get postgres started. Tena Sakai <tsakai@gallo.ucsf.edu>
2010-10-01 05:14 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-01 06:38 ` Kenichiro Tanaka <ketanaka@ashisuto.co.jp>
2010-10-01 17:46 ` Tena Sakai <tsakai@gallo.ucsf.edu>
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