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 Postgresor
$ 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 PostgresI 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.
Comments (3)
Could your directory be on an external disc that's set to ignore ownership?
Posted by David Buxton
|
September 11, 2009 11:29 AM
Posted on September 11, 2009 11:29
Here's a post that describes the behaviour in detail: http://googlemac.blogspot.com/2007/03/user-99-unknown.html
Posted by David Buxton
|
September 11, 2009 11:33 AM
Posted on September 11, 2009 11:33
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.
Posted by Nat!
|
September 13, 2009 3:49 PM
Posted on September 13, 2009 15:49