https://communities.sas.com/t5/Administration-and-Deployment/Recreating-SAS-Shared-service-database/m-p/746008#M22325 <P>Hello<BR />Wondering if any body had to recover the shared services database or remove the pg_toast errors in it.<BR />I would appreciate if they can share how they did it.<BR />Google search does turn up many links, but wanted to have something SAS specifics.<BR /><BR /></P> Sat, 05 Jun 2021 15:53:43 GMT Sajid01 2021-06-05T15:53:43Z https://communities.sas.com/t5/Administration-and-Deployment/Recreating-SAS-Shared-service-database/m-p/746008#M22325 <P>Hello<BR />Wondering if any body had to recover the shared services database or remove the pg_toast errors in it.<BR />I would appreciate if they can share how they did it.<BR />Google search does turn up many links, but wanted to have something SAS specifics.<BR /><BR /></P> Sat, 05 Jun 2021 15:53:43 GMT https://communities.sas.com/t5/Administration-and-Deployment/Recreating-SAS-Shared-service-database/m-p/746008#M22325 Sajid01 2021-06-05T15:53:43Z https://communities.sas.com/t5/Administration-and-Deployment/Recreating-SAS-Shared-service-database/m-p/746250#M22339 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. Mon, 07 Jun 2021 13:52:23 GMT https://communities.sas.com/t5/Administration-and-Deployment/Recreating-SAS-Shared-service-database/m-p/746250#M22339 gwootton 2021-06-07T13:52:23Z