On Tue, 12 Nov 2019 at 00:45, Mimiko wrote:
> There could be not sub-partition by fromhost. Only by syslogtag, then by year.
>
> So how could be this accomplished both in version 8.4 and in version 12.
> Other ideas are welcome.
>
> The main goal is to be able to quickly investigate logs from som
Any one can give some advice?
On 11.11.2019 13:45, Mimiko wrote:
Hello.
I beg for the community ideas on how to do in the best way.
I use centrally storing syslog messages in Postgres. All devices send syslog messages to a server (or could be several in fault tolerance) which use
rsyslog to s
Hello Devrim.
Thank you for your help!
I have been able to install PostgreSQL 12.1(rpm) on CentOS 8.0(without
python2).
It has also possible to install on CentOS 7.6(without python3).
Best Regards,
Keisuke Kuroda
2019年11月17日(日) 10:40 Devrim Gündüz :
>
> Hi,
>
> On Fri, 2019-09-27 at 09:38 -0400
Hello,
we are using logical replication from PostgreSQL 10.8 (Ubuntu
10.8-1.pgdg14.04+1) to PostgreSQL 11.3 (Ubuntu 11.3-1.pgdg18.04+1). Thre
are 1305 replicated tables within 3 schemas. The tables are from small
almost static lookup tables to larger tables up to ~40GB holding 44
millions of row
On 2019-11-18 12:24:40 +, Geoff Winkless wrote:
> On Mon, 18 Nov 2019 at 11:46, Michael Paquier wrote:
> > On Mon, Nov 18, 2019 at 10:27:24AM +0100, Josef Šimánek wrote:
> > > This is clear once you understand what does it mean. I was aware of
> > > VERBOSE
> > > option of EXPLAIN and tried t
On Mon, Nov 18, 2019 at 1:01 PM Miles Elam
wrote:
> I was under the impression that PostgreSQL 12 removed this limitation. Was
> this incorrect?
>
> https://www.2ndquadrant.com/en/blog/postgresql-12-foreign-keys-and-partitioned-tables/
>
Yeah, as the comments in that article make clear, the new
I was under the impression that PostgreSQL 12 removed this limitation. Was
this incorrect?
https://www.2ndquadrant.com/en/blog/postgresql-12-foreign-keys-and-partitioned-tables/
On Mon, Nov 18, 2019 at 9:58 AM Michael Lewis wrote:
> On Mon, Nov 18, 2019 at 10:10 AM Shatamjeev Dewan
> wrote:
>
>
Hello,
I'm using PostgreSQL 10.5 on Linux (RHEL). I'm new to administering
PostgreSQL and recently installed pgaudit. I believe I have it installed
correctly and wanted to start playing with it to see how exactly it works.
So while walking through a tutorial I found online, I saw where I can ent
Thanks a lot Michael. Get well soon.
From: Michael Lewis
Sent: November-18-19 12:57 PM
To: Shatamjeev Dewan
Cc: pgsql-general
Subject: Re: ERROR: there is no unique constraint matching given keys for
referenced table "audit_p"
On Mon, Nov 18, 2019 at 10:10 AM Shatamjeev Dewan
mailto:sde...@n
On 11/18/19 9:10 AM, Shatamjeev Dewan wrote:
Hi Michael,
I am trying to create a foreign key constraint on a table : audit_param
in postgres 12 which references partitioned table audit_p. is there
anyway to get rid of this error.
*ERROR: there is no unique constraint matching given keys fo
On Mon, Nov 18, 2019 at 10:10 AM Shatamjeev Dewan wrote:
> I am trying to create a foreign key constraint on a table : audit_param in
> postgres 12 which references partitioned table audit_p. is there anyway to
> get rid of this error.
>
>
>
*ERROR: there is no unique constraint matching given
Hi Michael,
I am trying to create a foreign key constraint on a table : audit_param in
postgres 12 which references partitioned table audit_p. is there anyway to get
rid of this error.
ERROR: there is no unique constraint matching given keys for referenced table
"audit_p"
Oh I see. I was working as if no match was the same as ts_rank=0.
Great advice. Thank you very much.
On Sat, Nov 16, 2019 at 2:22 PM Jeff Janes wrote:
> On Fri, Nov 15, 2019 at 1:31 AM Javier Ayres wrote:
>
>> Hi everybody.
>>
>> I'm implementing a solution that uses PostgreSQL's full text sea
On Mon, 18 Nov 2019 at 11:46, Michael Paquier wrote:
> On Mon, Nov 18, 2019 at 10:27:24AM +0100, Josef Šimánek wrote:
> > This is clear once you understand what does it mean. I was aware of VERBOSE
> > option of EXPLAIN and tried to use it without needed parentheses (the same
> > way EXPLAIN can u
On Fri, Nov 15, 2019 at 03:17:17PM -0500, Dave Hughes wrote:
> Thanks for replying guys! You both led me down the right path. I didn't
> realize it, but looks like we had 2 directories where psql was installed.
> Once I gave the path specifically to PostgreSQL10, it worked like a charm.
>
> I'm
On Mon, Nov 18, 2019 at 10:27:24AM +0100, Josef Šimánek wrote:
> This is clear once you understand what does it mean. I was aware of VERBOSE
> option of EXPLAIN and tried to use it without needed parentheses (the same
> way EXPLAIN can understand it). In the parameter list of REINDEX, it is
> still
On Mon, 2019-11-18 at 01:29 +0100, Ivan Sergio Borgonovo wrote:
> On 11/15/19 4:16 PM, Tom Lane wrote:
> > Ivan Sergio Borgonovo writes:
> > > Horde (webmail and more) is not anymore compatible with postgresql 12
> > > after pg_attrdef was dropped.
> >
> > We didn't drop the whole catalog, just t
po 18. 11. 2019 v 7:42 odesílatel Michael Paquier
napsal:
> On Sun, Nov 17, 2019 at 04:41:59AM +0100, Pavel Stehule wrote:
> > Documentation patch is good idea.
>
> The documentation is rather clear about the need to of parenthesis
> when using the VERBOSE option, and that it is not a mandatory o
18 matches
Mail list logo
