Nat! bio photo

Nat!

Senior Mull.

Twitter RSS

Github

Snow Leopard: That's not my Unix anymore...

I have this peculiar problem, that Postgres installs OK, but later can't really access it's database. The symptoms are peculiar:

$ ls -ld Postgres
drwx------  19 nat  staff  646 11 Sep 00:18 Postgres
$ sudo ls -ld Postgres
Password:
drwx------  19 _unknown  _unknown  646 11 Sep 00:18 Postgres
$ sudo su postgres -c 'ls -ld Postgres'
drwx------  19 postgres  daemon  646 11 Sep 00:18 Postgres

or

$ ls -ldn Postgres
drwx------  19 955  20  646 11 Sep 00:18 Postgres
$ sudo ls -ldn Postgres
drwx------  19 99  99  646 11 Sep 00:18 Postgres
$ sudo su postgres -c 'ls -ldn Postgres'
drwx------  19 956  1  646 11 Sep 00:18 Postgres

I don't see the advantage offhand of ls lying to me about the ownership of the file. Also it would appear that, Postgres shouldn't really mind, but nevertheless it does.


3 Comments

A photo of David Buxton

From: David Buxton

Could your directory be on an external disc that's set to ignore ownership?

A photo of David Buxton

From: David Buxton

Here's a post that describes the behaviour in detail: http://googlemac.blogspot.com/2007/03/user-99-unknown.html

A photo of Nat!

From: Nat!

Yes. Indeed the internal disc is set to ignore ownership. I suspect, this happened because I probably installed Snöw Leopard first onto an external disc, that I then placed into the machine.

Thanks for the solution.

Post a comment

All comments are held for moderation; basic HTML formatting accepted.

Name:
E-mail: (not published)
Website: