Re: Issue with a query while running on a remote host

2021-08-31 Thread Ninad Shah
Hi Karsten, I apologize for the delayed response. There is no script-related transfer happening here. It creates an issue while using "bash@" inside a column. Regards, Ninad Shah On Fri, 27 Aug 2021 at 12:35, Karsten Hilbert wrote: > Deep packet inspection naively scanning for potential > fr

Re: Issue with a query while running on a remote host

2021-08-31 Thread David G. Johnston
On Tuesday, August 31, 2021, Ninad Shah wrote: > Hi Karsten, > > I apologize for the delayed response. > > There is no script-related transfer happening here. It creates an issue > while using "bash@" inside a column. > >> >> That wasn’t what was meant. Ignore the “why” for the moment, the theor

prevent WAL replication to fill filesystem

2021-08-31 Thread basti
Hello, I have a old PG 9.6 with WAL replication. for some reason the rsync was failed and the filesystem was filled by pg_xlog files. As result PG stops working. Is there a way to prevent WAL replication to fill filesystem by xlog files in case of failure? Best regards

Re: prevent WAL replication to fill filesystem

2021-08-31 Thread Laurenz Albe
On Tue, 2021-08-31 at 10:36 +0200, basti wrote: >  have a old PG 9.6 with WAL replication. > for some reason the rsync was failed and the filesystem was filled by > pg_xlog files. > As result PG stops working. > > Is there a way to prevent WAL replication to fill filesystem by xlog > files in case

Re: prevent WAL replication to fill filesystem

2021-08-31 Thread Jehan-Guillaume de Rorthais
On Tue, 31 Aug 2021 10:53:45 +0200 Laurenz Albe wrote: > On Tue, 2021-08-31 at 10:36 +0200, basti wrote: > >  have a old PG 9.6 with WAL replication. > > for some reason the rsync was failed and the filesystem was filled by > > pg_xlog files. > > As result PG stops working. > > > > Is there a wa

Re: Can't locate Ora2Pg.pm while executing export_schema.sh

2021-08-31 Thread Peter J. Holzer
On 2021-08-17 10:34:28 -0400, Mladen Gogala wrote: > You should locate Ora2Pg.pm using "find" like this: > > [mgogala@umajor ~]$ find /usr/local -name Ora2Pg.pm > /usr/local/share/perl5/5.32/Ora2Pg.pm > [mgogala@umajor ~]$ > > and then make sure that your PERL5LIB directory contains  the location

Running into hangs with logical replication

2021-08-31 Thread Magri, Sebastian
Hey folks! We've been having some issues with logical replication. After some time running and streaming messages to 1 client, it seemingly hangs. We don't see the sent_lsn value increase anymore, so the client itself doesn't seem to ever get new messages and thus doesn't send any feedback. Wh

echo of \C foo

2021-08-31 Thread Matt Zagrabelny
Greetings, I am using the \C command in psql to set a title for my table. psql is echoing 'Title is "foo"'. $ \C foo Title is "foo". How do I suppress the echo of "Title is..." from psql? Thanks for any help! Cheers, -m

Re: echo of \C foo

2021-08-31 Thread Tom Lane
Matt Zagrabelny writes: > $ \C foo > Title is "foo". > How do I suppress the echo of "Title is..." from psql? The -q switch would do it ... regards, tom lane

Re: echo of \C foo

2021-08-31 Thread Matt Zagrabelny
On Tue, Aug 31, 2021 at 11:10 AM Tom Lane wrote: > > Matt Zagrabelny writes: > > $ \C foo > > Title is "foo". > > > How do I suppress the echo of "Title is..." from psql? > > The -q switch would do it ... Thank you, Tom! -m