Recreating SAS Shared service database

[Sajid01]

Hello
Wondering if any body had to recover the shared services database or remove the pg_toast errors in it.
I would appreciate if they can share how they did it.
Google search does turn up many links, but wanted to have something SAS specifics.

[gwootton · Accepted solution]

I would recommend restoring from a file system backup. The Web Infrastructure Platform Data Server that houses Shared Services is a normal postgres server so there wouldn't be anything SAS specific to restoring it, except perhaps stopping all SAS services except the database server itself prior to performing the recovery actions.