Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I can't connect to the server through pgadmin and the error was:

Error connecting to the server: server closed the connection unexpectedly.
This probably means the server terminated abnormally before or while processing the request. 

I have installed phppgadmin, object relational SQL database (postgresql), and it was all done through the Ubuntu Software Center. Still having gotten everything, I just can't do it. I used host as local host, and configured the password of postgresql through the terminal. Please let me know the solution as soon as possible.

And Here is the log details

2013-06-16 18:17:12 IST LOG:  received fast shutdown request
2013-06-16 18:17:12 IST LOG:  aborting any active transactions
2013-06-16 18:17:12 IST LOG:  autovacuum launcher shutting down
2013-06-16 18:17:12 IST LOG:  shutting down
2013-06-16 18:17:13 IST LOG:  database system is shut down
2013-06-16 18:20:26 IST LOG:  database system was shut down at 2013-06-16 18:17:13     IST
2013-06-16 18:20:26 IST LOG:  incomplete startup packet
2013-06-16 18:20:26 IST LOG:  autovacuum launcher started
2013-06-16 18:20:26 IST LOG:  database system is ready to accept connections
2013-06-16 23:07:23 IST LOG:  received fast shutdown request
2013-06-16 23:07:23 IST LOG:  aborting any active transactions
2013-06-16 23:07:23 IST LOG:  autovacuum launcher shutting down
2013-06-16 23:07:23 IST LOG:  shutting down
2013-06-16 23:07:24 IST LOG:  database system is shut down
2013-06-17 09:26:42 IST LOG:  database system was shut down at 2013-06-16 23:07:23 IST
2013-06-17 09:26:42 IST LOG:  database system is ready to accept connections
2013-06-17 09:26:42 IST LOG:  autovacuum launcher started
2013-06-17 09:26:43 IST LOG:  incomplete startup packet
2013-06-17 10:32:35 IST LOG:  unexpected EOF on client connection
2013-06-17 12:31:21 IST LOG:  received fast shutdown request
2013-06-17 12:31:21 IST LOG:  aborting any active transactions
2013-06-17 12:31:21 IST LOG:  autovacuum launcher shutting down
2013-06-17 12:31:21 IST LOG:  shutting down
2013-06-17 12:31:21 IST LOG:  database system is shut down
2013-06-17 13:58:52 IST LOG:  incomplete startup packet
2013-06-17 13:58:52 IST LOG:  database system was shut down at 2013-06-17 12:31:21 IST
2013-06-17 13:58:53 IST LOG:  database system is ready to accept connections
2013-06-17 13:58:53 IST LOG:  autovacuum launcher started
2013-06-17 22:25:48 IST LOG:  received fast shutdown request
2013-06-17 22:25:48 IST LOG:  aborting any active transactions
2013-06-17 22:25:48 IST LOG:  autovacuum launcher shutting down
2013-06-17 22:25:48 IST LOG:  shutting down
2013-06-17 22:25:49 IST LOG:  database system is shut down
2013-06-18 10:28:34 IST LOG:  database system was shut down at 2013-06-17 22:25:48 IST
2013-06-18 10:28:35 IST LOG:  incomplete startup packet
2013-06-18 10:28:35 IST LOG:  database system is ready to accept connections
2013-06-18 10:28:35 IST LOG:  autovacuum launcher started
2013-06-18 19:08:37 IST LOG:  received fast shutdown request
2013-06-18 19:08:37 IST LOG:  aborting any active transactions
2013-06-18 19:08:37 IST LOG:  autovacuum launcher shutting down
2013-06-18 19:08:37 IST LOG:  shutting down
2013-06-18 19:08:37 IST LOG:  database system is shut down
2013-06-18 19:09:09 IST LOG:  database system was shut down at 2013-06-18 19:08:37 IST
2013-06-18 19:09:09 IST LOG:  incomplete startup packet
2013-06-18 19:09:09 IST LOG:  database system is ready to accept connections
2013-06-18 19:09:09 IST LOG:  autovacuum launcher started
2013-06-18 19:49:24 IST LOG:  unexpected EOF on client connection
2013-06-18 19:55:35 IST FATAL:  role "arunn" does not exist
2013-06-18 22:34:58 IST LOG:  received fast shutdown request
2013-06-18 22:34:58 IST LOG:  aborting any active transactions
2013-06-18 22:34:58 IST LOG:  autovacuum launcher shutting down
2013-06-18 22:34:58 IST LOG:  shutting down
2013-06-18 22:34:59 IST LOG:  database system is shut down
2013-06-19 10:39:25 IST LOG:  incomplete startup packet
2013-06-19 10:39:25 IST LOG:  database system was shut down at 2013-06-18 22:34:59 IST
2013-06-19 10:39:26 IST LOG:  autovacuum launcher started
2013-06-19 10:39:26 IST LOG:  database system is ready to accept connections
2013-06-19 15:18:57 IST LOG:  received fast shutdown request
2013-06-19 15:18:57 IST LOG:  aborting any active transactions
2013-06-19 15:18:57 IST LOG:  autovacuum launcher shutting down
2013-06-19 15:18:57 IST LOG:  shutting down
2013-06-19 15:18:57 IST LOG:  database system is shut down
2013-06-19 17:46:42 IST LOG:  database system was shut down at 2013-06-19 15:18:57 IST
2013-06-19 17:46:42 IST LOG:  database system is ready to accept connections
2013-06-19 17:46:42 IST LOG:  autovacuum launcher started
2013-06-19 17:46:42 IST LOG:  incomplete startup packet
2013-06-19 18:12:08 IST LOG:  received fast shutdown request
2013-06-19 18:12:08 IST LOG:  aborting any active transactions
2013-06-19 18:12:08 IST LOG:  autovacuum launcher shutting down
2013-06-19 18:12:08 IST LOG:  shutting down
2013-06-19 18:12:08 IST LOG:  database system is shut down
2013-06-19 18:12:40 IST LOG:  database system was shut down at 2013-06-19 18:12:08 IST
2013-06-19 18:12:40 IST LOG:  database system is ready to accept connections
2013-06-19 18:12:40 IST LOG:  autovacuum launcher started
2013-06-19 18:12:40 IST LOG:  incomplete startup packet
2013-06-19 19:19:34 IST LOG:  received fast shutdown request
2013-06-19 19:19:34 IST LOG:  aborting any active transactions
2013-06-19 19:19:34 IST LOG:  autovacuum launcher shutting down
2013-06-19 19:19:34 IST LOG:  shutting down
2013-06-19 19:19:34 IST LOG:  database system is shut down
2013-06-19 19:20:06 IST LOG:  database system was shut down at 2013-06-19 19:19:34 IST
2013-06-19 19:20:07 IST LOG:  incomplete startup packet
2013-06-19 19:20:07 IST FATAL:  the database system is starting up
2013-06-19 19:20:07 IST LOG:  database system is ready to accept connections
2013-06-19 19:20:07 IST LOG:  autovacuum launcher started
2013-06-20 08:13:10 IST LOG:  database system was interrupted; last known up at 2013-  06-19 19:20:07 IST
2013-06-20 08:13:10 IST LOG:  database system was not properly shut down; automatic    recovery in progress
2013-06-20 08:13:11 IST LOG:  record with zero length at 0/1652184
2013-06-20 08:13:11 IST LOG:  redo is not required
2013-06-20 08:13:11 IST LOG:  incomplete startup packet
2013-06-20 08:13:11 IST FATAL:  the database system is starting up
2013-06-20 08:13:11 IST LOG:  database system is ready to accept connections
2013-06-20 08:13:11 IST LOG:  autovacuum launcher started

