PostgreSQL

24 September 2024 21:14

Excuse me someone has installed postgis in postgres 13.12 in S.O open suse 15.4 I do not find repository

PostgreSQL

24 September 2024 11:57

Your pgpool should get upgraded through the "dnf/yum update".

PostgreSQL

24 September 2024 11:54

https://www.postgresql.org/docs/14/pgupgrade.html
"pg_upgrade supports upgrades from 9.0.X and later to the current major release of PostgreSQL, including snapshot and beta releases."

PostgreSQL

24 September 2024 11:46

Rhel, yes sir we are using pgdg packages

PostgreSQL

24 September 2024 09:44

Hello All,

I need to complete certification on postgres DBA. Could anyone guide me what certification are available and how can I complete that. Is there any dumps available?

PostgreSQL

24 September 2024 09:22

I did try to search but couldn’t find any steps for same @NickBluth

PostgreSQL

24 September 2024 09:20

Yea the SP Returns nothing ,thanks for the input we neeed to chekc the function

PostgreSQL

24 September 2024 09:03

Since both will cause a brief downtime, upgrade them at the same time. I don't really see what special documentation would be needed... 🤷

PostgreSQL

24 September 2024 05:57

We are calling this trough API call , it throws error as rows_to_jason due to which not able to see any output from the store procedure

PostgreSQL

24 September 2024 05:43

However I would like to know where would PostgreSQL would standout over MariaDB for my use case considering that the web applications would be developed from scratch

PostgreSQL

24 September 2024 05:40

and adapt or modify them

PostgreSQL

24 September 2024 05:35

I am trying to decide what RDBMS would suit better the development of a series of web applications that intend to digitalise a medical clinic that has no online management systems and only has a Wordpress site. On one hand MariaDB is a drop in replacement to MySQL and has the power of a procedural language that could come in quite handy for the web applications that would be developed on the other hand PostgreSQL is advertised as more robust. I am new to both MariaDB and PostgreSQL. The medical clinic is a small company with great potential to grow. Could someone point me in the right direction?

PostgreSQL

24 September 2024 04:10

Excuse me someone has installed postgis in postgres 13.12 in S.O open suse 15.4 y do not find repository

PostgreSQL

23 September 2024 01:45

Hi guys anyone have maintenance tasks cron job such reindexe or vacuum that need to be applied on PostgreSQL

PostgreSQL

22 September 2024 10:58

https://rpmfind.net/linux/rpm2html/search.php?query=libmemcached.so.11()(64bit)

The packagers have an issue tracker. You could (and probably should!) ask there as well, maybe the deps of the RPM can be improved...:
https://redmine.postgresql.org/projects/pgrpms/

PostgreSQL

24 September 2024 11:59

and if one upgardes to 15+, then lower bound is 9.2 https://github.com/postgres/postgres/commit/e469f0aaf3c586c8390bd65923f97d4b1683cd9f

PostgreSQL

24 September 2024 11:56

And
https://www.endpointdev.com/blog/2022/10/upgrading-postgresql-14-to-15-on-fedora-centos-rocky-alma-linux/
basically list the necessary steps (you'll obvioulsy have to replace 15 with 14 and 14 with 9.x).

PostgreSQL

24 September 2024 11:50

And can we also directly upgrade from 9.x to 14.x or should I go for incremental upgrade ?

PostgreSQL

24 September 2024 11:45

Which flavour?
And are you using the PGDG packages?

PostgreSQL

24 September 2024 09:35

Major or minor upgrade? In the easiest way (just minor update for both) it's essentially
yum update
or
apt update; apt upgrade

PostgreSQL

24 September 2024 09:21

Yes we are planning for same time upgrade, i did not mean any special document , like can I have steps

PostgreSQL

24 September 2024 09:07

So the SP returns nothing? Then we'll need to see the procedure (a function, actually, but...) or you'll have to debug it. Did you check the changelogs of 13 and 14 for (breaking) changes in PL handling?

PostgreSQL

24 September 2024 08:27

Hello everyone
Do any one have upgrade documents of pgpool along with Postgres upgrade

PostgreSQL

24 September 2024 05:56

Hello PALS
I have upgraded my Postgres from 12 to 14.7 after the upgrade I am facing issue with one of my stored procedure

PostgreSQL

24 September 2024 05:41

From what I understand MariaDB is compatible with Wordpress plugins

PostgreSQL

24 September 2024 05:38

I would also like to use some Wordpress plugins

PostgreSQL

24 September 2024 05:30

https://mariadb.com/products/enterprise/comparison/

PostgreSQL

23 September 2024 17:43

PostgreSQL Person of the Week interview with: Nicolas Payart

https://postgresql.life/post/nicolas_payart/

PostgreSQL

22 September 2024 11:05

For any sql , BI tools (SSIS SSRS, Power BI)

Online job support and individual/ batch training
Please reach out

PostgreSQL

22 September 2024 07:17

I am unable to get libmemcached package on Google