Re: incoorect restore_command

2021-02-25 Thread Michael Paquier
On Thu, Feb 25, 2021 at 06:03:57PM +0900, Fujii Masao wrote: > Regarding the section "Standalone Hot Backups", all the directories and > file seem to be placed under /var/lib/pgsql, so at least for me it looks a bit > strange to change only the path of archive directory. So I don't think that > we

Re: set auto commit is not working

2021-02-25 Thread Magnus Hagander
On Thu, Feb 25, 2021 at 5:06 PM PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/ecpg-sql-set-autocommit.html > Description: > > I tested with " PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc >

set auto commit is not working

2021-02-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ecpg-sql-set-autocommit.html Description: I tested with " PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit" The result is below. pos

Re: incoorect restore_command

2021-02-25 Thread Fujii Masao
On 2021/02/25 15:54, Michael Paquier wrote: On Wed, Feb 24, 2021 at 08:15:59PM +0900, Fujii Masao wrote: But I have one question; why do those commands use different archive directories? Isn't it better to use the same one? storage.sgml uses /var/lib/pgsql/data for the location of the data,