Обсуждение: BUG #5927: PostgreSQL8.2

The following bug has been logged online:

Bug reference:      5927
Logged by:          Vishal
Email address:      vishalv@indevia.com
PostgreSQL version: 8.2
Operating system:   Windows Server 2008
Description:        PostgreSQL8.2
Details:

I am getting an error in my PostGreSQL8.2

Error 1053: The service did not respond to the start or control request in a
timely fashion

On Fri, Mar 11, 2011 at 10:10 AM, Vishal <vishalv@indevia.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05927
> Logged by: =A0 =A0 =A0 =A0 =A0Vishal
> Email address: =A0 =A0 =A0vishalv@indevia.com
> PostgreSQL version: 8.2
> Operating system: =A0 Windows Server 2008
> Description: =A0 =A0 =A0 =A0PostgreSQL8.2
> Details:
>
> I am getting an error in my PostGreSQL8.2
>
> Error 1053: The service did not respond to the start or control request i=
n a
> timely fashion

What do you see in the server log file?

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Hello Robert,

I checked my logs and found the following info -

[1] Information (8196), test_db_connection: exception: The Report Server is
unable to connect to the database. Database error: could not connect to
server: Connection refused (0x0000274D/10061)
    Is the server running on host "???" and accepting
    TCP/IP connections on port 5432?


pid=3D"3396:5256"


[2] Error (8196), DB_Connection: exception in connect: could not connect to
server: Connection refused (0x0000274D/10061)
    Is the server running on host "???" and accepting
    TCP/IP connections on port 5432?


pid=3D"3396:5256"


Please advise..

Thanks & Regards,
Vishal Vijayan
Asst Manager IT
Indevia Accounting P. Ltd.
www.indevia.com
Tel +91-22-28253131 / 64126304

-----Original Message-----
From: Robert Haas [mailto:robertmhaas@gmail.com]=20
Sent: Saturday, March 12, 2011 12:34 AM
To: Vishal Vijayan
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5927: PostgreSQL8.2

On Fri, Mar 11, 2011 at 10:10 AM, Vishal <vishalv@indevia.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05927
> Logged by: =A0 =A0 =A0 =A0 =A0Vishal
> Email address: =A0 =A0 =A0vishalv@indevia.com PostgreSQL version: 8.2=20
> Operating system: =A0 Windows Server 2008
> Description: =A0 =A0 =A0 =A0PostgreSQL8.2
> Details:
>
> I am getting an error in my PostGreSQL8.2
>
> Error 1053: The service did not respond to the start or control=20
> request in a timely fashion

What do you see in the server log file?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Mar 12, 2011 at 01:01:52PM +0530, Vishal wrote:
> Hello Robert,
>
> I checked my logs and found the following info -
>
> [1] Information (8196), test_db_connection: exception: The Report Server is
> unable to connect to the database. Database error: could not connect to
> server: Connection refused (0x0000274D/10061)
>     Is the server running on host "???" and accepting
>     TCP/IP connections on port 5432?

These are the logs of some Report Server, not the database server.
Please find those and tell us...

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFNe2J5Bcgs9XrR2kYRAgkPAJ9wCwiQfiDK2QIxillJaduUZUatBwCfQkxY
BW4DK3dtLjr+X+q72bHU5YY=
=QFrw
-----END PGP SIGNATURE-----

On 03/12/2011 03:31 PM, Vishal wrote:
> Hello Robert,
>
> I checked my logs and found the following info -
>
> [1] Information (8196), test_db_connection: exception: The Report Server is
> unable to connect to the database. Database error: could not connect to
> server: Connection refused (0x0000274D/10061)
>     Is the server running on host "???" and accepting
>     TCP/IP connections on port 5432?

The database logs are in C:\Program Files\Postgresql\8.2\data\pg_log
assuming you installed Pg to the default location. Check there.

--
Craig Ringer