Обсуждение: BUG #6164: Flashing dialog
The following bug has been logged online: Bug reference: 6164 Logged by: Kyle Fox Email address: kyle.fox@gmail.com PostgreSQL version: 9.0 Operating system: Mac OSX 10.6.8 Description: Flashing dialog Details: I used the installer to install Postgres 9.0 on my Mac, and now every 10 seconds a dialog message flashes and immediately disappears, and STEALS FOCUS. My computer is completely unusable because of the installer. How do I fix this? I would like to uninstall postgres entirely. Here's the output from the Console.app: 11-08-15 9:24:04 PM Firewall[63] postgres is listening from 0.0.0.0:5432 proto=6 11-08-15 9:24:04 PM com.edb.launchd.postgresql-8.4[426] 2011-08-15 21:24:04 MDT FATAL: could not create shared memory segment: Cannot allocate memory 11-08-15 9:24:04 PM com.edb.launchd.postgresql-8.4[426] 2011-08-15 21:24:04 MDT DETAIL: Failed system call was shmget(key=5432001, size=32587776, 03600). 11-08-15 9:24:04 PM com.edb.launchd.postgresql-8.4[426] 2011-08-15 21:24:04 MDT HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 32587776 bytes), reduce PostgreSQL's shared_buffers parameter (currently 3584) and/or its max_connections parameter (currently 103). 11-08-15 9:24:04 PM com.edb.launchd.postgresql-8.4[426] The PostgreSQL documentation contains more information about shared memory configuration. 11-08-15 9:24:04 PM Firewall[63] postgres is listening from :::5432 proto=6 11-08-15 9:24:04 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[426]) Exited with exit code: 1 11-08-15 9:24:04 PM com.apple.launchd[1] (com.edb.launchd.postgresql-8.4) Throttling respawn: Will start in 10 seconds
On Mon, Aug 15, 2011 at 11:31 PM, Kyle Fox <kyle.fox@gmail.com> wrote: > I used the installer to install Postgres 9.0 on my Mac, and now every 10 > seconds a dialog message flashes and immediately disappears, and STEALS > FOCUS. The focus-stealing sounds like a problem coming from the EDB installer you said you used, and you'll have to complain to those folks about it. > My computer is completely unusable because of the installer. How do I fix > this? I would like to uninstall postgres entirely. > > Here's the output from the Console.app: > > 11-08-15 9:24:04 PM =A0 =A0 Firewall[63] =A0 =A0postgres is listening fro= m 0.0.0.0:5432 > proto=3D6 > 11-08-15 9:24:04 PM =A0 =A0 com.edb.launchd.postgresql-8.4[426] =A0 =A0 2= 011-08-15 21:24:04 > MDT FATAL: =A0could not create shared memory segment: Cannot allocate mem= ory > 11-08-15 9:24:04 PM =A0 =A0 com.edb.launchd.postgresql-8.4[426] =A0 =A0 2= 011-08-15 21:24:04 > MDT DETAIL: =A0Failed system call was shmget(key=3D5432001, size=3D325877= 76, > 03600). =46rom the logs you posted, it sounds like you simply need to adjust the shared memory segments documented here: http://www.postgresql.org/docs/current/static/kernel-resources.html See the "MacOS X" section on that page for OS X specific instructions. Josh
On Tue, Aug 16, 2011 at 8:11 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote: > On Mon, Aug 15, 2011 at 11:31 PM, Kyle Fox <kyle.fox@gmail.com> wrote: > >> I used the installer to install Postgres 9.0 on my Mac, and now every 10 >> seconds a dialog message flashes and immediately disappears, and STEALS >> FOCUS. > > The focus-stealing sounds like a problem coming from the EDB installer > you said you used, and you'll have to complain to those folks about > it. No it doesn't, unless the OP has found some weird bug in pgAdmin or StackBuilder. Sounds to me more like OSX is throwing the dialogue for some reason when the launch daemon tries to load the service. Try running: sudo launchctl unload /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4 That should stop it trying to start the server, at least until the next reboot (enough to hopefully see if the focus issue is resolved). To completely uninstall, use sudo open /Library/PostgreSQL/8.4/uninstall-postgresql.app/ -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Tue, Aug 16, 2011 at 8:24 PM, Dave Page <dpage@pgadmin.org> wrote: > On Tue, Aug 16, 2011 at 8:11 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote: >> On Mon, Aug 15, 2011 at 11:31 PM, Kyle Fox <kyle.fox@gmail.com> wrote: >> >>> I used the installer to install Postgres 9.0 on my Mac, and now every 10 >>> seconds a dialog message flashes and immediately disappears, and STEALS >>> FOCUS. >> >> The focus-stealing sounds like a problem coming from the EDB installer >> you said you used, and you'll have to complain to those folks about >> it. > > No it doesn't, unless the OP has found some weird bug in pgAdmin or > StackBuilder. For the benefit of the list archives, the OP just told me that the dialog responsible for steal focus was coming from his firewall. He's fixed that, and completed a fresh installation. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company