Thread: BUG #8125: server connecting error

BUG #8125: server connecting error

From
pradip29@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      8125
Logged by:          Pradip Patel
Email address:      pradip29@gmail.com
PostgreSQL version: 9.0.0
Operating system:   Windows
Description:        =


i have a backup of only the "data" folder of postgres and my serer was
crashed  now i m trying to install thesame version of postgres and restore
that file but after that i m unable to connect with postgres server =


that showing me the following error

""could not connect to server: Connection refused (0x0000274D/10061) Is the
server running on host "localhost" and accepting TCP/IP connections on port
5432? ""

Re: BUG #8125: server connecting error

From
deepuyadagiri
Date:
go to services---

right click on postgresql service

goto path to executable

and change runservice to start






--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8125-server-connecting-error-tp5753634p5753656.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Re: BUG #8125: server connecting error

From
John R Pierce
Date:
On 4/29/2013 12:02 AM, pradip29@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8125
> Logged by:          Pradip Patel
> Email address:pradip29@gmail.com
> PostgreSQL version: 9.0.0
> Operating system:   Windows
> Description:
>
> i have a backup of only the "data" folder of postgres and my serer was
> crashed  now i m trying to install thesame version of postgres and restore
> that file but after that i m unable to connect with postgres server
>
> that showing me the following error
>
> ""could not connect to server: Connection refused (0x0000274D/10061) Is the
> server running on host "localhost" and accepting TCP/IP connections on port
> 5432? ""

this is not a bug, and shouldn't be on the bug list.   would best to
bring this to the pgsql-general email list.

at a minimum, after installing the new postgres software, you'd have to
STOP postgres, THEN restore your data directory, then restart postgres.
if it doesn't restart, then check the logfiles and/or event viewer to
see why.

if postgres was running when you made your data backup, odds are pretty
good that backup is no good, unless you used backup software that used
Windows Volume Snapshot Service (VSS).


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast