Обсуждение: Postmaster running, psql not

Поиск
Список
Период
Сортировка

Postmaster running, psql not

От
Roy MacGregor Paterson
Дата:
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
--------------------

Re: Postmaster running, psql not

От
Michael Grant
Дата:
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.


Re: Postmaster running, psql not

От
"Gerard Mason"
Дата:
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


Re: Postmaster running, psql not

От
"Marcus Andree S. Magalhaes"
Дата:
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)