Sympa 사용자 추가 via DB 조작

# su postgres

postgres@lists:/root$ psql
psql (14.11 (Ubuntu 14.11-0ubuntu0.22.04.1))
Type "help" for help.
postgres=# \l
                              List of databases
   Name    |  Owner   | Encoding | Collate |  Ctype  |   Access privileges
-----------+----------+----------+---------+---------+-----------------------
  sympa     | postgres | UTF8     | C.UTF-8 | C.UTF-8 |

postgres=# \c sympa
You are now connected to database "sympa" as user "postgres".
sympa=# \dt
               List of relations
 Schema |         Name          | Type  | Owner
--------+-----------------------+-------+-------
 public | admin_table           | table | sympa
 public | conf_table            | table | sympa
 public | exclusion_table       | table | sympa
 public | inclusion_table       | table | sympa
 public | list_table            | table | sympa
 public | logs_table            | table | sympa
 public | netidmap_table        | table | sympa
 public | notification_table    | table | sympa
 public | one_time_ticket_table | table | sympa
 public | session_table         | table | sympa
 public | stat_counter_table    | table | sympa
 public | stat_table            | table | sympa
 public | subscriber_table      | table | sympa
 public | user_table            | table | sympa
(14 rows)

sympa=# SELECT * FROM subscriber_table WHERE list_subscriber='test-notice';
| date_epoch_subscriber | list_subscriber | number_messages_subscriber | reception_subscriber | robot_subscriber  | subscribed_subscriber | update_epoch_subscriber |    user_subscriber    | visibility_subscriber
+-----------------------+-----------------+----------------------------+----------------------+-------------------+-----------------------+-------------------------+-----------------------+-----------------------
|            1709168481 | test-notice     |                          0 | mail                 | lists.kreonet.net |                     1 |              1709168481 | gdhong@kisti.re.kr    | noconceal