From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00
	autolearn=unavailable autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Simon Wright <simon@pushface.org>
Newsgroups: comp.lang.ada
Subject: Re: Mac OS X Mavericks does not play nice with PostgreSQL 9.3.4
Date: Tue, 25 Mar 2014 07:38:58 +0000
Organization: A noiseless patient Spider
Message-ID: <ly4n2mhgml.fsf@pushface.org>
References: <97e4ba0b-58a0-453f-8738-2c7de5c5286f@googlegroups.com>
	<lybnww1rhu.fsf@pushface.org>
	<f28e2d9a-84b2-4bc0-ab43-95c006f52ea4@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain
Injection-Info: mx05.eternal-september.org;
 posting-host="22d720de31fa36ffc68ccbe08d1f0c55";
	logging-data="15374"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX1/5oYHtzRCWqh/nm06jsS2SzKNIvBJ8+4c="
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (darwin)
Cancel-Lock: sha1:AekSbnrxvh2VuPfpLb8gCmeRbNY=
	sha1:7sp/RBgOHqgtQ2d7nyOJeBCt3m0=
Xref: news.eternal-september.org comp.lang.ada:18961
Date: 2014-03-25T07:38:58+00:00
List-Id: <comp.lang.ada>

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