Re: Connection refused (0x0000274D/10061) - Mailing list pgsql-general

On 6/18/19 1:06 AM, Sourav Majumdar wrote:
> Hii, I have checked the logged file. I am attaching it with this mail. PFA

In future please do not attach a 1.4MB file. Most of it was Unpacking 
info. The relevant part was at the end:

"
fixing permissions on existing directory C:/PostgreSQL/data ... initdb: 
could not change permissions of directory "C:/PostgreSQL/data": 
Permission denied

Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb

Script stderr:
  Program ended with an error exit code

Error running cscript //NoLogo 
"C:\PostgreSQL/installer/server/initcluster.vbs" "NT 
AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" 
"C:\PostgreSQL\data" 5432 "DEFAULT" 0: Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
  The database cluster initialisation failed.
[23:30:13] Delete the temporary scripts directory...
Creating menu shortcuts...
Executing cscript //NoLogo 
"C:\PostgreSQL\installer\server\createshortcuts_clt.vbs" "PostgreSQL 11" 
"C:\PostgreSQL"
Script exit code: 0"


Did you follow the instructions here?:

https://www.enterprisedb.com/docs/en/11.0/PG_Inst_Guide_v11/PostgreSQL_Installation_Guide.1.08.html#

In particular the part about:

"To perform an installation using the graphical installation wizard, you 
must have superuser or administrator privileges. To start the 
installation wizard, assume sufficient privileges and double-click the 
installer icon; if prompted, provide a password.
Note that in some versions of Windows, you can invoke the installer with 
Administrator privileges by right clicking on the installer icon and 
selecting Run as Administrator from the context menu."



> 
> On Fri, Jun 14, 2019 at 1:58 AM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 6/13/19 9:56 AM, Sourav Majumdar wrote:
>      > Hi,
>      > I have tried many time for setup postgreSQL for my local host.
>     Hence I
>      > have tried to reInstall the one click app from
>      >
>     https://www.enterprisedb.com/downloads/postgres-postgresql-downloads -  Windows
> 
>      > x86-64  -  PostgreSQL Version 11.3. When installing using default
>     port
>      > 5432, Its giving an error "Database Cluster Installation Failed".
>     Please
>      > advice how to resolve the issue. I am struggling to setup this
>      > POSTGRESQL from more than a week.
>      >
>      > The error screenshot is attached. PFA
>      >
> 
>     Sounds like a permissions problem to me.
> 
>     See:
> 
>     https://www.enterprisedb.com/docs/en/11.0/PG_Inst_Guide_v11/PostgreSQL_Installation_Guide.1.13.html#
> 
>     to find the log of the install process. It will probably have more
>     information.
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> -- 
> /Regards-/
> /Sourav Majumdar/
> /Mob.- *9732354141*/


-- 
Adrian Klaver
adrian.klaver@aklaver.com