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(at)macgregortech(dot)com>
>>To: pgsql-novice(at)postgresql(dot)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(dot)org(at)localhost(dot)postgresql(dot)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(dot)org(at)localhost(dot)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)org>; Fri, 21 Nov 2003 15:10:02
>> +0000 (GMT)
>>X-Message-Info: N4u0pqWW+O3jMoUp4i3rSfKlzzl2zTxrTIPJEpa8dfg=
>>X-Original-To: pgsql-novice-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
>> X-Sender: hstee116(at)pencil(dot)red(dot)net
>>Message-Id: <p06010205bbe3db12c02e(at)[192(dot)168(dot)1(dot)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(at)postgresql(dot)org
>>Return-Path: pgsql-novice-owner+M8866(at)postgresql(dot)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(at)macgregortech(dot)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(at)postgresql(dot)org)