Postgres at different locations?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Postgres at different locations?

Postby sphinxx » Sat Aug 23, 2008 6:53 am

When I install postgress on my laptop, while connected to internet at my dad's house it works fine. When I try to run it on the same laptop, but at my own place problems occur.
Can anybody tell me why that is? Does it have something to do with different ip-adresses?

Thanks already
sphinxx
 
Posts: 3
Joined: Sat Aug 23, 2008 6:49 am

Re: Postgres at different locations?

Postby Peligroso » Sat Aug 23, 2008 7:18 am

What are the error messages you're getting? Are you using networked PostgreSQL?
Peligroso
 
Posts: 1483
Joined: Mon Dec 10, 2007 6:51 pm
Location: Sweden

Re: Postgres at different locations?

Postby sphinxx » Sat Aug 23, 2008 7:31 am

this error appears:

could not connect to server, connection refused (0x0000274D/10061)
is the server running on localhost and accepting TCP/IP connections on port 5432?

I didn't see anything about networked postgres, is that necessary?
sphinxx
 
Posts: 3
Joined: Sat Aug 23, 2008 6:49 am

Re: Postgres at different locations?

Postby Peligroso » Sat Aug 23, 2008 7:38 am

No, it's not at all necessary, was just wondering if it could be a firewall issue or similar. It sounds like your postgres server isn't running which can happen sometimes.

Click Start --> Programs --> PostgreSQL --> Stop Service, then Start --> Programs --> PostgreSQL --> Start Service to restart PostgreSQL. If PostgreSQL does not start properly at this point and PT3 doesn't start working, go to C:/Program Files/PostgreSQL/8.x/data and find the file named postmaster.pid. Once you find that file, delete it, then attempt to restart PostgreSQL as above, and it should start properly.

If this happens every time your computer starts, you should set PostgreSQL to start automatically when your computer boots. See Setting up PostgreSQL to autostart for more information.
Peligroso
 
Posts: 1483
Joined: Mon Dec 10, 2007 6:51 pm
Location: Sweden

Re: Postgres at different locations?

Postby sphinxx » Sat Aug 23, 2008 7:40 am

Thank you very much, I'll try it tomorrow, right now i am at my dad's house so it should work anyway
sphinxx
 
Posts: 3
Joined: Sat Aug 23, 2008 6:49 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 42 guests

cron