Explore our sites

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I cannot connect to PostgreSQL server from PgAdmin III , so i get this error:

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 got this error 2 days ago but after restarting the computer the problem disappears , but this time i have restarted it too many times vainly.

i'm using PostgreSQL 9.0.5 on windows 7 with ArcSDE 10.1 (Arcgis Spatial Database add-on), i have deactivated the antivirus and firewall.

I have tried to reinstall PgSQL but the problem persists.

How i can connect to my Pgsql service and get ride from this error ?

share|improve this question
 
Do you see anything related in the logs? Do you experience the same when connecting from psql? –  dezso Dec 6 '13 at 16:49
 
the same error when i try connecting from psql –  geogeek Dec 7 '13 at 9:00
1  
If possible upgrade ASAP to the latest minor version (currently - 9.0.15). –  Milen A. Radev Dec 7 '13 at 11:41
 
thanks for the fresh reminder, upgrade is done. –  geogeek Dec 7 '13 at 14:21
add comment

1 Answer

up vote 1 down vote accepted

It looks like broken data file or broken indexes. If this problem grows, then it can shows some deep system problems - problems with hw (memory, CPU), os (antivirus)... Try to use a commands executed from command prompt for database access repairing a) reindexdb - refresh all indexes, b) pg_dump - recheck a readability of data files.

share|improve this answer
 
+1 following your advices i've made a backup then i can connect to my database, THANKS A LOT. –  geogeek Dec 7 '13 at 9:17
 
what could be the reasons for a such error, should i make routine reindexing ? already i make daily FULL VACCUM & ANALYZE, these operation do not include reindexing ? –  geogeek Dec 7 '13 at 9:25
 
no, there are some very wrong - usually you have to use REINDEX only from performance reason. Try to recheck your hardware, mainly memory. –  Pavel Stehule Dec 7 '13 at 14:19
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.