De: Tom Lane
Enviado: sexta-feira, 13 de novembro de 2020 17:58
Para: Edson Richter
Cc: David G. Johnston ; pgsql-general
Assunto: Re: Range partitioning and overlap
Edson Richter writes:
> Further on the documentation: "When creating a range partition, the lower
> bound specifie
De: David G. Johnston
Enviado: sexta-feira, 13 de novembro de 2020 17:32
Para: Edson Richter
Cc: pgsql-general
Assunto: Re: Range partitioning and overlap
On Fri, Nov 13, 2020 at 1:29 PM Edson Richter
mailto:edsonrich...@hotmail.com>> wrote:
"Range Partitioning
The table is parti
Hi,
Using PostgreSQL 13.1 - I need your guidance about corretly implementing
partition by timestamp ranges.
Looking at documentation (
https://www.postgresql.org/docs/13/ddl-partitioning.html ) there a statement
saying explicit
"Range Partitioning
The table is partitioned into “ranges” defin
Is there any standard PostgreSQL driver for Go language?
Do members of this group could share experiences with Go + PostgreSQL
development?
Thanks,
E.R.
De: Tom Lane
Enviado: segunda-feira, 15 de junho de 2020 22:24
Para: Edson Richter
Cc: pgsql-general
Assunto: Re: How to double-quote a double quoted identifier?
Edson Richter writes:
> How do I remote execute que following command:
> CREATE EXTENSION "uuid-ossp"
>
How do I remote execute que following command:
CREATE EXTENSION "uuid-ossp"
SCHEMA public
VERSION "1.1";
I'm using PostgreSQL 9.6, Linux x64, and bash.
I've tried the following:
ssh -l postgres -2 -C -p 2022 192.168.0.70 "psql -h 127.0.0.1 -d test_db -p
5432 -c \"CREATE EXTENSION "
-- Mensagem original--
De: Ravi Krishna
Data: qui, 21 de mai de 2020 18:50
Para:
Cc:PostgreSQL Mailing Lists;
Assunto:Re: Table partitioning for cloud service?
>
> The database/schema per tenant solution can be tedious when you want to
> modify something on the structure and you have n
De: Alvaro Herrera
Enviado: quarta-feira, 1 de abril de 2020 23:38
Para: Edson Richter
Cc: pgsql-general
Assunto: Re: It is possible to force periodically switch xlog?
On 2020-Apr-02, Edson Richter wrote:
> Actually, I do have a stand by server I wish
Apr 2020 21:09:20 -0400, David Steele wrote in
> On 4/1/20 7:19 PM, Edson Richter wrote:
> > IIRC archive_timeout does precisely that.
> > I would assume that "archive_mode" must be "on" or "always" - but I do
> > have "archive_mode=of
De: David Steele
Enviado: quarta-feira, 1 de abril de 2020 22:09
Para: Edson Richter ; pgsql-general
Cc: Alvaro Herrera
Assunto: Re: It is possible to force periodically switch xlog?
On 4/1/20 7:19 PM, Edson Richter wrote:
>
> IIRC archive_timeou
De: Alvaro Herrera
Enviado: quarta-feira, 1 de abril de 2020 19:55
Para: Abdul Sayeed
Cc: Edson Richter ; pgsql-general
Assunto: Re: It is possible to force periodically switch xlog?
On 2020-Apr-02, Abdul Sayeed wrote:
> Hi Edson,
>
> You can switch
I would like to know if there is any parameter I can set to force postgres to
switch xlog periodically, even if it not reach the 16MB size?
Thanks,
Edson.
De: Paul Förster
Enviado: quarta-feira, 25 de março de 2020 11:42
Para: Edson Richter
Cc: pgsql-general
Assunto: Re: How to query "primary_slot_name" in slave server?
Hi Edson,
query the following on the replica:
pg_stat_wal_receiver
Perfect, thanks!
Edson
Cheers,
Paul
&g
Hi!
I've been searching over the net, but cannot find a reference.
I know that in server I can execute "select * from pg_replication_slots" and
get all created slots.
But how can I query slave to know wich primay slot it is connecting to?
Thanks in advance,
Edson
De: Adrian Klaver
Enviado: domingo, 23 de fevereiro de 2020 15:42
Para: Edson Richter ; pgsql-general
Assunto: Re: Replication: slave server has 3x size of production server?
On 2/23/20 8:04 AM, Edson Richter wrote
De: Adrian Klaver
Enviado: sábado, 22 de fevereiro de 2020 20:34
Para: Edson Richter ; pgsql-general
Assunto: Re: Replication: slave server has 3x size of production server?
On 2/22/20 2:51 PM, Edson Richter wrote:
>
> Yes, it is working. Last X'
De: Adrian Klaver
Enviado: sábado, 22 de fevereiro de 2020 18:12
Para: Edson Richter ; pgsql-general
Assunto: Re: Replication: slave server has 3x size of production server?
On 2/22/20 11:23 AM, Edson Richter wrote
De: Adrian Klaver
Enviado: sábado, 22 de fevereiro de 2020 16:16
Para: Edson Richter ; pgsql-general
Assunto: Re: Replication: slave server has 3x size of production server?
On 2/22/20 11:03 AM, Edson Richter wrote
De: Adrian Klaver
Enviado: sábado, 22 de fevereiro de 2020 15:50
Para: Edson Richter ; pgsql-general
Assunto: Re: Replication: slave server has 3x size of production server?
On 2/22/20 10:05 AM, Edson Richter wrote
De: Adrian Klaver
Enviado: sábado, 22 de fevereiro de 2020 14:33
Para: Edson Richter ; pgsql-general
Assunto: Re: Replication: slave server has 3x size of production server?
On 2/22/20 9:25 AM, Edson Richter wrote:
> Hi!
>
> I've a database clus
Hi!
I've a database cluster created at 9.6.10 linux x64 server rhel. I made
progressive upgrades, first upgrading slave and then upgrading master.
Actually both are running 9.6.17.
Current production server has 196Gb in size.
Nevertheless, the replicated (slave) server has 598 Gb in size.
Replica
21 matches
Mail list logo
