Re: Mac OS X Mavericks does not play nice with PostgreSQL 9.3.4

[Simon Wright <simon@pushface.org>]

ake.ragnar.dahlgren@gmail.com writes:

> To make a long story short I've managed to create the tables in the
> PostgreSQL database by exchanging the word "localhost" for 127.0.0.1:
> gnatcoll_db2ada -dbmodel=database_schema.txt -dbhost=127.0.0.1
> -dbport=5432 -dbname=hello -dbuser=postgres -dbpasswd=asdf -createdb
>
> Perhaps someone can verify that this does the trick?

I'm sure I tried that earlier! but it's fine now: having enabled
tracing, using Postgres.app, & with one of the examples from
gnatcoll. Perhaps 'localhost' is selecting the wrong transport layer?

$ ./gnatcoll_db2ada -dbhost=127.0.0.1 -dbport=5432 -dbname=hello -dbuser=simon -dbmodel=dbschema.txt -createdb
[SQL] 1/1 Connecting to the database dbname=hello user=simon host=127.0.0.1 port=5432 sslmode=allow ()
[SQL] 2/2 BEGIN (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 1/3 Finished executing query: 24.511000000 ms
   [SQL] 3/4 CREATE TABLE "customers" (
_SQL_  "id" SERIAL PRIMARY KEY NOT NULL,
_SQL_  "first" Text NOT NULL,
_SQL_  "last" Text NOT NULL) (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 2/5 Finished executing query: 863.374000000 ms
   [SQL] 4/6 CREATE TABLE "books" (
_SQL_  "pages" Integer DEFAULT 100,
_SQL_  "borrowed_by" Integer,
_SQL_  "id" SERIAL PRIMARY KEY NOT NULL,
_SQL_  "title" Text,
_SQL_  "author" Text,
_SQL_  "published" Date,
_SQL_  FOREIGN KEY ("borrowed_by") REFERENCES "customers" ("id")) (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 3/7 Finished executing query: 112.397000000 ms
   [SQL] 5/8 CREATE TABLE "dvds" (
_SQL_  "region" Integer DEFAULT 1,
_SQL_  "borrowed_by" Integer,
_SQL_  "id" SERIAL PRIMARY KEY NOT NULL,
_SQL_  "title" Text,
_SQL_  "author" Text,
_SQL_  "published" Date,
_SQL_  FOREIGN KEY ("borrowed_by") REFERENCES "customers" ("id")) (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 4/9 Finished executing query: 7.592000000 ms
   [SQL] 6/10 CREATE INDEX "customers_last_idx" ON "customers" ("last") (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 5/11 Finished executing query: 2.082000000 ms
   [SQL] 7/12 CREATE INDEX "books_borrowed_by_idx" ON "books" ("borrowed_by") (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 6/13 Finished executing query: 1.074000000 ms
   [SQL] 8/14 CREATE INDEX "dvds_borrowed_by_idx" ON "dvds" ("borrowed_by") (0 tuples) PGRES_COMMAND_OK
   [SQL.PERF] 7/15 Finished executing query: 1.251000000 ms
[SQL] 9/16 COMMIT (0 tuples) PGRES_COMMAND_OK
[SQL.PERF] 8/17 Finished executing query: 1138.720000000 ms