Recently I was working with postgresql and python on Ubuntu. When I need to use pl/python extension, I met a system error but I cannot know how to fix it directly. Then a simple idea just came into my mind: reinstall the operation system and all the softwares.
Debug: Failed to connect to session manager: SESSION_MANAGER environment variable not defined. Debug: Adding duplicate image handler for ‘PNG file’
最开始只有第二句，后来两句都有了。我在自己的电脑上测试少量数据，删除表格或schema会显示Running，没有任何错误提示，也没有任何会跑完的迹象。 在pgadmin3界面点击一个表格，整个软件就会奔溃。 未找到解决方法。
Go to the official website of Ubuntu to get the latest desktop version. Follow the steps and you’ll get it.
If you want previous version like 14.04 LTS, please go as:
Alternative Downloads -
Other Images -
See all ubuntu mirrors. And then click
http in Shanghai Jiao Tong University, China. The download speed is quite fast.
Startup Disk Creator in the Software Center. If you find the usb disk cannot be erased, go to
Disks software to format it.
After you build the usb as a startup disk, it cannot be used to save files any more.
The bug would appear only when you build a
Startup Disk and use it immediately on the same PC.
Tab and then choosing
live-install would start the installation.
This is a very useful add-on called
nautilus to help daily usage.
Then restart nautilus to make it work immediately.
Then you’ll find
Open in Terminal in your right-click menu list.
Since Ubuntu 14.04 is installed with Python 3.4, let’s install latest python 3.5.2.
We need C compiler and other stuff to compile Python
SQLite libs need to be installed in order for Python to have SQLite support.
安装 Python 3.5：
Reference: 在 Ubuntu 14.04.3 上安装 Python 3.5
Add the following code at the bottom of
Return to the terminal window.
Next time, you don’t need to type the long sentence any more. Instead, type
venvpy35 in the terminal and the virtual environment would be activated.
If you want to exit the virtual environment, just type
virtualenv cannot be build under
pip install would not have the access to the
site-packages directory of the
Reference: pip-uninstall packages with dependencies
Activate your virtual environment, and then do the following steps.
pip install cx_Oracle会出现错误提示
cannot find Python.h。
Login oracle website and download:
cannot locate oracle installation的提示，一定是这里没有设置好。注意：ORACLE_HOME 要指向绝对路径。
- cx_Oracle instant client install python3
- 在PostgreSQL中使用oracle_fdw访问Orcale(foreigh table)
postgreSQL automatically create a
postgreSQL user named
First, let’s change the password of
Then let’s login postgreSQL as user
postgres=# would appear in the very front.
Then let’s create a user we would use in our daily work. The same as your ubuntu user account is quite good.
SUPERUSER is necessary for configuring python fucntions in postgreSQL by
Next time, you can use the sentence below to login.
The abbreviated sentence can be:
The initial settings have been done.
Login postgresql and run:
Reference: pip 安装特定版本的 Python 包
System Settings -
System Settings -
Language Support -
In Ubuntu 16.04, Sougou Input Method cannot be used in Cmaptools and Pycharm.
The solution is add the following 3 lines to the top of the start file such as
Then we can type in Chinese character by Sougou Input Method in Pycharm. Solution for Cmaptools is similar. The only problem left is the small menu of alternative characters does not follow tightly behind the input curser any more.
Reference: How to install a .bin file
In order to get full access to Cmaps directory, I need to choose “where to install” as
/home/katherine/IHMC CmapTools rather than
/root/IHMC CmapTools. Then you can have the
My_Cmaps file under directory
Every time use
bash CmapTools in the directory of file
CmapTools to start it.
Reference: Install a .tar.gz file
And the Installation process would start. This is also the way to start Pycharm after installation.
If you use Ubuntu like me, you can follow the code below.
For other OS please see here. You need to buy the service yourself, or you need a good boss like I have =.=
Then search “shadowsocks” in your computer and start the application. Configure the server and connect.
Follow the steps in http://sslite.top/136/. Make sure the shadowsocks is working when foxyproxy starts to work.
Almost all the problems and issues I met with are listed here. If you have other questions as well as answers, it’s very appreciated to tell me.