Hi,
a few questions:
You are working with Tech Sup on this, correct?
Since the backup might not be a good one (meaning, restore did not work 100%), you could try a pg_xlog reset.
PLEASE NOTE:
If you do go that route, do run a backup of your environment please. Also, resetting the pg_xlog might
cause some data loss. Is this a test environment? If yes, it might be a quick and save fix (try) to
reset the pg_xlog.
Steps:
(Note: Please substitute <sasconfig> with your SAS configuration directory))
1. Stop all (!!) SAS services that are running:
$ <sasconfig>/Lev1/sas.servers stop
2. Ensure there are no PostgreSQL servers still running: (Env Manager and web apps use postgres as
data store)
$ ps -ef | grep -i post
If there are any and they are SAS related, you may need to kill them.
3. Take a full backup of the <sasconfig> directory.
$ cp -rfp <sasconfig>/Lev1 /<sasconfig>/Lev1.orig
4. Set your environment to run the commands:
$ export PATH=/<SASHOME>/SASWebInfrastructurePlatformDataServer/9.4/bin:$PATH
$ export LD_LIBRARY_PATH=/<SASHOME>/SASWebInfrastructurePlatformDataServer/9.4/lib:$LD_LIBRARY_PATH
(Substituting <SASHOME> with your SAS home directory)
5. Reset the PG_XLOG
$ pg_resetxlog /<sasconfig>/Lev1/WebInfrastructurePlatformDataServer/data
Note: If pg_resetxlog complians, you may be able to force it using the -f option:
$ pg_resetxlog -f /<sasconfig>/Lev1/WebInfrastructurePlatformDataServer/data
More information about pg_restxlog can be found here:
https://www.postgresql.org/docs/9.1/static/app-pgresetxlog.html
6. Start just the WIP DS
$ /<sasconfig>/Lev1/WebInfrastructurePlatformDataServer/webinfdsvrc.sh start
7. Vacuum and reindex the WIP DS
$ psql -d SharedServices -h localhost -p 9432 -U dbmsowner
# delete from serviceticket;
# delete from ticketgrantingticket;
# truncate sas_service_url;
# delete from pg_statistic;
$ vacuumlo -h localhost -p 9432 -U dbmsowner -v SharedServices
$ psql -d SharedServices -h localhost -p 9432 -U dbmsowner -c "vacuum full verbose analyze;"
$ psql -d SharedServices -h localhost -p 9432 -U dbmsowner -c 'reindex database "SharedServices";'
$ psql -d SharedServices -h localhost -p 9432 -U dbmsowner -c 'reindex system "SharedServices";'
**NOTE** At this point you can redo the last 4 steps (vacuum, psql, psql, psql) and substitute "SharedServices"
for "EVManager"
8. Stop the WIP DS
$ /<sasconfig>/Lev1/WebInfrastructurePlatformDataServer/webinfdsvrc.sh stop
9. Restart all SAS Services and check your clients
$ <sasconfig>/Lev1/sas.servers start