Weird startup behaviour

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

Weird startup behaviour

Postby N0L1M1T » Mon Feb 22, 2010 5:26 pm

Hi,
I'm seeing some strange, and sadly fatal, startup behaviour with postgresql. That is, when the service starts it launches 4 windows service listeners but then proceeds to try to launch more. And apparently this causes the service startup to bail because the other 4 processes are attached to port 5432.

Try as I might I've not been able to fix this. Can somone help me out with this as the postgres service I have running on another equivalent XP box doesn't behave the same way.

Note: Firewalls are not an issue here.


Regards,
Dave
N0L1M1T
 
Posts: 48
Joined: Mon Jan 28, 2008 8:42 am

Re: Weird startup behaviour

Postby kraada » Mon Feb 22, 2010 6:11 pm

PostgreSQL normally uses a lot of processes. Each does a different thing and that's the reason why this database is as quick as it is. Four postgres processes aren't going to cause any problems.

Please report the problem you are experiencing though so that we can figure out what is causing it for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Weird startup behaviour

Postby N0L1M1T » Tue Feb 23, 2010 7:49 am

Yes, I know that there are 4 processes and that they're there for performance reasons. What I was saying is that the startup is starting 4 listeners and then trying to start 4 more which bail out cos the postgres port is unavailable. This in turn causes PT to abort cos it can't attach to the database.
N0L1M1T
 
Posts: 48
Joined: Mon Jan 28, 2008 8:42 am

Re: Weird startup behaviour

Postby WhiteRider » Tue Feb 23, 2010 9:18 am

Please report your problem - you can attach the postgres logs too and that should give us an idea what is going on.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest