Newsroom Update

Beginning in May, a special Today at Apple series titled “Made for Business” will offer small business owners and entrepreneurs free opportunities to learn how Apple products and services can support their growth and success. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

PostgreSQL is not migrated?

After Today I found out that I have a problem with the new OSX Maverick Server.

The postgresql database is not running.

I checked with the following command:

"psql postgres -U _postgres -h "/Library/Server/PostgreSQL For Server Services/Socket"

the response from the server was:

psql: could not connect to server: No such file or directory

Is the server running locally and accepting

connections on Unix domain socket "/Library/Server/PostgreSQL For Server Services/Socket/.s.PGSQL.5432"?

When I checked the Migration files inside the

/Library/Server/PostgreSQL/Migration

I noticed that the migration was not successfully completed.

cat pg_upgrade_restore.log

last entry shows:

ALTER TABLE ONLY ir_act_url INHERIT ir_actions;

psql:pg_upgrade_dump_db.sql:24582: ERROR: column "name" in child table must be marked NOT NULL