pg_basebackup without copying the logs

[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

[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 07/31/2018 01:42 PM, Johnes Castro wrote:
> Hi
>
> is there any way to do pg_basebackup without copying the logs?

Are you talking about the transaction logs(WAL) or the logging messages?

>
> Best Regards,
>
> Johnes Castro
>
> Tecnisys
>


--
Adrian Klaver
adrian.kla...@aklaver.com

Re: pg_basebackup without copying the logs

[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 reply to list also.
Ccing list.
>   logging messages.

Not that I know of.

>
>
>
> 
> *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 07/31/2018 01:42 PM, Johnes Castro wrote:
>> Hi
>>
>> is there any way to do pg_basebackup without copying the logs?
>
> Are you talking about the transaction logs(WAL) or the logging messages?
>
>>
>> Best Regards,
>>
>> Johnes Castro
>>
>> Tecnisys
>>
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com


--
Adrian Klaver
adrian.kla...@aklaver.com

Re: vPgSql

[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 PostGres SQL client vPgSql
vsdev.ru
Шаг 1 дает заготовки скриптов по созданию dblink. При их помощи или без нужно 
создать dblink к БД с которой будем сравнивать, при необходимости нужно 
установить extension




Best regards,
Vlad Alexeenkov

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

[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. There are several WAL-related configuration parameters 
that affect database performance.This section explains their use. Consult 
Chapter 18 for general information about setting server configuration 
parameters.. Checkpoints are points in the sequence of transactions at which it 
is guaranteed that the heap and index data files have been updated with all 
information ...
www.postgresql.org



De: Raghavendra Rao J S V 
Enviado: quarta-feira, 5 de setembro de 2018 15:39
Para: pgsql-general@lists.postgresql.org
Assunto: Max number of WAL files in pg_xlog directory for Postgres 9.2 version

Hi All,

We are using postgres 9.2 verstion database.

Please let me know, how many max number of wal files in pg_xlog directory?

What is the formul. I am seeing different formulas. Could you provide me which 
decides number of max WAL files in PG_XLOG directory for Postgres 9.2 
Database,please?


--
Regards,
Raghavendra Rao J S V

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

[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 setembro de 2018 15:48
Para: Raghavendra Rao J S V; pgsql-general@lists.postgresql.org
Assunto: RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 
version

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. There are several WAL-related configuration parameters 
that affect database performance.This section explains their use. Consult 
Chapter 18 for general information about setting server configuration 
parameters.. Checkpoints are points in the sequence of transactions at which it 
is guaranteed that the heap and index data files have been updated with all 
information ...
www.postgresql.org



De: Raghavendra Rao J S V 
Enviado: quarta-feira, 5 de setembro de 2018 15:39
Para: pgsql-general@lists.postgresql.org
Assunto: Max number of WAL files in pg_xlog directory for Postgres 9.2 version

Hi All,

We are using postgres 9.2 verstion database.

Please let me know, how many max number of wal files in pg_xlog directory?

What is the formul. I am seeing different formulas. Could you provide me which 
decides number of max WAL files in PG_XLOG directory for Postgres 9.2 
Database,please?


--
Regards,
Raghavendra Rao J S V

RE: Estimate time without running the query

[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 estimates the cost of execution of a query, 
and does not estimate time for execution.
I would like know if exists  some way to estimate the time, without running the 
query?

Best Regards
[]`s Neto