Обсуждение: server doesnt listen

Поиск
Список
Период
Сортировка

server doesnt listen

От
Dhanush Dhanpal
Дата:
can any one suggest any steps to be taken for the server does not listen
problem???
i had postgresql8.3 from which i upgraded to 9.0. version 8.3 was working
fine. but after this upgrade i have been facing this problem.

when i first installed 9.0 a user account was created. but then when i
reinstalled the documents and setting does show a user created for postgre
but that is not visible in the windows logon screen. can that be the
problem..

On connecting to the server directly from the pgAdmin3 it shows the message
that the server does not listen.

but when i start the service from Control Panel>Admin Tool> Services. it
does start up with out any issues.
but then when i try to restore my database. it does not let me.

The message is::::

pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "jbook" failed: server
closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while processing the
request.
pg_restore: *** aborted because of error

Process returned exit code 1.



it would be really helpful if someone could help me out..
Thanks in advance. 
Dhanush.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/server-doesnt-listen-tp4272659p4272659.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


Re: server doesnt listen

От
Guillaume Lelarge
Дата:
Le 31/03/2011 04:28, Dhanush Dhanpal a écrit :
> can any one suggest any steps to be taken for the server does not listen
> problem???
> i had postgresql8.3 from which i upgraded to 9.0. version 8.3 was working
> fine. but after this upgrade i have been facing this problem.
> 
> when i first installed 9.0 a user account was created. but then when i
> reinstalled the documents and setting does show a user created for postgre
> but that is not visible in the windows logon screen. can that be the
> problem..
> 
> On connecting to the server directly from the pgAdmin3 it shows the message
> that the server does not listen.
> 
> but when i start the service from Control Panel>Admin Tool> Services. it
> does start up with out any issues.
> but then when i try to restore my database. it does not let me.
> 
> The message is::::
> 
> pg_restore: connecting to database for restore
> pg_restore: [archiver (db)] connection to database "jbook" failed: server
> closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.
> pg_restore: *** aborted because of error
> 
> Process returned exit code 1.
> 
> 
> 
> it would be really helpful if someone could help me out..

You should look into PostgreSQL log files. That's the first place to go
when you have such an issue.

Anyway, this is a PostgreSQL issue, not a pgAdmin one. And this is a
pgAdmin mailing list.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com