Обсуждение: BUG #13839: command line restart server fail

Поиск
Список
Период
Сортировка

BUG #13839: command line restart server fail

От
alirazaidi@hotmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      13839
Logged by:          syed Ali Raza Zaidi
Email address:      alirazaidi@hotmail.com
PostgreSQL version: 9.5rc1
Operating system:   Windows 7
Description:

When I execute following command on windows 7 with administarator option i.e
run CMD as administartor.

Postgres service fail to start.

Kindly advise to resolve this issue.


C:\>pg_ctl restart -D "C:\Program Files\PostgreSQL\9.5\data"


waiting for server to shut down.... done
server stopped
server starting

C:\>2015-12-30 16:44:39 PKT LOG:  redirecting log output to logging
collector pr
ocess
2015-12-30 16:44:39 PKT HINT:  Future log output will appear in directory
"pg_lo
g".

Re: BUG #13839: command line restart server fail

От
"Shulgin, Oleksandr"
Дата:
On Wed, Dec 30, 2015 at 12:48 PM, <alirazaidi@hotmail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13839
> Logged by:          syed Ali Raza Zaidi
> Email address:      alirazaidi@hotmail.com
> PostgreSQL version: 9.5rc1
> Operating system:   Windows 7
> Description:
>
> When I execute following command on windows 7 with administarator option
> i.e
> run CMD as administartor.
>
> Postgres service fail to start.
>
> Kindly advise to resolve this issue.
>
>
> C:\>pg_ctl restart -D "C:\Program Files\PostgreSQL\9.5\data"
>
>
> waiting for server to shut down.... done
> server stopped
> server starting
>
> C:\>2015-12-30 16:44:39 PKT LOG:  redirecting log output to logging
> collector pr
> ocess
> 2015-12-30 16:44:39 PKT HINT:  Future log output will appear in directory
> "pg_lo
> g".
>

Hello,

I'm not sure what makes you believe the service has failed to start, at
least the output above suggests otherwise.  Did you check the contents of
"...\data\pg_log" directory?

--
Alex

Re: BUG #13839: command line restart server fail

От
Ali Raza
Дата:
Dear Alex=2C
Thanks for your positive response.
This happens when localhost is used in pg_hba.conf and stated command stuck=
 at last line until I press enter.

When I see windows services postgres service is stopped.Further more trying=
 to connect with pgAdmin I receive connectivity error.


Best Regards=2C
Ali Raza

From: oleksandr.shulgin@zalando.de
Date: Wed=2C 30 Dec 2015 15:02:22 +0100
Subject: Re: [BUGS] BUG #13839: command line restart server fail
To: alirazaidi@hotmail.com
CC: pgsql-bugs@postgresql.org

On Wed=2C Dec 30=2C 2015 at 12:48 PM=2C  <alirazaidi@hotmail.com> wrote:
The following bug has been logged on the website:
=0A=

=0A=
Bug reference:      13839
=0A=
Logged by:          syed Ali Raza Zaidi
=0A=
Email address:      alirazaidi@hotmail.com
=0A=
PostgreSQL version: 9.5rc1
=0A=
Operating system:   Windows 7
=0A=
Description:
=0A=

=0A=
When I execute following command on windows 7 with administarator option i.=
e
=0A=
run CMD as administartor.
=0A=

=0A=
Postgres service fail to start.
=0A=

=0A=
Kindly advise to resolve this issue.
=0A=

=0A=

=0A=
C:\>pg_ctl restart -D "C:\Program Files\PostgreSQL\9.5\data"
=0A=

=0A=

=0A=
waiting for server to shut down.... done
=0A=
server stopped
=0A=
server starting
=0A=

=0A=
C:\>2015-12-30 16:44:39 PKT LOG:  redirecting log output to logging
=0A=
collector pr
=0A=
ocess
=0A=
2015-12-30 16:44:39 PKT HINT:  Future log output will appear in directory
=0A=
"pg_lo
=0A=
g".

Hello=2C
I'm not sure what makes you believe the service has failed to start=2C at l=
east the output above suggests otherwise.  Did you check the contents of ".=
..\data\pg_log" directory?
--Alex
=0A=
                           =

Re: BUG #13839: command line restart server fail

От
Michael Paquier
Дата:
On Thu, Dec 31, 2015 at 3:20 AM, Ali Raza <alirazaidi@hotmail.com> wrote:
> This happens when localhost is used in pg_hba.conf and stated command stuck
> at last line until I press enter.

(Please avoid top-posting, that is annoying for everybody here and it
breaks the logic of the thread...)
What kind of client are you using to connect to the Postgres server
after starting it? Npgsql? What is the failure you are seeing and what
is the command you are mentioning? Are you getting a connection
failure caused by a missing entry in pg_hba.conf?

> When I see windows services postgres service is stopped.
> Further more trying to connect with pgAdmin I receive connectivity error.

What do the contents of your logs show you? First where are things
logged out? For example what is the setting value for log_destination?
--
Michael