Succeeded in console but failed in Webmin??!!

billlion

Can any one help me?
I run below command :
/usr/local/pgsql/bin/postmaster -i -S -D /usr/local/pgsql/data
it succeeded in console, but when I want to start my PostgreSQL in Webmin, there was an error occured:

Failed to start database server :

LOG:  00000: could not identify current directory: Permission denied
LOCATION:  find_my_exec, exec.c:195
FATAL:  XX000: /usr/local/pgsql/bin/postmaster: could not locate my own executable path
LOCATION:  PostmasterMain, postmaster.c:431

I have added path "/usr/local/pgsql/bin" to environment variable PATH, I don't know what problem it is, any one know it? Please help me, thank you!

joint

LOG:  00000: could not identify current directory: Permission denied

billlion

但是为什么命令行可以启动我的数据库呢？命令都是相同的，而且我的数据库目录所有者正是用户postgres阿，怎么会permission denied呢？

joint

http://www.pgsqldb.org/pgsqldoc-8.0c/postmaster-start.html

su -c 'pg_ctl -D /usr/local/pgsql/data -l serverlog' postgres

billlion

感谢joint的回帖！

su -c 'pg_ctl start -D /usr/local/pgsql/data -l serverlog' postgres

上面的命令试过了还是不行。而且PostgreSQL8.0的手册中的这个命令好象缺少个参数“start”（蓝色字部分）。

我试着把postgres做了个符号连接(ln -s /usr/local/pgsql/bin/postres /usr/bin/postmaster, 因为/usr/local/pgsql/bin目录下的这个postmaster也是postgres的符号连接)，启动命令改成：
su postgres -c "/usr/bin/postmaster -i -S -D /usr/local/pgsql/data"
结果还是那个错误提示。
我现在怀疑有可能是webmin的安装有问题，等我卸掉重装webmin看看结果如何。

billlion

很不幸，重装webmin后问题依旧     :em12: