# linux 系统命令介绍

linux 系统命令介绍

# 获取占用内存及cpu 最高的前10个进程

#### `ps -eo pid,comm,%cpu,%mem --sort=-%cpu,-%mem | head -n 11`

### ps aux | head -1; ps aux | sort -rn -k4 | head -10

# pgsql 导入导出sql 命令

### 导入：

```
.\pg_restore.exe -h 150.158.170.111 -p 5432 -U postgres -d electronic_filing_system -v D:\sql\full_backup.dump

```

```
psql -U postgres -d electronic_filing_system    -f /home/electronic_filing_system.sql

```

### 导出具体表

```
.\pg_restore.exe -h 150.158.170.111 -p 5432 -U postgres -d electronic_filing_system -t sys_form -v D:\sql\full_backup.dump

```

### 导出：

```
.\pg_dump.exe -h localhost -p 5432 -U postgres -d electronic_filing_system --format=custom -f D:\sql\full_backup.dump

```

- **与版本无关的**
    
    ```cmd
    pg_dump --inserts --encoding=UTF8 -U postgres -h 150.158.170.111 -p 5432 -d electronic-filing-release  -s -c --if-exists -t payment_mx  -f D:/sql/payment_mx.sql
    
    ```
    
    
    - `-s` 只导出表结构，导出数据时可以去掉 `-s` 参数

### 修改字段

```sql
ALTER TABLE public.ynw_invoice_item
    ALTER COLUMN tax_rate TYPE numeric(10, 5)
	USING tax_rate::numeric;

```

### 修改主键为identity的主键编号开始值

```sql
ALTER TABLE archive_menu_sublist ALTER COLUMN id RESTART SET START WITH 2060;

```