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
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 |