Re: pg_dumpall - restoration problem

Tony Bazeley writes: > I've a problem with restoring a cluster created with pg_dump_all from 14.8 > ( pg_dumpall >pgall.out and then psql -f pgall.out postgres). > ... > Attempting to restore to postgresql-16 results in errors > 2024-04-05 22:17:15.418 ACDT [6565] postgres@tonbaz ERROR:

pg_dumpall - restoration problem

I've a problem with restoring a cluster created with pg_dump_all from 14.8 ( pg_dumpall >pgall.out and then psql -f pgall.out postgres). pgall.out was recovered after a hardware failure on the hosting machine. Attempting to restore to postgresql-16 results in errors . . .

Re: Moving delta data faster

On 4/6/24 13:04, yudhi s wrote: On Sat, Apr 6, 2024 at 10:25 PM Adrian Klaver > wrote: Your original problem description was: "Then subsequently these rows will be inserted/updated based on the delta number of rows that got inserted/updated in

Re: Moving delta data faster

On Sat, Apr 6, 2024 at 10:25 PM Adrian Klaver wrote: > > Your original problem description was: > > "Then subsequently these rows will be inserted/updated based on the > delta number of rows that got inserted/updated in the source database. > In some cases these changed data can flow multiple

Re: About postgres pg_upgrade

On Fri, Apr 5, 2024 at 09:41:05AM +0200, Daniel Gustafsson wrote: > > On 5 Apr 2024, at 06:47, Rama Krishnan wrote: > > > Could you please explain me how does pg_upgrade works one of my friends it > > works based on pg_restore I am bit confused > > The documentation does a fairly good job

Re: Moving delta data faster

On 4/6/24 08:47, yudhi s wrote: Thank you Adrian, Greg and Veem. I tried writing a small routine to see how the performance differs in these four approaches i.e. Upsert VS traditional update+insert VS Merge vs Truncate+load. Initially I was thinking Upsert will perform the same as Merge as

Re: Moving delta data faster

Thank you Adrian, Greg and Veem. I tried writing a small routine to see how the performance differs in these four approaches i.e. Upsert VS traditional update+insert VS Merge vs Truncate+load. Initially I was thinking Upsert will perform the same as Merge as the logic looks similar but it seems

Re: Moving delta data faster

On Fri, 5 Apr 2024 at 06:10, Adrian Klaver wrote: > > > S3 is not a database. You will need to be more specific about '... > then > > from the S3 it will be picked and gets merged to the target postgres > > database.' > > > > > > The data from S3 will be dumped into the stage table

Parallel GIN index?

Any plans for $subject? -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com www.visena.com