    launchctl unload -w ~/Library/LaunchAgents/org.postgresql.postgres.plist
    rm ~/Library/LaunchAgents/org.postgresql.postgres.plist

Shutting down PostgreSQL Server with `-m immediate` is a dangerous way to do it,
because “Immediate” mode will abort all server processes without a clean shutdown.
 
This will lead to a recovery run on restart. Try to shutdown PostgreSQL with parameter `-m fast` instead. &quot;Fast” mode does not wait for clients to disconnect and will terminate an online backup in progress. All active transactions are rolled back and clients are forcibly disconnected

    pg_ctl stop -D /usr/local/var/postgres -m fast 

For more information about pg_ctl please visit
[http://www.postgresql.org/docs/9.0/static/app-pg-ctl.html][1]


  [1]: http://www.postgresql.org/docs/9.0/static/app-pg-ctl.html

This works for me 
&lt;pre&gt; &lt;code&gt;pg_ctl -D /Library/PostgreSQL/9.2/data/ start&lt;/pre&gt; &lt;/code&gt;
&lt;pre&gt; &lt;code&gt;pg_ctl -D /Library/PostgreSQL/9.2/data/ stop&lt;/pre&gt; &lt;/code&gt;

Source https://sites.google.com/site/amaosblog/database/postgresql/how-to-start-stop-postgresql-9-2-on-mac-os-x-10-8-x

If you used Homebrew to install postgresql, then as Shevauns comment on Greg&#39;s answer indicates, the correct procedure is 

    launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
    rm ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist



Is there a command in vim which will delete **n** lines in the up direction. 

I know I can use `4dd` which will delete 4 lines downwards.

Delete n lines in the up direction in vim

My company requires VPN to connect to our dev systems and for the first time I&#39;m trying to work on an android app from home.  Turns out the emulator doesn&#39;t want to use the VPN interface so even though I have connectivity to our dev systems on my VPN-connected laptop the emulator that&#39;s running on it does not.  

I have thought of 3 solutions to this:

 1. run a VPN client on the emulator, but I was hoping for a simpler solution [than that][1]
 2. setting up a proxy server on my local machine
 3. forwarding a port on my local machine

2 and 3 can probably work, but I&#39;d still like to know if there is an easy way to get the emulator to use the VPN interface without a workaround.

I&#39;m running OS X 10.7 and I&#39;ve already tried adjusting the interface priority order with network&gt;&gt;set service order.

I suppose I can dust off the old dell and try it there, but I would expect the same results.


  [1]: http://stackoverflow.com/questions/4590339/how-to-enable-vpn-support-in-android-emulator

How can I get my android emulator use my computer&#39;s VPN interface?

I installed PostgreSQL using Homebrew on Lion. It starts okay but wouldn&#39;t shutdown. I tried:

    $ #started with
    $ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
    $ #tried stoping with
    $ pg_ctl -D /usr/local/var/postgres stop -m immediate
    waiting for server to shut down................................... failed
    pg_ctl: server does not shut down

---

I fixed this issue by deleting the Launch Agent:

    launchctl unload -w ~/Library/LaunchAgents/org.postgresql.postgres.plist
    rm ~/Library/LaunchAgents/org.postgresql.postgres.plist



PostgreSQL server wouldn&#39;t shutdown on Lion (Mac OS 10.7)

I installed PostgreSQL using Homebrew on Lion. It starts okay but wouldn't shutdown. I tried:
<pre><code class="hljs language-shell">$ #started with
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
$ #tried stoping with
$ pg_ctl -D /usr/local/var/postgres stop -m immediate
waiting for server to shut down................................... failed
pg_ctl: server does not shut down
</code></pre>
<hr>
I fixed this issue by deleting the Launch Agent:
<pre><code class="hljs language-javascript">launchctl unload -w ~/Library/LaunchAgents/org.postgresql.postgres.plist
rm ~/Library/LaunchAgents/org.postgresql.postgres.plist
</code></pre>

I have an NSURL that looks like this:

&lt;pre&gt;file://localhost/Users/myuser/myfile.txt&lt;/pre&gt;

Is there a standard function to convert it to a local file path looking like this:

&lt;pre&gt;/Users/myuser/myfile.txt&lt;/pre&gt;



Convert NSURL to local file path

I have installed Jenkins executable on OSX, but now I want to stop it running. Whenever I kill it, no matter how, it just restarts immediately.

I&#39;ve tried using the exit command on the jenkins url:

    http://localhost:8080/exit

which asks me to post the command, which I do, and the server shuts down as requested. *But then it restarts.*

I&#39;ve tried searching for the process id using `ps`, and force killing it (`kill -9 pid`), and the server shuts down immediately, as requested. *But then it restarts.*

I&#39;ve tried shutting it down via the gui, but unfortunately there doesn&#39;t seem to be a way to do that.

There must be a daemon somewhere, making this a general OSX question. 

How to stop Jenkins installed on Mac Snow Leopard?

I would like to obtain my iPad&#39;s IP address programmatically.
How can I query the networking subsystem to find out what my IPv4 (and IPv6) addresses are?

PS: Can I disable IPv6 somehow?


How to get my IP address programmatically on iOS/macOS?

Is there a keyboard shortcut to move to the beginning of a file? I checked IntelliJ&#39;s [Keymap for Mac OS X][1] and it doesn&#39;t list anything for navigating to the start of a file.


  [1]: http://www.jetbrains.com/idea/documentation/index.jsp

IntelliJ beginning of file keyboard shortcut

Before upgrading to lion, I had tab complete working in a python shell via terminal. Following [these instructions][1], it was possible to have tab complete working.

Since upgrading to Lion, I am now unable to get tab complete working in a terminal session of Python. I&#39;ve followed the above instructions to the letter, and it still does not work.

Is there a difference with the readline module in Lion? Hooking in to the &#39;tab:complete&#39; option no longer seems to work. I&#39;m wondering if it is terminal that is ignoring readline, or if it is python itself.

Python version: 2.7.1


Edit:

By tab complete, I mean I could do something like the following:

    # django
    import MyModel
    MyModel.objects.a[TAB] # will complete to all()

  [1]: http://blog.e-shell.org/221

Python REPL tab completion on MacOS

Is there any way to write case-insensitive queries in PostgreSQL, E.g. I want that following 3 queries return same result.

    SELECT id FROM groups where name=&#39;administrator&#39;

    SELECT id FROM groups where name=&#39;ADMINISTRATOR&#39;

    SELECT id FROM groups where name=&#39;Administrator&#39;


How to make &quot;case-insensitive&quot; query in Postgresql?

I need to create, manage and drop schemas on the fly. If I go to create a schema that already exists, I want to (conditionally, via external means) drop and recreate it as specified. How can I check for the existence of said schema on my Postgres 9 server?

Currently, I&#39;m doing this:

    select exists (select * from pg_catalog.pg_namespace where nspname = &#39;schemaname&#39;);

but I feel like there&#39;s probably another way... is this the &quot;proper&quot; way to query Postgres for the existence of a particular schema?

Postgresql: Check if Schema Exists?

I&#39;m writing a Django-ORM enchancement that attempts to cache models and postpone model saving until the end of the transaction. It&#39;s all almost done, however I came across an unexpected difficulty in SQL syntax.

I&#39;m not much of a DBA, but from what I understand, databases don&#39;t really work efficiently for many small queries. Few bigger queries are much better. For example it&#39;s better to use large batch inserts (say 100 rows at once) instead of 100 one-liners.

Now, from what I can see, SQL doesn&#39;t really supply any statement to perform a batch update on a table. The term seems to be _confusing_ so, I&#39;ll explain what I mean by that. I have an array of arbitrary data, each entry describing a single row in a table. I&#39;d like to update certain rows in the table, each using data from its corresponding entry in the array. The idea is very similar to a batch insert. 

For example: My table could have two columns `&quot;id&quot;` and `&quot;some_col&quot;`. Now the array describing the data for a batch update consists of three entries `(1, &#39;first updated&#39;)`, `(2, &#39;second updated&#39;)`, and `(3, &#39;third updated&#39;)`. Before the update the table contains rows: `(1, &#39;first&#39;)`, `(2, &#39;second&#39;)`, `(3, &#39;third&#39;)`.

I came accross this post:

https://stackoverflow.com/questions/1006969/why-are-batch-inserts-updates-faster-how-do-batch-updates-work/1007006#1007006

which seems to do what I want, however I can&#39;t really figure out the syntax at the end.

I could also delete all the rows that require updating and reinsert them using a batch insert, however I find it hard to believe that this would actually perform any better.

I work with PostgreSQL 8.4, so some stored procedures are also possible here. However as I plan to open source the project eventually, any more portable ideas or ways to do the same thing on a different RDBMS are most welcome.

**Follow up question:** How to do a batch &quot;insert-or-update&quot;/&quot;upsert&quot; statement?

**Test results**

I&#39;ve performed 100x times 10 insert operations spread over 4 different tables (so 1000 inserts in total). I tested on Django 1.3 with a PostgreSQL 8.4 backend.

These are the results:

  * All operations done through Django ORM - each pass **~2.45 seconds**,
  * The same operations, but done without Django ORM - each pass **~1.48 seconds**,
  * Only insert operations, without querying the database for sequence values **~0.72 seconds**,
  * Only insert operations, executed in blocks of 10 (100 blocks in total) **~0.19 seconds**,
  * Only insert operations, one big execution block **~0.13 seconds**.
  * Only insert operations, about 250 statements per block, **~0.12 seconds**.

Conclusion: execute as many operations as possible in a single connection.execute(). Django itself introduces a substantial overhead.

Disclaimer: I didn&#39;t introduce any indices apart from default primary key indices, so insert operations could possibly run faster because of that.

Bulk/batch update/upsert in PostgreSQL

I&#39;m trying to drop my database and create a new one through the command line.

I log in using `psql -U username` and then do a `\connect template1`, followed by a `DROP DATABASE databasename;`.

I get the error
&gt;database databasename is being accessed by other users

I shut down Apache and tried this again but I&#39;m still getting this error. Am I doing something wrong?


PostgreSQL: Drop PostgreSQL database through command line

Entering the following command into a PostgreSQL interactive terminal results in an error:

    ALTER TABLE tbl_name ALTER COLUMN col_name varchar (11);

What is the correct command to alter the data type of a column?


How to alter a column&#39;s data type in a PostgreSQL table?

I&#39;m trying to install Imagemagick on OSX Lion but something is not working as expected.

    -&gt; brew install imagemagick

    /usr/local/git/bin/git
    ==&gt; Cloning https://github.com/adamv/ImageMagick.git
    Cloning into /Users/klebershimabuku/Library/Caches/Homebrew/imagemagick--git...
    fatal: https://github.com/adamv/ImageMagick.git/info/refs not found: did you run git      update-server-info on the server?
    Error: Failure while executing: git clone --depth 1 https://github.com/adamv/ImageMagick.git /Users/kleber/Library/Caches/Homebrew/imagemagick--git

brew doctor says:


    -&gt; brew doctor
    We couldn&#39;t detect gcc 4.0.x. Some formulae require this compiler.

    Some &quot;config&quot; scripts were found in your path, but not in system or Homebrew folders.

    `./configure` scripts often look for *-config scripts to determine if software packagesare installed, and what additional flags to use when compiling and linking.

    Having additional scripts in your path can confuse software installed via Homebrew if the config script overrides a system or Homebrew provided script of the same name.

    /Users/kleber/.rvm/gems/ruby-1.9.2-p180@global/bin
    passenger-config

    Setting DYLD_LIBARY_PATH can break dynamic linking.
    You should probably unset it.


And yes, I have XCode 4.1 installed and running.



    -&gt; brew update
    From http://github.com/mxcl/homebrew
    * branch            master     -&gt; FETCH_HEAD
    Already up-to-date.


How do I install imagemagick with homebrew?

I am getting this error on startup of Hadoop on OSX 10.7:

&gt; Unable to load realm info from SCDynamicStore
put: org.apache.hadoop.hdfs.server.namenode.SafeModeException: Cannot create directory /user/travis/input/conf. Name node is in safe mode.

It doesn&#39;t appear to be causing any issues with the functionality of Hadoop.

Hadoop on OSX &quot;Unable to load realm info from SCDynamicStore&quot;

**[edit]** I was troubleshooting problems with my development environment when I noticed one of my problems was the dependency on ImageMagick, since it&#39;s a vital part of my app.

---

After upgrading to OS X Lion (10.7) i no longer had ImageMagick available, i then tried installing again using MacPorts without success, i then installed from source, and the install wasn&#39;t very successfully i had convert and identify but it output error messages that i unfortunately dont have anymore, i by some strange reason decided to remove all of my MacPort libraries and started using Homebrew, i tried installing ImageMagick, it installs OK but when i try to use it throws this error

    dyld: Library not loaded: /opt/local/lib/libltdl.7.dylib
      Referenced from: /usr/local/bin/convert
      Reason: Incompatible library version: convert requires version 11.0.0 or later, but libltdl.7.dylib provides version 10.0.0
    Trace/BPT trap: 5

I read online but i have no clue on whats going on here, i found that libltdl is called libtool, and that i obviously need to upgrade it to a newer version, but i havent found any indication of how or where to find the source, or if this should be already be handled by homebrew and why it hasn&#39;t.

I tried installing ImageMagick again from source using [this installer script https://github.com/masterkain/ImageMagick-sl](https://github.com/masterkain/ImageMagick-sl) but when i try to use convert it throws a similar error.

    $ convert gnome.jpg -resize 50% gnome_.jpg
    dyld: Library not loaded: /opt/local/lib/libltdl.7.dylib
      Referenced from: /usr/local/bin/convert
      Reason: Incompatible library version: convert requires version 11.0.0 or later, but libltdl.7.dylib provides version 10.0.0
    Trace/BPT trap: 5

    $ which convert
    /usr/local/bin/convert

What can i do to solve my problem?

ImageMagick and OS X Lion trouble

When someone says &quot;edit your .plist file&quot; or &quot;your .profile&quot; or &quot;.bash_profile&quot; etc, this just confuses me. I have no idea where these files are, how to create them if I have to do that, etc, and also why there seem to be so many different ones (why? Do they do different things?)

So could someone please explain very patiently to a previous Windows user (wanting desperately to become more familiar with the pleasant if initially somewhat confusing OS X world) how to do this step by step?

I need the variables to be set both for GUI applications and command line applications, and at the moment it&#39;s for an ant script that needs the variables, but there will most likely be other needs as well.

Please note that I have Lion too, since many of the answers you get Googling seem to be outdated for Lion...

Also note that I have practically zero experience using the Terminal. I&#39;m willing to learn, but please explain for a novice...

Set environment variables on Mac OS X Lion

I have an application with a view-based `NSTableView` in it.  Inside this table view, I have rows that have cells that have content consisting of a multi-row `NSTextField` with word-wrap enabled.  Depending on the textual content of the `NSTextField`, the size of the rows needed to display the cell will vary. 
 
I know that I can implement the `NSTableViewDelegate` method -`tableView:heightOfRow:` to return the height, but the height will be determined based on the word wrapping used on the `NSTextField`.  The word wrapping of the `NSTextField` is similarly based on how wide the `NSTextField` is… which is determined by the width of the `NSTableView`.

Soooo… I guess my question is… what is a good design pattern for this?  It seems like everything I try winds up being a convoluted mess. Since the TableView requires knowledge of the height of the cells to lay them out... and the `NSTextField` needs knowledge of it&#39;s layout to determine the word wrap… and the cell needs knowledge of the word wrap to determine it&#39;s height… it&#39;s a circular mess… and it&#39;s driving me *insane*.

Suggestions?

If it matters, the end result will also have editable `NSTextFields` that will resize to adjust to the text within them.  I already have this working on the view level, but the tableview does not yet adjust the heights of the cells.  I figure once I get the height issue worked out, I&#39;ll use the -`noteHeightOfRowsWithIndexesChanged` method to inform the table view the height changed… but it&#39;s still then going to ask the delegate for the height… hence, my quandry.

Thanks in advance!


Content Type	Original Author	Original Content on Stackoverflow
Question	Greg	View Question on Stackoverflow
Solution 1 - Macos	Greg	View Answer on Stackoverflow
Solution 2 - Macos	francs	View Answer on Stackoverflow
Solution 3 - Macos	SathishVenkat	View Answer on Stackoverflow
Solution 4 - Macos	Obromios	View Answer on Stackoverflow

PostgreSQL server wouldn't shutdown on Lion (Mac OS 10.7)

Macos Problem Overview

Macos Solutions

Solution 1 - Macos

Solution 2 - Macos

Solution 3 - Macos

Solution 4 - Macos

How can I get my android emulator use my computer's VPN interface?

Delete n lines in the up direction in vim

Attributions