金仓老旧项目改造-15-[vibe编程vlog]

今天下午基本没有再进一步解决问题而是对之前的知识进行了一些总结并且整理成文档方便后继使用。以下就是相关的成果不能只往前走也要及时停下来总结。金仓数据库常用命令检查表所在的schema和object名称-- 查看 sys_config 是什么类型的对象 SELECT n.nspname as schema_name, c.relname as object_name, CASE c.relkind WHEN r THEN table WHEN v THEN view WHEN m THEN materialized view WHEN i THEN index WHEN S THEN sequence WHEN s THEN special WHEN f THEN foreign table WHEN p THEN partitioned table WHEN I THEN partitioned index END as object_type FROM pg_class c LEFT JOIN pg_namespace n ON n.oid c.relnamespace WHERE c.relname sys_config;脚本报错问题处理Get-WmiObject -Class Win32_Process | Where-Object {$_.ProcessId -eq 10864} | Select-Object ProcessId, ParentProcessId, Name杀死进程Stop-Process -Id 36404 -Force通过父进程杀死后有子进程和自己function Stop-ProcessTree { param([int]$ParentPid) # 获取所有子进程 $childProcesses Get-WmiObject -Class Win32_Process | Where-Object {$_.ParentProcessId -eq $ParentPid} # 递归终止所有子进程 foreach ($child in $childProcesses) { Stop-ProcessTree -ParentPid $child.ProcessId } # 终止父进程 Stop-Process -Id $ParentPid -Force Write-Host Terminated process $ParentPid and all its children } # 使用示例 Stop-ProcessTree -ParentPid 10864