I THINK I have PostgreSQL running correctly on my box: I have a PID and I see that postgres is "listening" on port 5432.
I'm trying to create a DB to experiment with, using the "Book" db outlined in C. Fehily's book "Visual Quickstart SQL".
I've tried a bunch of approaches, but have had no joy. Latest approach is:
$ su postgres Password: postgres@piglet:/etc$ createdb books createdb: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? postgres@piglet:/etc$
I'm not sure if I'm hitting the wall on passwords or authorizations, or something else. I'd sure welcome some suggestions. Thanks in advance!