×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

PostgreSQL (Windows XP) will not start

PostgreSQL (Windows XP) will not start

PostgreSQL (Windows XP) will not start

(OP)
I haven't made an changes that I can think of (except for installing my wireless printer), but as of yesterday my Postgre 8.2 will not start.  I've checked that
     listen_addresses = 'local host'
     port = 5432
     max_connections = 100

I tried configuring and then just shutting down my firewall (Zonealarm).  I still can't get the server to start and it worked perfectly fine yesterday.

I get this message from pgAdmin win I tried to connect through that program:

"could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?"

I've tried everything I can think of, restarting, checking the configuration, disabling the  firewall, etc.  I've found similar posting, but no solution.  Does anyone have any suggestions.

 

RE: PostgreSQL (Windows XP) will not start

listen_addresses = 'local host'

Is that standard on windows? local host with a blank inside?

Do you see postgresql running in the taskmanager?  

don't visit my homepage: http://home.arcor.de/hirnstrom/bewerbung

RE: PostgreSQL (Windows XP) will not start

(OP)
My apologies. I accidentally added a space to "local host" in my thread, but not in the postgre settings. No postgre is not running in the taskmanager. I've tried starting the service, but to no avail.

RE: PostgreSQL (Windows XP) will not start

What errormessage do you get when you start the service?
Did you visit your logfile?
Did you try to start it from a command shell, to see errormessages immedeately ("no space left on device" for instance, which will never get into a logfile)?

don't visit my homepage: http://home.arcor.de/hirnstrom/bewerbung

RE: PostgreSQL (Windows XP) will not start

(OP)
Problem solved.  I uninstalled and reinstalled.  I didn't do this most obvious solution earlier because I was afraid of losing all my data.  Uninstalling doesn't delete the data, so when I reinstalled, everything works like it used to.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close