alter system command

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: alter system command
Date: 2020-12-27 07:53:16
Message-ID: CA+ONtZ4pF1abRLQ4dwaEy58+1F8SWpG=Msfa-tgUU-ge0Hgv9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;
archive_command
-----------------------------------------
pgbackrest --stanza=main archive-push %

but...

while checking the postgresql.conf file it didn't show me above
output, the parameter acrhive_command is still set with default value

archive_command = '/bin/true/' # command to use to archive a
logfile segment

So please help me in giving the reason of it that even after reloading
the conf file why it didn't set the value in postgresql.conf file ?

Regards,
Atul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ahmet Demir 2020-12-27 08:00:47 Re: alter system command
Previous Message Guyren Howe 2020-12-26 22:15:36 Re: Multi-column index vs index on individual columns