Greg, more information :
I made a sas studio job ;
cas; %put "ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ" ;
run ;
Logged into postgres pod : kn exec sas-crunchy-platform-postgres-00-b56g-0 -it -- sh
psql
\c SharedServices
SharedServices=# select loid from pg_catalog.pg_largeobject where data like '%ZZZZZ%' ; loid --------- 6612731 6612732 6613030 6613031 6613039 6613038 6765563 (7 rows) What is in the data column ?
select loid,substr(encode(data, 'escape'),1100) as data from pg_catalog.pg_largeobject where data like '%ZZZZZ%' limit 1;
loid | data ---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 6612731 | kers."},{"version":1,"type":"source","line":"593 %put \\"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\\" ;"},{"version":1,"type":"normal","line":"\\"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\\""},{"version":1,"type":"source","line":"594 "},{"version":1,"type":"source","line":"595 run ;"},{"version":1,"type":"source","line":"596 %JESEND"},{"version":1,"type":"note","line":""}],"count":674,"limit":674,"links":[]} (1 row)
Login the backup pod OR another pod which has the backup directory mounted and goto the directory where the pgdump file is and zcat the file blob_<loid>.dat.gz /sasviyabackup/20250127-010206F/__default__/postgres/SharedServices_pg_dump.dmp $ zcat blob_6612731.dat.gz | tail -40 | fold -80 | tail -10 The user is <d.pater> and the active caslib is CASUSER(<d.pater>) ."},{"version":1,"type":"note","line":"NOTE: The SAS option SESSREF was updated with the value CASAUTO."},{"version":1,"type":"note","line":"NOTE: The SAS macro _SESSREF_ was updated with the value CASAUTO."},{"version":1,"type":"note","lin e":"NOTE: The session is using 2 workers."},{"version":1,"type":"source","line": "593 %put \"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\" ;"},{"version": 1,"type":"normal","line":"\"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\"" },{"version":1,"type":"source","line":"594 "},{"version":1,"type":"source","lin e":"595 run ;"},{"version":1,"type":"source","line":"596 %JESEND"},{"version": 1,"type":"note","line":""}],"count":674,"limit":674,"links":[]}
Questions :
1.is this normal behavior ?
2. Must i register a case with SAS for this behavior ?
Regards
Dik
... View more
