Thread: 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 --------------------
Thanks for the responses on this issue. Now up and running, errrr staggering, with PG on MacOS X. The problem with connecting to Acqua Studio was solved by searching the PG archives. In the standard Entropy/Mac OS X build, allowing connections via TCP/IP is switched off, and the PG documentation is not at all clear on how to invoke the option. Merely using -i, as implied, doesn't work in the command-line, as a few other frustrated newbies have discovered. Firstly, you have to precede the TCP/IP option -i with the Option option -o, to tell pg_ctl that you are using options. This does seem slightly perverse to me. Secondly, you have to enclose the TCP/IP option in single quotes. Thirdly, you have to put these options in the correct place relative to the start command. This gets you going... /usr/local/bin/pg_ctl -D /usr/local/pgsql/data -o '-i' start ...or... pg_ctl -o '-i' start ...once you get the hang of environment variables (see my other postings). Alternatively, the build setting itself, in the file postgresql.conf, could be changed from tcpip_socket = false to tcpip_socket = true. 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 --------------------