PostGres tables on SASWebInfrastructurePlatformDataServer

[Key123]

Is it possible to browse through the PostGre tables on the SASWebInfrastructurePlatformDataServer configuration?. I have a requirement to provide the table and sample data being stored in these tables and I am unable to login to this database using

$SASHOME/SASWebInfrastructurePlatformDataServer/9.4/bin/psql

[gwootton · Accepted solution]

The SAS Web Infrastructure Platform Data Server is a postgres database, so you can use any postgres client to connect to it.

From your description, it is not clear what issue you are encountering when trying to use the psql client. However to be able to use the psql CLI in that path, you'd need to set some environment variables as well as some options to that command line.

You could run this to set the environment variables necessary to run psql:
# Set a variable to store the base path for the psql client.
PGHOME=$SASHOME/SASWebInfrastructurePlatformDataServer/9.4
# Put the bin subdir into PATH
PATH=$PATH:$PGHOME/bin
# Put the lib subdir into LD_LIBRARY_PATH
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib

This will allow you to run "psql" without specifying the full path.

Then run psql with the options:
-p 9432 (the default postgres port is 5432, WIP Data Server runs on 9432 by default)
-U dbmsowner (the database user)
-d SharedServices (the database name)

This will prompt you for the password for the dbmsowner user, so you will need to know that.