a question about postgresql server connection

Поиск
Список
Период
Сортировка
От SongDongyan
Тема a question about postgresql server connection
Дата
Msg-id BAY102-W2D7EFD89D24BF58B85E28C77D0@phx.gbl
обсуждение исходный текст
Ответы Re: a question about postgresql server connection  (Adrian Klaver <aklaver@comcast.net>)
Список 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 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




微软地图实时路况,为您节省的不仅仅是时间! 立即查看!

В списке pgsql-general по дате отправления:

Предыдущее
От: William Temperley
Дата:
Сообщение: Re: Disconnected editing - versioning of databases
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: a question about postgresql server connection