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
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
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]
> 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
[ 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"
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
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
_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
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
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;
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
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.
12 matches
Mail list logo