Thread: BUG #13839: command line restart server fail
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".
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
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= =
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