Visite Webhosting Latino, el site sobre alojamiento web.
Postmaster running, psql not - Mombu the Programming Forum
Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > Postmaster running, psql not
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 30th April 19:59
External User
Posts: 1
Default 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 pgtclsh psql
eps2eps pdf2dsc pdf2ps pltcl_delmod
font2c pdfopt pltcl_listmod
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: " 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?

Roy MacGregor Paterson

t: +44 (0) 20 7584 7891
f: +44 (0) 20 7589 6223
m: +44 (0) 7803 163 938

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
  Reply With Quote

  sponsored links

2 30th April 19:59
External User
Posts: 1
Default Postmaster running, psql not

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 .


The government doesn't want you to know... e-mail doesn't work. At all.
It's a scientific impossibility.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
  Reply With Quote

  sponsored links

3 30th April 20:00
External User
Posts: 1
Default Postmaster running, psql not

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


__________________________________________________ _______________
Use MSN Messenger to send music and pics to your friends

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
  Reply With Quote
4 30th April 20:00
External User
Posts: 1
Default 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:


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to so that your
message can get through to the mailing list cleanly
  Reply With Quote

Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -