https://community.qlik.com/t5/Management-Governance/Why-we-need-the-connection-string-to-the-default-postgreSQL/m-p/1615763#M14458 <P>In connection string to our independent postgreSQL server, there is this connection:</P><P>&lt;add name="postgres" connectionString="User ID=postgres;Host=localhost;Port=4432;Database=postgres;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;" providerName="Devart.Data.PostgreSql" /&gt;</P><P>&nbsp;</P><P>Originally I thought it is useless, as there is no password, the port is different from other 2 connection strings. But when I remove it, the repository service keeps failing. I see error from event viewer:</P><P>Unhandled exception: Object reference not set to an instance of an object.<BR />Autofac.Core.DependencyResolutionException: An exception was thrown while invoking the constructor 'Void .ctor()' on type 'AdminDatabaseInformation'. ---&gt; Object reference not set to an instance of an object. (See inner exception for details.) ---&gt; System.NullReferenceException: Object reference not set to an instance of an object.</P><P>&nbsp;</P><P>Question is, what does the connection string do?</P><P>&nbsp;</P><P>Best regards,</P><P>Susan</P> Fri, 23 Aug 2019 07:03:11 GMT Huiying 2019-08-23T07:03:11Z https://community.qlik.com/t5/Management-Governance/Why-we-need-the-connection-string-to-the-default-postgreSQL/m-p/1615763#M14458 <P>In connection string to our independent postgreSQL server, there is this connection:</P><P>&lt;add name="postgres" connectionString="User ID=postgres;Host=localhost;Port=4432;Database=postgres;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;" providerName="Devart.Data.PostgreSql" /&gt;</P><P>&nbsp;</P><P>Originally I thought it is useless, as there is no password, the port is different from other 2 connection strings. But when I remove it, the repository service keeps failing. I see error from event viewer:</P><P>Unhandled exception: Object reference not set to an instance of an object.<BR />Autofac.Core.DependencyResolutionException: An exception was thrown while invoking the constructor 'Void .ctor()' on type 'AdminDatabaseInformation'. ---&gt; Object reference not set to an instance of an object. (See inner exception for details.) ---&gt; System.NullReferenceException: Object reference not set to an instance of an object.</P><P>&nbsp;</P><P>Question is, what does the connection string do?</P><P>&nbsp;</P><P>Best regards,</P><P>Susan</P> Fri, 23 Aug 2019 07:03:11 GMT https://community.qlik.com/t5/Management-Governance/Why-we-need-the-connection-string-to-the-default-postgreSQL/m-p/1615763#M14458 Huiying 2019-08-23T07:03:11Z