最新博客文章

For example I need to dump 1000 records from table my_table:

1

COPY(SELECT * FROM my_table 1000) to '/path/to/my_table.sql'

For details about COPY command, check PostgreSQL Document.

To use xapian in virtualenv, you could manually compile and install into your virtualenv environment:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

export VENV=$VIRTUAL_ENV
mkdir $VENV/packages && cd $VENV/packages ...

I got following message when doing a yum check-update:

rpmfusion-free-updates | 3.3 kB 00:00

Not using downloaded repomd.xml because it is older than what we have:

Current : Sat Jan 28 18:19:20 2012

Downloaded: Mon Jan 9 ...

First thing bothered me is that when using postgresql and psycopg2.4.4, run test will get following errors:

psycopg2.ProgrammingError: autocommit cannot be used inside a transaction

This turns out is a incompatible problem with django and newer version ...

在VMware vSphere上安装linux虚拟机，在配置内核的时候出了差错，导致重启之后出现kernel panic，无法正常启动，想使用光盘引导但是启动速度太快了，总是来不及进BIOS，后来发现其实在虚拟机配置文件中有选项可以强制在启动的时候进入BIOS设置画面，不多说了，直接上图：