Re: BUG #8125: server connecting error

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #8125: server connecting error
Дата
Msg-id 517EC29A.5060903@hogranch.com
обсуждение исходный текст
Ответ на BUG #8125: server connecting error  (pradip29@gmail.com)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: deepuyadagiri
Дата:
Сообщение: Re: BUG #8125: server connecting error
Следующее
От: Josh Berkus
Дата:
Сообщение: RESET ROLE issue (Unreproduceable (so far) )