Обсуждение: Postmaster running, psql not
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 --------------------
On Nov 21, 2003, at 9:09 AM, Roy MacGregor Paterson wrote: > 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. You either need to add /usr/local/bin to your search path (how you do that depends on which shell you're using) or specify the full path to /usr/local/bin/psql . Michael -- The government doesn't want you to know... e-mail doesn't work. At all. It's a scientific impossibility.
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
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)