Re: BUG #6522: PostgreSQL does not start

According to what I can see from this defect that it is not confirmed
whether the Postgre server is started or not properly.

You can try on confirming about the following 2 points:
1. How many postgres processes you are able to see in your task manager.
This can give hint whether appropriate postgres services are started
2. try to start the postgres from command promt with command
Postgres.exe -D <your data directory path>
Please tell what it prints on command promt.

-----Original Message-----
From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Kevin Grittner
Sent: Monday, April 02, 2012 11:43 PM
To: Tatiana Ortiz
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #6522: PostgreSQL does not start

[Please keep the list copied. I won't respond to any more emails
directly to me without a copy to the list.]

Tatiana Ortiz <tatypr18(at)gmail(dot)com> wrote:
> Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov wrote:

>>> Test if you have network connectivity from your client to the
>>> server host using ping or equivalent tools.
>>
>> Do you get a response when you ping 127.0.0.1?
>
> I have not tried that.

Well, nobody here can, so how will we know if that is working?

>>> Is your network / VPN/SSH tunnel / firewall configured
>>> correctly?
>>
>> What did you do to check that?
>
> It*s configured correctly; I have verified it in the control
> panel.

What, exactly, did you verify was true about the configuration?

>>> If you double-checked your configuration but still get this
>>> error message, it`s still unlikely that you encounter a fatal
>>> PostgreSQL misbehavior. You probably have some low level network
>>> connectivity problems (e.g. firewall configuration). Please
>>> check this thoroughly before reporting a bug to the PostgreSQL
>>> community.
>>
>> What did you do to check this?
>
> The Firewall configuration is correct.

Something isn't. If you have a firewall running, I sure wouldn't
rule it out without pretty good evidence pointing to something else.
Do you have an anti-virus product installed? (Note, I didn't ask
whether it was enabled -- even when supposedly disabled, many AV
products can cause problems like this.)

>> Your previous email mentioned deleting the postmaster.pid file.
>> Do you have any more detail on what you did?
>
> When I deleted the postmaster.pid, and then went to the Services
> to give a restart to the Postgre service, the file reappeared.

That's an interesting data point, although not enough to pin it down
without other facts not in evidence.

>>> If you know of something I could do to gain access to the
>>> database let me know.
>>
>> Start Task Manager and look in the Processes tab. Are there any
>> Postgres processes active?
>
> [suggestion apparently ignored]

If you won't provide information, nobody can help you.

>> From a command line, run:
>>
>> netstat -p TCP -a
>>
>> and see if anything is listening on port 5432.
>
> I tried this, and it gave me this result:
>
> [image: nothing listening on port 5432]

So, either the PostgreSQL service isn't running, or it is not
offering IP services on the default port.

Is anything appearing in any of the Windows event logs around the
time you attempt to start the service? Can you find a PostgreSQL
log file anywhere? Without knowing what installer was used, it
would be hard to suggest where to look, but sometimes the log files
are in a subdirectory named pg_log, and sometimes there is a file
named "logfile" in the PostgreSQL data directory.

Assistance on this list is provided by volunteers. If you don't
care enough about what you've got wrong in your environment to
perform the requested diagnostic steps, those contributing their
time are likely to lose interest and stop responding. I have 200
databases running just fine on 100 servers scattered across the
state. What are you doing that isn't working? It's not my
responsibility to sort that out, but I'm willing to help if you're
willing to take responsibility for your end.

-Kevin