Installing a Postgresql instance inside a SAS environment (Windows Installation)

[vfarmak]

Hi everyone,

I am aware that SAS Metadata Servers stores its data in an postgresql database. 

I need to Install in the same windows machine, another Postgresql database but I want to do it in such a way that will not interact with the postgresql metadata server. 

I aware of the port that metadata server runs. 

Is there a guide somewhere in SAS or guidelines for those who want to store this type of instance inside a SAS Installation.

We are using SAS 9.4 M8 and the operating system of the SAS environment is Windows Server 2016 Standard.

[gwootton]

I believe the SAS Web Infrastructure Platform Data Server is the SAS 9.4 Postgres database you're referencing.

https://go.documentation.sas.com/doc/en/bicdc/9.4/bimtag/p1wm2vva6wgsynn11oa4hxibn9b5.htm

This server listens on port 9432 by default rather than the port 5432 used by postgres by default, and runs from binaries in the SAS installation directory.

I don't think you'd have any issues installing another instance of postgres outside of the one SAS deploys as long as you don't use the same port or binary and data directories as SAS, but I'm not aware of any testing or documentation on doing so specific to SAS.

[Patrick]

One indication that installing another instance shouldn't create any issues: 
SAS Risk Solutions also use Postgres and it's not the WIP server but a separate instance (with likely separate binaries).