金仓老旧项目改造-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