Postmaster running, psql not SOLVED

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(at)macgregortech(dot)com
--------------------