Setting wal_keep_segments parameter
Hello , I want to set wal_keep_segments parameter to a value but what should be the process I follow? I have archiving process on all clusters is on but when a sudden process comes to postgres wal files will be bigger than i assume. I don't know what I should do. Could you please help me? Thanks.
symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility
Hello all, I have a problem with connecting database via psql;/usr/lib/9.6/bin/psql: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility OS :Debian GNU/Linux 9 I tried setting it didn't help; export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/postgresql/9.6/lib Can anyone please help me?
Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility
Hi Tom ; Thank you for your detailed email. rob stan writes: > I have a problem with connecting database via psql;/usr/lib/9.6/bin/psql: > symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: > PQsetErrorContextVisibility Apparently psql is linking to a pre-9.6 copy of libpq.so. You could confirm that with ldd /usr/lib/9.6/bin/psql You're absolutely right i have bad linking for it to old version 9.5 in the same node. Here they are ; linux-vdso.so.1 (0x7ffc4594e000) libpq.so.5 => /usr/lib/postgresql/9.5/lib/libpq.so.5 (0x7fe79f2c2000) libedit.so.2 => /usr/lib/x86_64-linux-gnu/libedit.so.2 (0x7fe79f08a000) libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x7fe79ed86000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x7fe79e9e7000) libssl.so.1.1 => /usr/lib/x86_64-linux-gnu/libssl.so.1.1 (0x7fe79e77b000) libcrypto.so.1.1 => /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 (0x7fe79e2e) libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x7fe79e0c3000) libncurses.so.5 => /lib/x86_64-linux-gnu/libncurses.so.5 (0x7fe79dea) libtinfo.so.5 => /lib/x86_64-linux-gnu/libtinfo.so.5 (0x7fe79dc76000) libbsd.so.0 => /lib/x86_64-linux-gnu/libbsd.so.0 (0x7fe79da61000) /lib64/ld-linux-x86-64.so.2 (0x7fe79f77f000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7fe79d85d000) librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x7fe79d655000) > I tried setting it didn't help; export > LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/postgresql/9.6/lib (1) Are you sure there's a more up-to-date libpq.so there? That path doesn't seem to square with where you say psql is. (2) Possibly you need to put the 9.6 directory first not last. You mean linking like 9.5 as below right ? libpq.so.5 => /usr/lib/postgresql/9.5/lib/libpq.so.5 (will add version 9.6 link ,too if i got it right) (3) If that still doesn't work, you need to configure the system's dynamic linker to look there. You really want to do that anyway, as messing with LD_LIBRARY_PATH all the time is no fun. See "man ldconfig". I tried but i think i missed something. Appreciate it. Tom Lane , 4 Haz 2021 Cum, 18:44 tarihinde şunu yazdı: > rob stan writes: > > I have a problem with connecting database via psql;/usr/lib/9.6/bin/psql: > > symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: > > PQsetErrorContextVisibility > > Apparently psql is linking to a pre-9.6 copy of libpq.so. You could > confirm that with > ldd /usr/lib/9.6/bin/psql > > > I tried setting it didn't help; export > > LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/postgresql/9.6/lib > > (1) Are you sure there's a more up-to-date libpq.so there? > That path doesn't seem to square with where you say psql is. > > (2) Possibly you need to put the 9.6 directory first not last. > > (3) If that still doesn't work, you need to configure the system's > dynamic linker to look there. You really want to do that anyway, > as messing with LD_LIBRARY_PATH all the time is no fun. > See "man ldconfig". > > regards, tom lane >
Postgres Version Upgrade to 14.1 error
Hello, We have "pgq" extensions on our clusters when I am trying to upgrade from 9.6.24 to 14.1 with pg_upgrade --link method, i am getting error; First i was getting this error ; could not load library "$libdir/pgq_lowlevel": ERROR: could not access file "$libdir/pgq_lowlevel": No such file or directory could not load library "$libdir/pgq_triggers": ERROR: could not access file "$libdir/pgq_triggers": No such file or directory After i copied pgq files to extension directory; /usr/lib/postgresql/9.6/lib# cp pgq_lowlevel.so /usr/lib/postgresql/14.1/lib/ /usr/lib/postgresql/9.6/lib# cp pgq_triggers.so /usr/lib/postgresql/14.1/lib/ I am getting this error message; could not load library "$libdir/pgq_triggers": ERROR: could not load library "/usr/lib/postgresql/14.1/lib/pgq_triggers.so": /usr/lib/postgresql/14.1/lib/pgq_triggers.so: undefined symbol: elog_finish Do you have any ideas on how to solve this problem? Thanks!
Re: Postgres Version Upgrade to 14.1 error
Thanks Pavel. Do you know pgq is compatible with postgresql-server-dev-14 packages? I couldn't see any requirements or something documented for pgq and postgres 14. Pavel Stehule , 4 Şub 2022 Cum, 01:17 tarihinde şunu yazdı: > Hi > > pá 4. 2. 2022 v 7:02 odesílatel rob stan napsal: > >> Hello, >> >> We have "pgq" extensions on our clusters when I am trying to upgrade from >> 9.6.24 to 14.1 with pg_upgrade --link method, i am getting error; >> >> >> First i was getting this error ; >> >> could not load library "$libdir/pgq_lowlevel": ERROR: could not access >> file "$libdir/pgq_lowlevel": No such file or directory >> could not load library "$libdir/pgq_triggers": ERROR: could not access >> file "$libdir/pgq_triggers": No such file or directory >> >> After i copied pgq files to extension directory; >> /usr/lib/postgresql/9.6/lib# cp pgq_lowlevel.so >> /usr/lib/postgresql/14.1/lib/ >> /usr/lib/postgresql/9.6/lib# cp pgq_triggers.so >> /usr/lib/postgresql/14.1/lib/ >> >> I am getting this error message; >> could not load library "$libdir/pgq_triggers": ERROR: could not load >> library "/usr/lib/postgresql/14.1/lib/pgq_triggers.so": >> /usr/lib/postgresql/14.1/lib/pgq_triggers.so: undefined symbol: elog_finish >> >> >> Do you have any ideas on how to solve this problem? >> > > PostgreSQL extensions are compiled against one specific major release - so > you cannot use pgq for 9.6 in Postgres 14. You should install pgq for > PostgreSQL 14. > > Regards > > Pavel > > >> Thanks! >> >
