TIP for setup psycopg2 for mac/linux

If something like 'cannot find pg_config' , we should add /path/to/postgres/x.x/bin to PATH environment.


That's all for this post.

Comments

Post a Comment

Popular posts from this blog

Byobu + Tmux Tips # 2014-01-22

Scenario#1     As a Byobu-Tmux user, I want to broadcast command to multiple panes. So that I don't have to do the same thing for each pane. solution#1 enter command mode => PREFIX + : active this feature => setw synchronize-panes on deactive => setw synchronize-panes off Scenario#2     As a Byobu-Tmus user, I want to have a shortcut to maximize/minimize current pane. So that I can see/work on specific pane efficiently. solution#1 edit ~/.byobu/keybindings.tmux fill-in these code below # maximum pane and restore unbind + bind + new-window -d -n tmux-zoom 'clear && echo TMUX ZOOM && read' \; swap-pane -s tmux-zoom.0 \; select-window -t tmux-zoom  unbind -  bind - last-window \; swap-pane -s tmux-zoom.0 \; kill-window -t tmux-zoom # resize pane bind H resize-pane -L 1 bind J resize-pane -D 1 bind K resize-pane -U 1 bind L resize-pane -R 1 Scenario#3     As a Byobu-Tmux...
Read more

Changing postgres password and warning

ORIGINAL from https://serverfault.com/questions/110154/whats-the-default-superuser-username-password-for-postgres-after-a-new-install CAUTION  The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be  DANGEROUS ! This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system. What you should do is follow  Chris James 's answer: sudo -u postgres psql postgres # \password postgres Enter new password: To explain it a little bit. There are usually two default ways to login to...
Read more

How to explode DEBian package file.

I wrote this because My senior need to get uwsgi ( newer version ) than registered in precise repos. At that time we found great guy Chris Lea ( https://launchpad.net/~chris-lea/+archive/uwsgi ), thank chris :). But if we don't found him. I plan to explode current debian version from precise repos to see the structure and all script. Here is how to do that Get one (deb pkg) i assume uwsgi-current.deb 1. The first way Using dpkg-deb -x , you will get inside debian structure. > dpkg-deb -x uwsgi-current.deb [target-folder] Using dpkg-deb --control , you will get control files, debian control scripts. > dpkg-deb --control uwsgi-current.deb [target-folder] /DEBIAN 2. The second way,  the first way can be done in short time in  > dpkg-deb -R uwsgi-current.deb [target-folder]
Read more