Re: Postmaster running, psql not

Having a powerbook running Jaguar myself, I know that
/usr/local/bin isn't included on PATH variable.

Check if psql starts with a fully quallified path:

/usr/local/bin/psql


> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)