解决Mac OS下odoo8的数据库manager不能restore和backup的问题

问题很简单,odoo8可以create或者drop数据库,但是restore的时候, 提示“command pg_dump can not found”, 然后backup的时候,提示“command psql can not found”。

尝试了各种办法,濒临绝望的时候,突然想到是不是这两个命令的新版本的PATH路径虽然已经写到了bash文件里,但是好像没有link,于是乎:

sudo ln -s /usr/local/bin/pg_dump /usr/bin/pg_dump

          sudo ln -s /usr/local/bin/psql /usr/bin/psql

         数据库又可以好好玩耍了。

         本机数据库我是用brew安装的,但是听说postgres.app更好用,下载了,发现odoo找不到localhost的数据库服务器,暂时搁下,后面把pgAdmin3还有postgres.app好好弄一下。

参考文献:

  1. http://serverfault.com/questions/426480/pg-dump-not-working-do-i-need-to-change-order-of-path
  2. PostgreSQL新手入门:

    http://www.ruanyifeng.com/blog/2013/12/getting_started_with_postgresql.html

  3. Mac下使用homebrew安装postgresql及配置:

    http://blog.everlose.com/mac-homebrew-postgresql.html

Advertisements

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s