Postmaster running, psql not

From: Roy MacGregor Paterson <roy(at)macgregortech(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postmaster running, psql not
Date: 2003-11-21 14:48:34
Message-ID: p06010201bbe3d0223003@[192.168.1.102]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
--------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Roy MacGregor Paterson 2003-11-21 15:09:20 Postmaster running, psql not
Previous Message Vellinga, Fred 2003-11-21 08:54:36 addnew in combination with Limt