Thread: BUG #5224: After upgrading from vista to windows 7, postgres services are missing

The following bug has been logged online:

Bug reference:      5224
Logged by:          Sriram Gopalan
Email address:      sriramgopalan@gmail.com
PostgreSQL version: 8.4.1
Operating system:   Windows 7
Description:        After upgrading from vista to windows 7, postgres
services are missing
Details:

I recently upgraded my machine from windows vista to window 7. I had
installed postgresql 8.4.1 on that machine and it was working great.
However, after upgrade, I cannot even see the services related to postgres.
When I try to connect, I get the message that postgres is not running and
listening to its port.

On 2/12/2009 12:57 PM, Sriram Gopalan wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5224
> Logged by:          Sriram Gopalan
> Email address:      sriramgopalan@gmail.com
> PostgreSQL version: 8.4.1
> Operating system:   Windows 7
> Description:        After upgrading from vista to windows 7, postgres
> services are missing
> Details:
>
> I recently upgraded my machine from windows vista to window 7. I had
> installed postgresql 8.4.1 on that machine and it was working great.
> However, after upgrade, I cannot even see the services related to postgres.
> When I try to connect, I get the message that postgres is not running and
> listening to its port.

In the services control panel (start -> run ->services.msc , or via
Control Panel -> Administrative Tools) can you see the postgresql
service listed?

What state is it in?

Is there anything in the Windows Error Log about PostgreSQL?

Is there anything of interest at the end of the most recent log file in
the "pg_log" subdirectory of the PostgreSQL data directory?

--
Craig Ringer

On 2/12/2009 11:51 PM, Sriram Gopalan wrote:
> 1. After I reinstalled the latest version of postgresql, I do see a
> service called postgresql-8.4.
> 2. It is started automatically.

Yes, but is it *running* ? The service manager shows the current status
(running or stopped) separately to the startup settings. Check if it's
running.

Also: If you look in Task Manager, are there any "postgres.exe"
processes shown? (You'll need to show all users' tasks, since they run
under a different user account to yours).

> psql: could not connect to server: Cannot assign requested address
> (0x00002741/1
> 0049)
>          Is the server running on host "localhost" and accepting
>          TCP/IP connections on port test?

er ... what? "port test" ? Did you mean to specify a port number and
just put the wrong thing in the wrong field, or did you really intend to
tell psql to connect to the port "test" (via servicename->port
translation presumably)?

What port is PostgreSQL listening on? Check postgresql.conf. The default
is 5432. Try connecting to PostgreSQL by port number.

As for the error message:

0x00002741 appears to be a name service error, which makes sense if the
system is trying to look up the service name to get a port number and
failing. Say, if it's deeply confused by being fed a non-numeric string
for a port number.

Specifically, it's:

   Windows Error 0x00002741 - 10049
   The requested address is not valid in its context.
   WSAEADDRNOTAVAIL

> 4. I believe ever since I upgraded, the pg_log logs have been empty.
> There is nothing much interesting in the prior few logs (just info
> messages about starting up and shutting down etc.)

Not even server startup messages? When is the most recent log entry?


--
Craig Ringer

On 2/12/2009 11:57 PM, Sriram Gopalan wrote:
> Please consider this issue as resolved. Reinstallation seems to have
> fixed it.
>
> The service is running, as noted before and I am able to connect and use
> the database. My syntax was wrong in the previous email.

Ah, OK. Please disregard my previous mail then.

Thanks for letting us know rather than just going quiet when the problem
was fixed. It's nice to know when things work out, and it helps others
who search for answers later.

--
Craig Ringer

1. After I reinstalled the latest version of postgresql, I do see a service
called postgresql-8.4.
2. It is started automatically.

Please note, however, that I am still not able to connect to the database.
For example, trying to use psql gives me the following error:

psql: could not connect to server: Cannot assign requested address
(0x00002741/1
0049)
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port test?

I have never seen this error before my OS upgrade.

