2634
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
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?
I did try to search but couldn’t find any steps for same @NickBluth
Читать полностью…
Yea the SP Returns nothing ,thanks for the input we neeed to chekc the function
Читать полностью…
Since both will cause a brief downtime, upgrade them at the same time. I don't really see what special documentation would be needed... 🤷
Читать полностью…
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
Читать полностью…
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
Читать полностью…
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?
Читать полностью…
Excuse me someone has installed postgis in postgres 13.12 in S.O open suse 15.4 y do not find repository
Читать полностью…
Hi guys anyone have maintenance tasks cron job such reindexe or vacuum that need to be applied on PostgreSQL
Читать полностью…
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/
Notabug, generally.
(Well, maybe pg_dump would have to deal with that sometimes).
Set search_path in your function to include public. pg_dump explicitly resets it to nothing.
Getting error no match for argument: libmemcached
Читать полностью…
install the dependenies needed for your pgpool version
Читать полностью…
Which flavour?
And are you using the PGDG packages?
Major or minor upgrade? In the easiest way (just minor update for both) it's essentially yum update
orapt update; apt upgrade
Yes we are planning for same time upgrade, i did not mean any special document , like can I have steps
Читать полностью…
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?
Читать полностью…
Hello everyone
Do any one have upgrade documents of pgpool along with Postgres upgrade
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
From what I understand MariaDB is compatible with Wordpress plugins
Читать полностью…
I would also like to use some Wordpress plugins
Читать полностью…
https://mariadb.com/products/enterprise/comparison/
Читать полностью…
PostgreSQL Person of the Week interview with: Nicolas Payart
https://postgresql.life/post/nicolas_payart/
For any sql , BI tools (SSIS SSRS, Power BI)
Online job support and individual/ batch training
Please reach out
I am unable to get libmemcached package on Google
Читать полностью…
search for it then and find a github repository for pgpool specifically, u will find a lot talking about different issues surely u will find a match for your reuqest if it is a common issue or just pull your logs on it and wait for answers
Читать полностью…
-nothing provides libmemcached.so.11()(64bit) needed by pgpool-II-pg16-4.5betal-1pgdg.rge19.x86_64 from pgpool145
Читать полностью…