My OS version is 12.04 LTS.

share|improve this question
    
Check the PostgreSQL server logs, see if there's anything information there. Also, do you mean PgAdmin-III or PHPPgAdmin? They're different things. –  Craig Ringer Jun 12 '13 at 3:54
    
I meant pgadmin3 but also i have phppgadmin installed. –  Arunn Jun 19 '13 at 14:26
    
these were the stuffs in the log –  Arunn Jun 19 '13 at 14:27
    
2013-06-16 18:17:12 IST LOG: received fast shutdown request 2013-06-16 18:17:12 IST LOG: aborting any active transactions 2013-06-16 18:17:12 IST LOG: autovacuum launcher shutting down 2013-06-16 18:17:12 IST LOG: shutting down 2013-06-16 18:17:13 IST LOG: database system is shut down 2013-06-16 18:20:26 IST LOG: database system was shut down at 2013-06-16 18:17:13 IST 2013-06-16 18:20:26 IST LOG: incomplete startup packet 2013-06-16 18:20:26 IST LOG: autovacuum launcher started 2013-06-16 18:20:26 IST LOG: database system is ready to accept connections –  Arunn Jun 19 '13 at 14:28
    
You can edit your question to add more information. That way you can format it legibly by using the code-indent block {}. Anyway, that's not enough of the log, you've left out the most important part. Take at least the last 50 lines. –  Craig Ringer Jun 20 '13 at 0:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.