This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.
First let's check something.
brew info postgresqlThe top of what gets printed as a result is the most important:
| #!/bin/bash | |
| # herein we backup our indexes! this script should run at like 6pm or something, after logstash | |
| # rotates to a new ES index and theres no new data coming in to the old one. we grab metadatas, | |
| # compress the data files, create a restore script, and push it all up to S3. | |
| TODAY=`date +"%Y.%m.%d"` | |
| INDEXNAME="logstash-$TODAY" # this had better match the index name in ES | |
| INDEXDIR="/usr/local/elasticsearch/data/logstash/nodes/0/indices/" | |
| BACKUPCMD="/usr/local/backupTools/s3cmd --config=/usr/local/backupTools/s3cfg put" | |
| BACKUPDIR="/mnt/es-backups/" | |
| YEARMONTH=`date +"%Y-%m"` |
| 0 - Read http://blog.databigbang.com/running-your-own-anonymous-rotating-proxies/ | |
| 1 - Install monit, haproxy, tor and delegated. | |
| 2 - Setup your environment in the setup.rb file | |
| 3 - Just run > ruby setup.rb | |
| 4 - ........... | |
| 5 - PROFIT! > http://www.southparkstudios.com/clips/151040/the-underpants-business |
Author: Michael van Rooijen (@mrrooijen)
DISCLAIMER: I am a programmer, not a sysadmin in my day-to-day life. I provide this guide simply as a self-reference, and as a way to contribute to the community of developers. The main motivation for writing this guide is because of the lack of properly written guides/tutorials. They were either out-dated, inaccurate, in a non-English language or simply too vague to understand (at least for me, as a programmer and not a sysadmin).
I hope this guide helps getting you up and running with your own collection of VPS's on your own Dedicated Server over at Hetzner.de.
Requirements:
| It is a rite of passage to post one's successful build instructions for OpenCV on a Mac | |
| after you've tried all the other conflicting instructions out there and still failed. | |
| brew failed for me (was this because I could never get a happy brew doctor situation? | |
| I'll never know). macports? nope. build-from-source recipes? I didn't find one that | |
| worked for me. | |
| Here's what did work to build OpenCV 2.4.5 from the distribution tarball using cmake, | |
| on Mac OSX 10.8.4, linked to an anaconda installation rather than the system python. | |
| It is a mashup of various bits of advice out there. If you're already comfortable with | |
| build/install from source, all you need to read is the cmake invocation in step 3 and |
| IT'S SHOWTIME | |
| HEY CHRISTMAS TREE isLessThan100 | |
| YOU SET US UP @NO PROBLEMO | |
| HEY CHRISTMAS TREE n | |
| YOU SET US UP 0 | |
| HEY CHRISTMAS TREE multiple | |
| YOU SET US UP @NO PROBLEMO | |
| STICK AROUND isLessThan100 |
| =Navigating= | |
| visit('/projects') | |
| visit(post_comments_path(post)) | |
| =Clicking links and buttons= | |
| click_link('id-of-link') | |
| click_link('Link Text') | |
| click_button('Save') | |
| click('Link Text') # Click either a link or a button | |
| click('Button Value') |
| #!/bin/bash | |
| # SPDX-License-Identifier: MIT | |
| ## Copyright (C) 2009 Przemyslaw Pawelczyk <przemoc@gmail.com> | |
| ## | |
| ## This script is licensed under the terms of the MIT license. | |
| ## https://opensource.org/licenses/MIT | |
| # | |
| # Lockable script boilerplate | |
This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.
No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!
I chose [pgloader][1] because it's extremely fast. YMMV.
mysql2 gem with pg in Gemfile.config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.