Device manager and Postgresql error message loop

Question

Level 1

0 points

Device manager and Postgresql error message loop

Hello,

I'm on MBP 7,1, 2.4GHz Intel Core 2 Duo, 4GB DDR3 Ram, 500GB hard drive with Lion. After the v10.7.3 update, the console has been putting a looping error message regarding Device manager and PostGre SQL (below). Can anyone help?

23/02/12 12:47:07.662 PM com.apple.launchd: (org.postgresql.postgres[1110]) Exited with code: 2
23/02/12 12:47:07.662 PM com.apple.launchd: (org.postgresql.postgres) Throttling respawn: Will start in 10 seconds
23/02/12 12:47:13.834 PM com.apple.devicemanager: DEBUG: Initializing DeviceManagerDaemon with ports 3320,3321,3322,3323 (physmem = 4GB)
23/02/12 12:47:13.834 PM com.apple.devicemanager: DEBUG: Making sure Rails is configured properly
23/02/12 12:47:13.834 PM com.apple.devicemanager: DEBUG: Running rake command: /usr/bin/rake db:migrate
23/02/12 12:47:15.044 PM ruby: Unable to create ProfileManager log file at '/var/log/devicemgr/profilemanager.log' (No such file or directory)
23/02/12 12:47:15.044 PM ProfileManager: Unable to create ProfileManager log file at '/var/log/devicemgr/profilemanager.log' (No such file or directory)
23/02/12 12:47:15.045 PM com.apple.devicemanager: Feb 23 12:47:15 Computer.local ProfileManager[1116] <Error>: Unable to create ProfileManager log file at '/var/log/devicemgr/profilemanager.log' (No such file or directory)
23/02/12 12:47:16.449 PM com.apple.devicemanager: rake aborted!
23/02/12 12:47:16.449 PM com.apple.devicemanager: could not connect to server: No such file or directory
23/02/12 12:47:16.449 PM com.apple.devicemanager:           Is the server running locally and accepting
23/02/12 12:47:16.449 PM com.apple.devicemanager:           connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
23/02/12 12:47:16.450 PM com.apple.devicemanager: (See full trace by running task with --trace)
23/02/12 12:47:16.461 PM com.apple.devicemanager: (in /usr/share/devicemgr/backend)
23/02/12 12:47:16.470 PM com.apple.devicemanager: /usr/share/devicemgr/backend/devicemgrd:109:in `rake': Rake command failed with 256 (RuntimeError)
23/02/12 12:47:16.470 PM com.apple.devicemanager:           from /usr/share/devicemgr/backend/devicemgrd:103:in `setupRails'
23/02/12 12:47:16.470 PM com.apple.devicemanager:           from /usr/share/devicemgr/backend/devicemgrd:33:in `run'
23/02/12 12:47:16.470 PM com.apple.devicemanager:           from /usr/share/devicemgr/backend/devicemgrd:131
23/02/12 12:47:16.470 PM com.apple.launchd: (com.apple.devicemanager[1114]) Exited with code: 1
23/02/12 12:47:16.470 PM com.apple.launchd: (com.apple.devicemanager) Throttling respawn: Will start in 8 seconds
23/02/12 12:47:17.682 PM org.postgresql.postgres: postgres_real cannot access the server configuration file "/var/pgsql/postgresql.conf": No such file or directory
23/02/12 12:47:17.682 PM com.apple.launchd: (org.postgresql.postgres[1117]) Exited with code: 2
23/02/12 12:47:17.682 PM com.apple.launchd: (org.postgresql.postgres) Throttling respawn: Will start in 10 seconds
23/02/12 12:47:24.482 PM com.apple.devicemanager: DEBUG: Initializing DeviceManagerDaemon with ports 3320,3321,3322,3323 (physmem = 4GB)
23/02/12 12:47:24.483 PM com.apple.devicemanager: DEBUG: Making sure Rails is configured properly
23/02/12 12:47:24.483 PM com.apple.devicemanager: DEBUG: Running rake command: /usr/bin/rake db:migrate
23/02/12 12:47:25.718 PM ruby: Unable to create ProfileManager log file at '/var/log/devicemgr/profilemanager.log' (No such file or directory)
23/02/12 12:47:25.718 PM ProfileManager: Unable to create ProfileManager log file at '/var/log/devicemgr/profilemanager.log' (No such file or directory)
23/02/12 12:47:25.718 PM com.apple.devicemanager: Feb 23 12:47:25 Computer.local ProfileManager[1121] <Error>: Unable to create ProfileManager log file at '/var/log/devicemgr/profilemanager.log' (No such file or directory)

MacBook Pro, Mac OS X (10.7), 2.4GHz Intel Core 2 Duo, 4 GB RAM

Posted on Feb 22, 2012 6:34 PM

Reply

Answer 1

Feb 22, 2012 7:01 PM in response to Tony_S_NZ

Tony ...

If you are syncing iOS devices such as iPad's, iPhone's, or an iPod touch with your Mac using iTunes, before you disconnect the device from the Mac, right or control click the device under Devices left side of the iTunes window then click: Eject then disconnect the device.

Reply

Answer 2

Tony_S_NZ Author

Level 1

0 points

Feb 22, 2012 8:09 PM in response to Carolyn Samit

Thanks for your reply. I have followed your advice and eject the iDevice after syncing with iTunes and still the same errors messages show up on Console.

Reply

Answer 3

Mar 30, 2012 12:46 AM in response to Tony_S_NZ

Sorry to say I can offer no help but I too have this problem...

Do you have Lion Server by any chance?

Have you managed to resolve this issue yourself?

I think this is the problem behind App Store no longer downloading for me...

TIA

-- Martin

Reply

Answer 4

Tony_S_NZ Author

Level 1

0 points

Mar 30, 2012 2:19 AM in response to martin.dowie

Yes, I'm using Server and yes, it's still looping like mad.

Reply

Answer 5

Apr 15, 2012 2:08 AM in response to Tony_S_NZ

I've just bitten the bullet, saved all my apps, docs and data onto a couple of external drives, reformatted the system disk, then re-installed Lion from the recovery partition...all back and working again!! :-)

I think my initial install of Server didn't work...can't remember the errors but I'm pretty certain there were a few.

On the plus side, you can just drag apps back into the Applications folder and Lion picks them up - no need for the original .dmg or disks.

HTH

-- Martin

Reply

Answer 6

Apr 15, 2012 2:09 AM in response to martin.dowie

Oh, and Mail comes with an export/import facility, so you can save incoming, outgoing and notes and get them back too quite easily.

-- Martin

Reply

Answer 7

Tony_S_NZ Author

Level 1

0 points

Apr 15, 2012 2:15 AM in response to martin.dowie

If this was another time, I would have reinstall the OS before I hit the community boards. But so far, besides the looping error on console, it hasn't caused any external or internal problems. All my office apps works fine. Even with the full install of the last released SP the looped error is still there so I'm just going to shut down this thread and leave the server app well alone. Thanks for your help.

Reply

Answer 8

cadeon

Level 1

0 points

May 14, 2012 11:31 PM in response to martin.dowie

I just did a clean install of Lion, and then did the Server install from the app store... and my /var/pgsql folder is completely empty. Seems to me this loop is caused by exactly what console says, a missing postgres config file.

Does anyone have a copy of

/var/pgsql/postgresql.conf

they can post here? Are there any other files in /var/pgsql by default?

Reply

Answer 9

Jun 5, 2012 11:43 AM in response to cadeon

Same problem here .. /var/pgsql folder is empty.

Installed Server on my MBP specifically to get the Wiki and I've been going through a lot of pain trying to get back to a clean working state on Apache. And of course, Wiki won't work without Postgres ... grrrrr ...

I'm tempted to pick up a generic postgresql.conf, but I'm sure Apple has "tuned" it with some OSX specific settings.

Be curious if anyone's found a solution

Reply

Answer 10

cadeon

Level 1

0 points

Jun 5, 2012 11:52 AM in response to martinfromwestford

The way I solved it, weirdly, was to install lion server on my MacBook- that install had a full /var/pgsql directory, so I copied it over.

No, I have no idea why my clean install had an empty folder, but the macbook install had a correct one.

Reply

Answer 11

jrw429

Level 1

1 points

Mar 4, 2013 1:13 PM in response to Tony_S_NZ

In case anyone else comes here looking for a solution,and the above doesn't work for them. I was trying to resolve the repeated instances of this in my log file, plus the effects of not having postgres running. I'm on OS X Lion Server, 10.7.5, on an XServe.

org.postgresql.postgres[18789]: postgres_real cannot access the server configuration file "/var/pgsql/postgresql.conf": No such file or directory

com.apple.launchd[1] (org.postgresql.postgres[18789]): Exited with code: 2

com.apple.launchd[1] (org.postgresql.postgres): Throttling respawn: Will start in 10 seconds

I ran these commands:

sudo chmod 777 /var

sudo mv /var/pgsql /var/pgsql.OLD

sudo -u _postgres /usr/bin/pg_ctl initdb -D /var/pgsql

sudo chmod 755 /var

This initialized the postgres setup and everything seems to be running happily now.

Reply

Answer 12

Sep 5, 2013 7:18 PM in response to jrw429

Thank you for that, solved the problem immediately.🙂

Reply

Answer 13

Oct 6, 2013 12:18 PM in response to jrw429

Thank you, jrw429.

Reply

Answer 14

May 28, 2016 9:31 PM in response to jrw429

Nice job jrw429! Your terminal commands worked perfectly for me!

Reply