pg_basebackup without copying the logs

2018-07-31 Thread Johnes Castro
Hi is there any way to do pg_basebackup without copying the logs? Best Regards, Johnes Castro Tecnisys

Re: pg_basebackup without copying the logs

2018-07-31 Thread Johnes Castro
logging messages. I've noticed that in version 10, you have the -X none option. De: Adrian Klaver Enviado: terça-feira, 31 de julho de 2018 18:57 Para: Johnes Castro; pgsql-gene...@postgresql.org Assunto: Re: pg_basebackup without copying the logs On

Re: pg_basebackup without copying the logs

2018-07-31 Thread Johnes Castro
>Not that I know of. Ok, Thanks for attention. De: Adrian Klaver Enviado: terça-feira, 31 de julho de 2018 19:05 Para: Johnes Castro Cc: pgsql-general Assunto: Re: pg_basebackup without copying the logs On 07/31/2018 01:59 PM, Johnes Castro wrote: Please re

Re: vPgSql

2018-08-17 Thread Johnes Castro
Nice, Very useful. De: Vlad Alexeenkov Enviado: sexta-feira, 17 de agosto de 2018 10:30 Para: pgsql-general@lists.postgresql.org Assunto: vPgSql Maybe will be useful for someone Very simple Postgres SQL client vPgSql: https://vsdev.ru Gogs - Very simple Post

RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version

2018-09-05 Thread Johnes Castro
Hi, This page in the documentation can help you. https://www.postgresql.org/docs/9.2/static/wal-configuration.html Best Regards, Johnes Castro PostgreSQL: Documentation: 9.2: WAL Configuration<https://www.postgresql.org/docs/9.2/static/wal-configuration.html> 29.4. WAL Configuration. The

RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version

2018-09-05 Thread Johnes Castro
1 wal by default occupies 16MB. The parameter in version 9.2 that controls this is: wal_keep_segments By setting the parameter to 10, the maximum size of the US pg_xlog will be 160MB. Best Regards, Johnes Castro De: Johnes Castro Enviado: quarta-feira, 5 de

RE: Estimate time without running the query

2018-09-13 Thread Johnes Castro
Hi netoprbr, Use a command explain analyse. Best Regards. Johnes Castro De: Neto pr Enviado: quinta-feira, 13 de setembro de 2018 19:38 Para: PostgreSQL General Assunto: Estimate time without running the query Dear all, Only a doubt. The Explain command only