Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2004
    Posts
    13

    Unanswered: didn't connect to database

    hi...
    i'm using postgresql in windows2000 now it has a problem
    i can start the database successfully but when i trying to connect to
    database postgre gives an error message
    the message is
    'server closed the connection unexpectedly
    this probably means the server terminated abnormally before or while processing the request'
    can any one help me

  2. #2
    Join Date
    Mar 2004
    Posts
    110
    how are you tring to connect to the db?

    PGAdmin III? Script like php, asp?

  3. #3
    Join Date
    Jul 2004
    Posts
    13

    using only postgre

    pls forgive me for my poor english
    i'm using only postgresql commands
    like psql -u username etc
    even the command psql -l for listing all the databases is not working and displays that error message
    but when i start postgresql with pg_ctl start it displays the message started successfully
    if u've any idea pls give me a solution
    Lals

  4. #4
    Join Date
    Mar 2004
    Posts
    110
    try connecting to the db with:

    psql -d template1

    syntax: psql -d <dbname>


    should work unless you have editted your config files in the 'data' directory.

  5. #5
    Join Date
    Jul 2004
    Posts
    13

    the same result

    thnk u for finding time to help me
    its not getting
    the command psql -d <dbname>
    the same error occured
    i made a small change in the configuration file of postgre for accessing from the network and its working smoothly
    now everything is down.
    is there any other solution

  6. #6
    Join Date
    Mar 2004
    Posts
    110
    Wich version of postgresql are you using? Windows installer or cygwin?

    I have a postgresql 7.5 on windows (with installer) and a postgresql 7.4 installed on two systems and they are pretty easy to connect to.

    if you are using version 7.4 or earlier, do you have tcp/ip connections set to true in de postgresql config file?

  7. #7
    Join Date
    Jul 2004
    Posts
    13

    Postgres 7.2.1 Native Windows

    thnk u edge...i'm using postgres 7.2.1
    the tcp/ip connections r set to true can i retrieve the datas from my currupted database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •