|
Hi all, I installed postgresql and when I typed ./createdb mydb, it gave error message: ************************************************************************************************************************* createdb: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Then I checked /etc/init.d file, and I got postgresql-8.3 in this directory, then I used $ sudo ./postgresql-8.3 start, which gave error message: **************************************************************************** LOG: could not bind IPv4 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry\. FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied But before it, I have already add an line below the IPv4 connection, which looks like: # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 130.238.209.11/1 trust I got my IP address from ifconfig. After that, I really do not kno w what should I do next step. I really appreciate any help, thank you in advance! Best regards, Dongyan Dongyan Song, Msc Uppsala University Applied Biotechnology & Computational Science +46(0)707204195 Flogstavagen 67E-521 微软地图实时路况，为您节省的不仅仅是时间！ 立即查看！ |
