[pgadmin-support] 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 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..
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.

[Guillaume Lelarge]

Post by 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.
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.