Re: Postgres Version Upgrade to 14.1 error

2022-02-04 Thread rob stan
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 naps

Postgres Version Upgrade to 14.1 error

2022-02-03 Thread rob stan
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 o

Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility

2021-06-04 Thread rob stan
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

symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility

2021-06-04 Thread rob stan
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

Setting wal_keep_segments parameter

2021-05-09 Thread rob stan
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