3. I looked through the Windows Event Viewer but didn't anything related to
postgres.
4. I believe ever since I upgraded, the pg_log logs have been empty. There
is nothing much interesting in the prior few logs (just info messages about
starting up and shutting down etc.)

Thanks for the prompt response.

Sriram



On Wed, Dec 2, 2009 at 1:07 AM, Craig Ringer <craig@postnewspapers.com.au>wrote:

> On 2/12/2009 12:57 PM, Sriram Gopalan wrote:
>
>>
>> The following bug has been logged online:
>>
>> Bug reference:      5224
>> Logged by:          Sriram Gopalan
>> Email address:      sriramgopalan@gmail.com
>> PostgreSQL version: 8.4.1
>> Operating system:   Windows 7
>> Description:        After upgrading from vista to windows 7, postgres
>> services are missing
>> Details:
>>
>> I recently upgraded my machine from windows vista to window 7. I had
>> installed postgresql 8.4.1 on that machine and it was working great.
>> However, after upgrade, I cannot even see the services related to
>> postgres.
>> When I try to connect, I get the message that postgres is not running and
>> listening to its port.
>>
>
> In the services control panel (start -> run ->services.msc , or via Control
> Panel -> Administrative Tools) can you see the postgresql service listed?
>
> What state is it in?
>
> Is there anything in the Windows Error Log about PostgreSQL?
>
> Is there anything of interest at the end of the most recent log file in the
> "pg_log" subdirectory of the PostgreSQL data directory?
>
> --
> Craig Ringer
>

Please consider this issue as resolved. Reinstallation seems to have fixed
it.

The service is running, as noted before and I am able to connect and use the
database. My syntax was wrong in the previous email.

Thanks again.

Sriram

On Wed, Dec 2, 2009 at 7:51 AM, Sriram Gopalan <sriramgopalan@gmail.com>wrote:

> 1. After I reinstalled the latest version of postgresql, I do see a service
> called postgresql-8.4.
> 2. It is started automatically.
>
> Please note, however, that I am still not able to connect to the database.
> For example, trying to use psql gives me the following error:
>
> psql: could not connect to server: Cannot assign requested address
> (0x00002741/1
> 0049)
>         Is the server running on host "localhost" and accepting
>         TCP/IP connections on port test?
>
> I have never seen this error before my OS upgrade.
>
> 3. I looked through the Windows Event Viewer but didn't anything related to
> postgres.
> 4. I believe ever since I upgraded, the pg_log logs have been empty. There
> is nothing much interesting in the prior few logs (just info messages about
> starting up and shutting down etc.)
>
> Thanks for the prompt response.
>
> Sriram
>
>
>
> On Wed, Dec 2, 2009 at 1:07 AM, Craig Ringer <craig@postnewspapers.com.au>wrote:
>
>> On 2/12/2009 12:57 PM, Sriram Gopalan wrote:
>>
>>>
>>> The following bug has been logged online:
>>>
>>> Bug reference:      5224
>>> Logged by:          Sriram Gopalan
>>> Email address:      sriramgopalan@gmail.com
>>> PostgreSQL version: 8.4.1
>>> Operating system:   Windows 7
>>> Description:        After upgrading from vista to windows 7, postgres
>>> services are missing
>>> Details:
>>>
>>> I recently upgraded my machine from windows vista to window 7. I had
>>> installed postgresql 8.4.1 on that machine and it was working great.
>>> However, after upgrade, I cannot even see the services related to
>>> postgres.
>>> When I try to connect, I get the message that postgres is not running and
>>> listening to its port.
>>>
>>
>> In the services control panel (start -> run ->services.msc , or via
>> Control Panel -> Administrative Tools) can you see the postgresql service
>> listed?
>>
>> What state is it in?
>>
>> Is there anything in the Windows Error Log about PostgreSQL?
>>
>> Is there anything of interest at the end of the most recent log file in
>> the "pg_log" subdirectory of the PostgreSQL data directory?
>>
>> --
>> Craig Ringer
>>
>
>