PostgreSQL

24 Sep 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 Sep 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 Sep 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 Sep 2024 08:27

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

PostgreSQL

24 Sep 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 Sep 2024 05:41

From what I understand MariaDB is compatible with Wordpress plugins

PostgreSQL

24 Sep 2024 05:38

I would also like to use some Wordpress plugins

PostgreSQL

24 Sep 2024 05:30

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

PostgreSQL

23 Sep 2024 17:43

PostgreSQL Person of the Week interview with: Nicolas Payart

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

PostgreSQL

22 Sep 2024 11:05

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

Online job support and individual/ batch training
Please reach out

PostgreSQL

22 Sep 2024 07:17

I am unable to get libmemcached package on Google

PostgreSQL

21 Sep 2024 20:22

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

PostgreSQL

21 Sep 2024 20:20

Try to install libmemcached

PostgreSQL

21 Sep 2024 20:18

-nothing provides libmemcached.so.11()(64bit) needed by pgpool-II-pg16-4.5betal-1pgdg.rge19.x86_64 from pgpool145

PostgreSQL

21 Sep 2024 19:04

CREATE EXTENSION IF NOT EXISTS ltree WITH SCHEMA public;

CREATE FUNCTION public.escape_ltree(text) RETURNS public.ltree
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$

WITH string AS (
        SELECT array_to_string(array_agg(
                        CASE
                                WHEN chr = '' THEN ''
                                WHEN chr = '_' THEN '__'
                                WHEN chr ~ '[0-9A-Za-z]' THEN chr
                                WHEN strpos('-! "#$%&''()*+,./:;<=>?@[\]^ ^`^y`{|}~\    ', chr) != 0 THEN '_'||substr('0123456789abcdefghijklmnopqrstuvwxyz', strpos('-! "#$%&''()*+,./:;<=>?@[\]^ ^`^y`{|}~\    ', chr), 1)||'_'
                                ELSE '_'||to_hex(ascii(chr))||'_'
                        END), '') AS ee FROM (SELECT regexp_split_to_table($1, '') AS chr) a
        ) SELECT (CASE WHEN length(ee) >= 256 THEN ('_H_'||encode(sha224(convert_to($1, 'UTF8')), 'hex')) ELSE ee END)::ltree FROM string;
$_$;

psql:foxo_blue_schema.sql:718: ERROR:  type "ltree" does not exist                                                  
LINE 12: ...24(convert_to($1, 'UTF8')), 'hex')) ELSE ee END)::ltree FROM...

PostgreSQL

24 Sep 2024 09:22

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

PostgreSQL

24 Sep 2024 09:20

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

PostgreSQL

24 Sep 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 Sep 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 Sep 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 Sep 2024 05:40

and adapt or modify them

PostgreSQL

24 Sep 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 Sep 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 Sep 2024 01:45

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

PostgreSQL

22 Sep 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

21 Sep 2024 20:36

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.

PostgreSQL

21 Sep 2024 20:21

Getting error no match for argument: libmemcached

PostgreSQL

21 Sep 2024 20:20

install the dependenies needed for your pgpool version

PostgreSQL

21 Sep 2024 20:16

While installing pgpool getting error

PostgreSQL

21 Sep 2024 19:03

Hm. Am i hitting a bug?

While restoring my database schema, i have CREATE EXTENSION ltree in both my schema and public, however it fails when a SQL function with ltree in it is defined.