| From: | SongDongyan <yzhskdls(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | a question about postgresql server connection |
| Date: | 2009-04-15 12:30:29 |
| Message-ID: | BAY102-W2D7EFD89D24BF58B85E28C77D0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 know 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
_________________________________________________________________
上Windows Live 中国首页,下载最新版 MSN!
http://im.live.cn/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2009-04-15 12:31:33 | Re: Performance of full outer join in 8.3 |
| Previous Message | Simon Riggs | 2009-04-15 12:25:40 | Re: Performance of full outer join in 8.3 |