Re: Postmaster running, psql not

Just a thought: /usr/bin/psql does have the executable bit set, doesn't it?

Though I'm sure the format of the command is not the source of your
problems, I usually specify the database with -d (though I'm still stuck on
7.1.3, so what do I know?), so I'd have a line like:

psql -d databasename -U username


Cheers,
Gerard.


>From: Roy MacGregor Paterson <roy@macgregortech.com>
>To: pgsql-novice@postgresql.org
>Subject: [NOVICE] Postmaster running, psql not
>Date: Fri, 21 Nov 2003 15:09:20 +0000
>MIME-Version: 1.0
>Received: from mc8-f6.hotmail.com ([65.54.253.142]) by mc8-s21.hotmail.com
>with Microsoft SMTPSVC(5.0.2195.6713); Fri, 21 Nov 2003 07:15:23 -0800
>Received: from hosting.commandprompt.com ([207.173.200.224]) by
>mc8-f6.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 21 Nov 2003
>07:12:22 -0800
>Received: from postgresql.org (svr1.postgresql.org [200.46.204.71])by
>hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id hALF7jc00329;Fri,
>21 Nov 2003 07:07:46 -0800
>Received: from localhost (neptune.hub.org [200.46.204.2])by
>svr1.postgresql.org (Postfix) with ESMTP id 7BDF0D1D450for
><pgsql-novice-postgresql.org@localhost.postgresql.org>; Fri, 21 Nov 2003
>15:07:26 +0000 (GMT)
>Received: from svr1.postgresql.org ([200.46.204.71]) by localhost
>(neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id
>93565-05 for <pgsql-novice-postgresql.org@localhost.postgresql.org>; Fri,
>21 Nov 2003 11:06:59 -0400 (AST)
>Received: from smtp-1.griffin.com (unknown [217.79.96.165])by
>svr1.postgresql.org (Postfix) with ESMTP id 5EBCAD1B50Afor
><pgsql-novice@postgresql.org>; Fri, 21 Nov 2003 11:06:55 -0400 (AST)
>Received: from [192.168.1.102] (213.177.251.70.adsl.griffin.net.uk
>[213.177.251.70])by smtp-1.griffin.com (Postfix) with ESMTP id
>79AE1258017for <pgsql-novice@postgresql.org>; Fri, 21 Nov 2003 15:10:02
>+0000 (GMT)
>X-Message-Info: N4u0pqWW+O3jMoUp4i3rSfKlzzl2zTxrTIPJEpa8dfg=
>X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org
>X-Sender: hstee116@pencil.red.net
>Message-Id: <p06010205bbe3db12c02e@[192.168.1.102]>
>X-GIS-smtp-1-MailScanner-Information: Please contact the ISP for more
>information
>X-GIS-smtp-1-MailScanner: Found to be clean from viruses
>X-GIS-smtp-1-MailScanner-SpamCheck: not spam, SpamAssassin
>(score=0,required 6.5)
>X-Virus-Scanned: by amavisd-new at postgresql.org
>X-Mailing-List: pgsql-novice
>Precedence: bulk
>Sender: pgsql-novice-owner@postgresql.org
>Return-Path: pgsql-novice-owner+M8866@postgresql.org
>X-OriginalArrivalTime: 21 Nov 2003 15:12:24.0935 (UTC)
>FILETIME=[DE886770:01C3B041]
>
>Hi guys and gals,
>
>I'm a pgsql newbie, starting from scratch, can't get past second post:
>help.
>
>Environment is like this...
>MacOS X Jaguar
>PowerBook G4
>Installed PG v7.3.3 from Entropy package as per website instructions
>Installed Aqua Studio GUI
>Reading Practical PostgreSQL, O'Reilly
>Reading Unix for MacOS X, O'Reilly
>(typical mac user: can spell gui but not unix)
>
>Am able to fire up pg in Terminal with...
>
>/usr/local/bin/pg_ctl -D /usr/local/pgsql/data start
>"postmaster successfully started"
>
>and shut it down again with...
>
>/usr/local/bin/pg_ctl -D /usr/local/pgsql/data stop -m smart
>"postmaster successfully shut down"
>
>(No environment variables set yet)
>
>Directory looks like this...
>[MacGregor:/usr] postgres% ls /usr/local/bin
>bdftops             gsbj                pg_config           postmaster
>clusterdb           gsdj                pg_controldata      printafm
>createdb            gsdj500             pg_ctl              ps2ascii
>createlang          gslj                pg_dump             ps2epsi
>createuser          gslp                pg_dumpall          ps2pdf
>dropdb              gsnd                pg_encoding         ps2pdf12
>droplang            initdb              pg_id               ps2pdf13
>dropuser            initlocation        pg_resetxlog        ps2pdfwr
>dvipdf              ipcclean            pg_restore          ps2ps
>ecpg                lprsetup.sh         pgtclsh             psql
>eps2eps             pdf2dsc             pj-gs.sh            pv.sh
>fixmswrd.pl         pdf2ps              pltcl_delmod        sysvlp.sh
>font2c              pdfopt              pltcl_listmod       unix-lpr.sh
>gimpprint-config    pf2afm              pltcl_loadmod       vacuumdb
>gs                  pfbtopfa            postgres            wftopfa
>
>
>OK. So it looks like psql is installed, but when I enter the connection
>command so that I can call createdb...
>[MacGregor:~] postgres% psql -U manager template1 (straight from the book)
>
>I get...
>psql: Command not found.
>
>Also tried to connect via Acqua Studio GUI: Register Server but it wouldn't
>connect: "...is TCP/IP set up?...". Which is standard in the Entropy pkg I
>believe. Not really sure what to enter as params for PGSQL anyway.
>
>Doh! what now? Anyone around in West London UK care to swap knowledge for
>alcohol?
>
>MTIA,
>Roy
>--
>--------------------
>Roy MacGregor Paterson
>MacGregorTech
>
>t: +44 (0) 20 7584 7891
>f: +44 (0) 20 7589 6223
>m: +44 (0) 7803 163 938
>w: www.macgregortech.com
>e: roy@macgregortech.com
>--------------------
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger