oracle to postgresql conversion tool

Hi, there are at least 5 tools I found on the PG list but could you recommend well tested, free one ? we need to migrate production 30GB oracle 11 db to postgres 9 and are looking for best approach. Of course if there is no free/open solution any commercial & recommended tool is always welcome.

why postgres process takes so much memory during day time

Hi all, is there any way to figure out why particular postgres process takes more and more memory during the day? This process performes order data queries coming from order management system - exchange system. Normally it's about 0,5mln messages per day but after aprox 4h postgres process

some questions regarding replication issues and timeline/history files

Hello, I've created synchronous replication between Primary and Secondary server and put pacemaker + PAF over. Client is doing some stress tests (switching nodes, disabling particular node, etc) and it's second time when this kind of problem occoures : 2020-12-18 14:03:46.658 CET [unknown]

Re: pg_upgrade from 12 to 13 failes with plpython2

_validator | $libdir/plpgsql | pltcl | t | t | pltcl_call_handler | | | $libdir/pltcl | pltclu | f | f | pltclu_call_handler | | | $libdir/pltcl | plperl | t | t | plperl_call_handler | plperl_inline_handler | plperl_validator | $libdir/plperl | plperlu | f | f | plperlu_call_handler | plperlu_inli

Re: pg_upgrade from 12 to 13 failes with plpython2

st argosrm=# drop extension plpython2u; ERROR: extension "plpython2u" does not exist Od: "Tom Lane" Do: "Marcin Giedz" DW: "Laurenz Albe" , "Magnus Hagander" , "Adrian Klaver" , "Devrim Gündüz" , "pgsql-genera

Re: pg_upgrade from 12 to 13 failes with plpython2

loadable_libraries.txt could not load library "$libdir/plpython2": ERROR: could not access file "$libdir/plpython2": No such file or directory In database: argosrm In database: template1 Thx M. Od: "Laurenz Albe" Do: "Marcin Giedz" , "Magnus

Re: pg_upgrade from 12 to 13 failes with plpython2

[ please don't top-post, it makes conversations unreadable ] Marcin Giedz writes: > so look at this: > postgres=# drop extension plpython; > ERROR: extension "plpython" does not exist > postgres=# drop extension plpythonu; > ERROR: extension "plpythonu"

Re: pg_upgrade from 12 to 13 failes with plpython2

> anyway got this from your query: > 16402 | plpython_call_handler | 11 | 10 | 13 | 1 | 0 | 0 | - | f | f | f | f > | f | v | u | 0 | 0 | 2280 | | | | | | | plpython_call_handler | > $libdir/plpython2 | | > 16403 | plpython_inline_handler | 11 | 10 | 13 | 1 | 0 | 0 | - | f | f | f | > t | f

pg_upgrade from 12 to 13 failes with plpython2

Hi all, trying to performe upgrade from 12 to 13 installed from Centos8 repo gives such error: cat loadable_libraries.txt could not load library "$libdir/plpython2": ERROR: could not access file "$libdir/plpython2": No such file or directory digging around: 1. drop extension plpythonu;

Re: pg_upgrade from 12 to 13 failes with plpython2

erlu_inline_handler | plperlu_validator | $libdir/plperl | plpython3u | f | f | plpython3_call_handler | plpython3_inline_handler | plpython3_validator | $libdir/plpython3 | (6 rows) what can I do next ? Thx Marcin Od: "Adrian Klaver" Do: "Devrim Gündüz" , "To

restore with pg engine upgrade in a middle

Hi, the case is: one day we did full backup of database version 12 using standard procedure of continuous backup so: pg_start_backup/rsync/pg_stop_backup snip of WAL files archive directory: ver 12 PG Jul 28 04:37 000103340004 Jul 28 04:41 000103340005 Jul 28 05:16

Re: Performance degradation after upgrading from 9.5 to 14

how about this: jit = off ? Marcin On Wed, 17 Apr 2024 at 19:33, Johnathan Tiamoh wrote: > 1) How did you upgrade? pg_dump or pg_upgrade? > > I use pg_ugrade with kink option. > > 2) Did you run ANALYZE to collect statistics after the upgrade? > > > Yes. I ran vacuumdb-analyze in stages