“无法写入日志文件pg

本文介绍了“无法写入日志文件pg_upgrade_internal.log"从Postgresql 9.1升级到9.3时的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

每当我通过postgres用户运行以下命令时，我都会不断遇到上述错误.

I keep on getting the above error whenever I run the following command via a postgres user.

/usr/lib/postgresql/9.3/bin/pg_upgrade \ -b /usr/lib/postgresql/9.1/bin/ \ -B /usr/lib/postgresql/9.3/bin/ \ -d /var/lib/postgresql/9.1/main \ -D /var/lib/postgresql/9.3/main

无法写入日志文件pg_upgrade_internal.log失败，退出

我正在使用Ubuntu 13.10. Postgresql 9.1和9.3都可以正常运行.

I'm using Ubuntu 13.10. Both Postgresql 9.1 and 9.3 are running properly.

推荐答案

确保从postgres用户可写的目录(例如/tmp或/var/lib/postgresql)运行此命令:

Make sure that you run this command from a directory that is writable by the postgres user, like /tmp or /var/lib/postgresql:

$ cd /tmp $ usr/lib/postgresql/9.3/bin/pg_upgrade ...