subject:"alter system command"

Re: alter system command

2020-12-27 Thread Adrian Klaver

On 12/27/20 12:00 AM, Ahmet Demir wrote: Hi, Please check postgresql.auto.conf file. https://www.postgresql.org/docs/13/sql-altersystem.html For a more generic option do: select * from pg_settings where name = 'archive_command'; http

Re: alter system command

2020-12-27 Thread Ahmet Demir

Hi, Please check postgresql.auto.conf file. https://www.postgresql.org/docs/13/sql-altersystem.html Ahmet On Sun, 27 Dec 2020 at 10:53, Atul Kumar wrote: > hi, > > I have set archive_command like below: > > alter system set archive_command ='pgbackrest --stanza=main archive-push > %'; > > then

alter system command

2020-12-26 Thread Atul Kumar

hi, I have set archive_command like below: alter system set archive_command ='pgbackrest --stanza=main archive-push %'; then I reloaded the conf file select pg_reload_conf(); now when i checked it using the show command like it gave me correct output postgres=# show archive_command;