At Thu, 3 Mar 2022 07:46:45 +, pgdba pgdba
wrote in
> I have a problem from pg_wal. I am using postgresql version 11 and taking
> backup and writing archive_command in postgresql.conf but did not archive wal
> and my disk ise full from pg_wal. I research why is my wal is full and dont
> f
Hi, thanks your feedback but not have same error in my log file. I am using
streaming replication and have 1 master and 2 slave nodes in async. master node
different size file wal from slave nodes such as;
[root@master1 pg_wal]# ls | wc -l
6400
[root@slave2 pg_wal]# ls | wc -l
332
[root@slave3 pg
On Thu, Mar 3, 2022 at 2:17 PM pgdba pgdba wrote:
>
> Hi, thanks your feedback but not have same error in my log file. I am using
> streaming replication and have 1 master and 2 slave nodes in async. master
> node different size file wal from slave nodes such as;
> [root@master1 pg_wal]# ls | wc
Hi, I created an table with composite type array as datatype for one column.
When I query that table I need the pg_typeof(column) as record[] instead of
composite_type[].
I tried creating a separate function and returning record[], but below error
is thrown,
ERROR: PL/pgSQL functions cannot retur
Hi
čt 3. 3. 2022 v 11:01 odesílatel Suresh Kumar R
napsal:
> Hi, I created an table with composite type array as datatype for one
> column.
> When I query that table I need the pg_typeof(column) as record[] instead of
> composite_type[].
> I tried creating a separate function and returning recor
Hi,
given this simple example:
postgres=# create table t ( a int );
CREATE TABLE
postgres=# create index i on t(a);
CREATE INDEX
postgres=# select pg_relation_filepath('i');
pg_relation_filepath
--
base/5/16388
(1 row)
postgres=# \! oid2name --oid 16388
>From database "post
Hi,
I know it's going to be most likely due to glibc and locales, but I found
interesting case that I can't figure out how to fix.
We have pg 12.6 on bionic. Works. Added focal replica (binary).
Replicates OK, but then fails when I try to pg_dump -s.
Error is:
pg_dump: error: query failed: serv
On Thu, Mar 03, 2022 at 04:04:28PM +0100, hubert depesz lubaczewski wrote:
> and it worked, so I'm kinda at loss here.
based on some talk on IRC, I was able to get stack trace from fail:
(gdb) bt
#0 0xfffe4a36e4d8 in ?? ()
#1 0xbe03ffb8 in ExecProcNode (node=0xe4f87cf8) at
./bu
Suresh Kumar R writes:
> When I query that table I need the pg_typeof(column) as record[] instead of
> composite_type[].
Why? record[] is considered a pseudotype (polymorphic type),
which is why casting to it doesn't do anything.
regards, tom lane
On Thu, Mar 03, 2022 at 04:11:56PM +0100, hubert depesz lubaczewski wrote:
> On Thu, Mar 03, 2022 at 04:04:28PM +0100, hubert depesz lubaczewski wrote:
> > and it worked, so I'm kinda at loss here.
>
> based on some talk on IRC, I was able to get stack trace from fail:
Based on the stack trace I
On Thu, Mar 03, 2022 at 05:39:21PM +0100, hubert depesz lubaczewski wrote:
> On Thu, Mar 03, 2022 at 04:11:56PM +0100, hubert depesz lubaczewski wrote:
> > On Thu, Mar 03, 2022 at 04:04:28PM +0100, hubert depesz lubaczewski wrote:
> > > and it worked, so I'm kinda at loss here.
> >
> > based on so
On Thu, Mar 3, 2022 at 09:29:56AM +0200, Levente Birta wrote:
> Hello
>
> For many years when I get a new server every time I tested the storage
> system with diskchecker.pl for power loss.
>
> I'm just curious if there is any other/newer tool to test ?
I have never found one, and had to hunt t
On 3 March 2022 08:46:45 CET, pgdba pgdba wrote:
>Hi ,
>
>I have a problem from pg_wal. I am using postgresql version 11 and taking
>backup and writing archive_command in postgresql.conf but did not archive wal
>and my disk ise full from pg_wal. I research why is my wal is full and dont
>found
13 matches
Mail list logo
