Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 487911337B52 for ; Fri, 1 Oct 2010 01:10:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 30178-08 for ; Fri, 1 Oct 2010 04:10:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.egcrc.net (mail.egcrc.net [63.193.204.10]) by mail.postgresql.org (Postfix) with ESMTP id 8D88A1335B36 for ; Fri, 1 Oct 2010 01:10:13 -0300 (ADT) Received: from EGCRC-EX04.egcrc.org ([::1]) by EGCRC-EX03.egcrc.org ([::1]) with mapi; Thu, 30 Sep 2010 21:09:55 -0700 From: Tena Sakai To: "pgsql-admin@postgresql.org" Date: Thu, 30 Sep 2010 21:06:51 -0700 Subject: Thread-Topic: Thread-Index: ActhHhM+tf39ZDvZRgGtUG3+Mgen8Q== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-Entourage/13.4.0.100208 acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_C8CAAC6BC896tsakaigalloucsfedu_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201010/1 X-Sequence-Number: 35742 --_000_C8CAAC6BC896tsakaigalloucsfedu_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi everybody, 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=92s 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 --_000_C8CAAC6BC896tsakaigalloucsfedu_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi everybody,

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=92s 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 i= s 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-3= 0 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 ho= st "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
--_000_C8CAAC6BC896tsakaigalloucsfedu_--