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 ?

  • 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

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.

| 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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