On Wed, Oct 9, 2019 at 3:59 PM Guy Burgess wrote:
> The manual says:
> https://www.postgresql.org/docs/current/sql-createtrigger.html
>
> A column list cannot be specified when requesting transition relations.
>
> And (I think the same point):
>
> The standard allows transition tables to be used
On 5/3/20 3:33 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/3/20 3:11 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/3/20 2:53 PM,
Looks like you did not shutdown the 12 instance.
--
Adrian Klaver
adrian.klaver@
This is weird because "systemctl staus postgresql-12.service" shows that
t
Adrian Klaver-4 wrote
> On 5/3/20 3:11 PM, TalGloz wrote:
>> Adrian Klaver-4 wrote
>>> On 5/3/20 2:53 PM,
>>>
>>> Looks like you did not shutdown the 12 instance.
>>>
>>> --
>>> Adrian Klaver
>>
>>> adrian.klaver@
>>
>>
>> This is weird because "systemctl staus postgresql-12.service" shows that
On 5/3/20 3:11 PM, TalGloz wrote:
Adrian Klaver-4 wrote
On 5/3/20 2:53 PM,
Looks like you did not shutdown the 12 instance.
--
Adrian Klaver
adrian.klaver@
This is weird because "systemctl staus postgresql-12.service" shows that the
service is dead.
It is now:
"The database server was
Adrian Klaver-4 wrote
> On 5/3/20 2:53 PM,
>
> Looks like you did not shutdown the 12 instance.
>
> --
> Adrian Klaver
> adrian.klaver@
This is weird because "systemctl staus postgresql-12.service" shows that the
service is dead.
Best regards,
TalGloz
--
Sent from: https://www.postgresql-
On 5/3/20 2:53 PM, TalGloz wrote:
I'm in the process to update my Postgres 10 to 12 (it's my first server
upgrade). I've shutdown my Postgres 10 using "systemctl stop
postgresql-10.service" and "systemctl status postgresql-10.service" says:
Active: inactive (dead) since Sun 2020-05-03 22:51:46 CE
I'm in the process to update my Postgres 10 to 12 (it's my first server
upgrade). I've shutdown my Postgres 10 using "systemctl stop
postgresql-10.service" and "systemctl status postgresql-10.service" says:
Active: inactive (dead) since Sun 2020-05-03 22:51:46 CEST;
After that I've started the upg
On 2020-05-02 12:23:29 +0200, Matthias Apitz wrote:
> So the question remains: What I have to move by tar to get the cluster
> setup on the new host, but without the databases in it?
What exactly do you mean by "the cluster [setup], but without the
databases in it"? What do you want to preserve th
Will setting max_parallel_workers_per_gather to 0
(In fact, no parallel queries)
Solve this issue?
I can sustain the slowness.
We are on 11.5, and the fix is on 11.6.
-Original Message-
From: Tom Lane
Sent: Sunday, May 03, 2020 5:37 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql
Tom Lane-2 wrote
> TalGloz <
> glozmantal@
> > writes:
>> Andrew Gierth wrote
>>> I didn't see an easy way of disabling bitcode emission for a module,
>>> though I think that has been discussed before.
>
> After taking a quick look through pgxs.mk, it looks like you might
> be able to do somethi
On 5/3/20 7:28 AM, Abraham, Danny wrote:
Is there a way to eliminate postmaster crash/core ?
A surge in short-term connections eventually crashes PG on "no free slots in
PMChildFlags array".
Happens on AIX 7.2
=>grep "2020-05-02 08:16" * | grep clients | wc -l
0
=>grep "2020-05-02 08
"Abraham, Danny" writes:
> Is there a way to eliminate postmaster crash/core ?
> A surge in short-term connections eventually crashes PG on "no free slots in
> PMChildFlags array".
Update to a current release, maybe? We fixed a bug with symptoms like
that last fall [1].
Is there a way to eliminate postmaster crash/core ?
A surge in short-term connections eventually crashes PG on "no free slots in
PMChildFlags array".
Happens on AIX 7.2
=>grep "2020-05-02 08:16" * | grep clients | wc -l
0
=>grep "2020-05-02 08:17" * | grep clients | wc -l
0
=>gre
TalGloz writes:
> Andrew Gierth wrote
>> I didn't see an easy way of disabling bitcode emission for a module,
>> though I think that has been discussed before.
After taking a quick look through pgxs.mk, it looks like you might
be able to do something like
override with_llvm := no
in your
Hi,
Is there cluster index in PG ? Do we have Indexed Organized Table concepts
of Oracle in PG ?
Braj
Andrew Gierth wrote
>> "TalGloz" == TalGloz <
> glozmantal@
> > writes:
>
> TalGloz> Which is good, my seal_mean_cxx_v2.so being created and copied
> TalGloz> to /usr/pgsql-12/lib/. But right after that I get this and it
> TalGloz> doesn't seem to effect my seal_mean_cxx_v2.so library:
>
> "TalGloz" == TalGloz writes:
TalGloz> Which is good, my seal_mean_cxx_v2.so being created and copied
TalGloz> to /usr/pgsql-12/lib/. But right after that I get this and it
TalGloz> doesn't seem to effect my seal_mean_cxx_v2.so library:
What's happening here is that it's attempting to b
Adrian Klaver-4 wrote
> On 5/2/20 4:03 PM, TalGloz wrote:
>
> Did you?
>
> In Makefile below I see:
>
> #PG_LDFLAGS= -L$(INCLUDE_SEAL_LIB) -lseal -pthread
> # Seal linker flags
> SEAL_LDFLAGS = -L$(INCLUDE_SEAL_LIB) -lseal -pthread
>
> --
> Adrian Klaver
> adrian.klaver@
It actually didn't
18 matches
Mail list logo
