如何修改supabase中pg的参数文件

##

如何修改supabase中pg的参数文件

1、尝试修改

[root@supabase docker]# docker exec -it supabase-db bash

root@9d7b87eeaf0b:/# vi /etc/postgresql/postgresql.conf
bash: vi: command not found

root@9d7b87eeaf0b:/# vim /etc/postgresql/postgresql.conf
bash: vim: command not found

root@9d7b87eeaf0b:/# nano /etc/postgresql/postgresql.conf
bash: nano: command not found

2、修改过程

[root@supabase ~]# cd /supabase/
[root@supabase supabase]# docker cp supabase-db:/etc/postgresql/postgresql.conf .
Successfully copied 30.2kB to /supabase/.

[root@supabase supabase]# vi postgresql.conf
shared_buffers = 1GB

[root@supabase supabase]# cd /root/supabase/docker/

[root@supabase docker]# vi docker-compose.yml
  db:
	...
    volumes:
	  ...
      # modify postgresql.conf
      - /supabase/postgresql.conf:/etc/postgresql/postgresql.conf

3、检查

[root@supabase docker]# psql -U postgres -h 127.0.0.1
Password for user postgres:
psql (15.12, server 15.8)
Type "help" for help.

postgres=# show shared_buffers ;
 shared_buffers
----------------
 1GB
(1 row)