Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

2020-01-20 Thread Eric Veldhuyzen
Ron wrote: > On 1/21/20 1:10 AM, Eric Veldhuyzen wrote: >> Hi, >> >> We are using pgbackrest (2.21) to backup out postgresql (11) clusters. >> Last night our nightly diff backup gave me the >> ERROR: unable to convert base 10 string '000B' to unsigned int. >> I tried if a full backup would fix

Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

2020-01-20 Thread Ron
On 1/21/20 1:10 AM, Eric Veldhuyzen wrote: Hi, We are using pgbackrest (2.21) to backup out postgresql (11) clusters. Last night our nightly diff backup gave me the ERROR: unable to convert base 10 string '000B' to unsigned int. I tried if a full backup would fix this, but it didn't. Maybe

pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

2020-01-20 Thread Eric Veldhuyzen
Hi, We are using pgbackrest (2.21) to backup out postgresql (11) clusters. Last night our nightly diff backup gave me the ERROR: unable to convert base 10 string '000B' to unsigned int. I tried if a full backup would fix this, but it didn't. Luckily this was only on our development/test clus

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

2020-01-20 Thread Ramesh Penuballi
Hi Ron, Issue has been resolved after checking the postgresql connector installation location on the Jenkins server. Thank you so much for you help and looking into the issue. Thanks and Regards Ramesh Penuballi On Mon, 20 Jan, 2020, 11:30 Ramesh Penuballi, wrote: > Hi Ron, > > I have checke

Re: pg_prepared_statements

2020-01-20 Thread David G. Johnston
On Mon, Jan 20, 2020 at 8:00 PM rob stone wrote: > max_prepared_transactions = 6 is the value set in postgresql.conf. > This has nothing to do with the feature that the pg_prepared_statements view tracks. It is for the two-phase commit prepared transactions, not prepared statements. https://ww

Re: pg_prepared_statements

2020-01-20 Thread David G. Johnston
On Mon, Jan 20, 2020 at 8:00 PM rob stone wrote: > Hello, > > PostgreSQL 11.6 (Debian 11.6-2~sid1) on x86_64-pc-linux-gnu, compiled > by gcc (Debian 9.2.1-21) 9.2.1 20191130, 64-bit > > Is there something awry with the pg_prepared_statements view? > This is the only row found and it is NOT create

pg_prepared_statements

2020-01-20 Thread rob stone
Hello, PostgreSQL 11.6 (Debian 11.6-2~sid1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 9.2.1-21) 9.2.1 20191130, 64-bit Is there something awry with the pg_prepared_statements view? This is the only row found and it is NOT created by the application. namestatement prepare_time

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

2020-01-20 Thread Ron
Where is JENKINS installed, and where is Postgres installed?  Are they on the same server? On 1/20/20 12:00 AM, Ramesh Penuballi wrote: Hi Ron, I have checked on my Jenkins server.bashrc and. bashprofiles filed of root and Jenkins users but  didn't find anything about postgresql path. It mig

Re: A question about rules

2020-01-20 Thread stan
On Sun, Jan 19, 2020 at 08:52:36AM -0800, Adrian Klaver wrote: > On 1/19/20 2:32 AM, stan wrote: > Please post to list also. > Ccing list. > > > On Sat, Jan 18, 2020 at 08:56:06AM -0800, Adrian Klaver wrote: > > > On 1/18/20 8:53 AM, stan wrote: > > > > So, I just discovered the rules system. As I

Questions about how to streaming replication (pg 9.2)

2020-01-20 Thread Ekaterina Amez
Hi all, After your comments about how to upgrade postgres from 9.2 to 9.6 in an overloaded server I've been learning and testing streaming replication. But the info I've found about this topic is not enough for me (or I'm not able to completely understand it). (I'm bad with terminology as I'