PgBackRest : Restore to a checkpoint shows further transactions

List, PgBackRest : I tried to restore the latest backup taken at my RepoServer to a testing EPAS server freshly deployed . I have a full backup, two diff and one INCR as on today morning. The latest one is INCR full backup: 20240922-232733F timestamp start/stop: 2024-09-2

MError after replication in postgresql

Hi Team, We are getting error after doing replication on posrgresql 16.3 (OS is HP UX) error is regarding Libpq library, we are unable to start sync getting error FATAL: could not connect to the primary server : libpq is incorrectly linked to backend functions. LOG: waiting for WAL to become avai

Re: Issues with PostgreSQL Source Code Installation

Ayush Vatsa writes: > So actually I wanted to modify and playaround with the code, > hence I am using the github repo and building postgres from it. Seems reasonable. The tip of master branch is occasionally broken, but seldom for very long, and none of our buildfarm animals are reporting failur

Re: Issues with PostgreSQL Source Code Installation

> I would go to the source link I posted download a specific version and > verify it builds. Then you know whether your setup is correct. Then you > could go back to exploring the Git code. Thanks will check that out

Re: Issues with PostgreSQL Source Code Installation

On 9/24/24 09:32, Ayush Vatsa wrote: > Why are you building against the repo instead  of a fixed version from > here?: So actually I wanted to modify and playaround with the code, hence I am using the github repo and building postgres from it. > Did you checkout a given tag? I haven't checkou

Re: Issues with PostgreSQL Source Code Installation

> Why are you building against the repo instead of a fixed version from > here?: So actually I wanted to modify and playaround with the code, hence I am using the github repo and building postgres from it. > Did you checkout a given tag? I haven't checkout on any branch and currently on branch ma

Re: Repeatable Read Isolation Level "transaction start time"

On 9/24/24 09:12, Ron Johnson wrote: Makes sense.  Never would have occurred to me to try and change the isolation level using a second SET TRANSACTION statement, though. From the docs: https://www.postgresql.org/docs/current/sql-set-transaction.html The SET TRANSACTION command sets the char

Re: Issues with PostgreSQL Source Code Installation

On 9/24/24 04:14, Ayush Vatsa wrote: Hi PostgreSQL Community, I am encountering an issue while trying to install PostgreSQL from its source code and would appreciate any guidance you can provide. Here are the steps I've taken so far: sudo yum install libicu-devel git clone git://git.postgresql

Re: Repeatable Read Isolation Level "transaction start time"

On Tue, Sep 24, 2024 at 12:06 PM Adrian Klaver wrote: > On 9/24/24 05:59, Ron Johnson wrote: > > On Tue, Sep 24, 2024 at 8:29 AM David G. Johnston > > mailto:david.g.johns...@gmail.com>> wrote: > > > > On Monday, September 23, 2024, Wizard Brony > > wrote: >

Re: Repeatable Read Isolation Level "transaction start time"

On 9/24/24 05:59, Ron Johnson wrote: On Tue, Sep 24, 2024 at 8:29 AM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Monday, September 23, 2024, Wizard Brony mailto:wizardbr...@gmail.com>> wrote: https://www.postgresql.org/docs/16/transaction-iso.html#XACT-REPEATABL

Re: Repeatable Read Isolation Level "transaction start time"

Wizard Brony writes: > But in my testing, I find that according to that statement, the transaction > start time is actually "the start of the first non-transaction-control > statement in the transaction" (as mentioned earlier in the section). Is my > conclusion correct, or am I misunderstanding

Re: Repeatable Read Isolation Level "transaction start time"

On Tue, Sep 24, 2024 at 8:29 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, September 23, 2024, Wizard Brony wrote: > >> >> https://www.postgresql.org/docs/16/transaction-iso.html#XACT-REPEATABLE-READ >> >> The PostgreSQL documentation for the Repeatable Read Isolation Lev

Re: Repeatable Read Isolation Level "transaction start time"

On Monday, September 23, 2024, Wizard Brony wrote: > https://www.postgresql.org/docs/16/transaction-iso.html# > XACT-REPEATABLE-READ > > The PostgreSQL documentation for the Repeatable Read Isolation Level > states the following: > > “UPDATE, DELETE, MERGE, SELECT FOR UPDATE, and SELECT FOR SHARE

Issues with PostgreSQL Source Code Installation

Hi PostgreSQL Community, I am encountering an issue while trying to install PostgreSQL from its source code and would appreciate any guidance you can provide. Here are the steps I've taken so far: sudo yum install libicu-devel git clone git://git.postgresql.org/git/postgresql.git ./configure --ena

Repeatable Read Isolation Level "transaction start time"

https://www.postgresql.org/docs/16/transaction-iso.html#XACT-REPEATABLE-READ The PostgreSQL documentation for the Repeatable Read Isolation Level states the following: “UPDATE, DELETE, MERGE, SELECT FOR UPDATE, and SELECT FOR SHARE commands behave the same as SELECT in terms of searching for ta