Use this tag to indicate that your question is about PostgreSQL version 15. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-15]
112 questions
0
votes
0 answers
ZeosDBO SQL Logic Errors
Trying to solve my issue and I noticed that there are not much info about the possible errors regarding SQL Logic error on ZeosDBO, most errors are regarding SQLite, that's not my case. So I decided to start this thread hopefully it'll be used by…
Mobius one
- 171
- 3
- 12
0
votes
0 answers
Issues while converting query from Oracle to PostgreSQL query using XMLTable function
I am trying to convert a oracle query to postgreSQL but not much clarity in documentation for our use case. Below query filter the xml in doc column but when trying to convert to Postgres i am not able achieve the same functionality
select colA,…
Gaurav
- 33
- 8
0
votes
0 answers
psql: error: could not connect to server: could not connect to server: Operation timed out Is the server running on host "***" and accepting TCP/IP
I have a VPS server that I just installed Postgres in and set up. When I tried to connect remotely, I get the error:
psql: error: could not connect to server: could not connect to server: Operation timed out
Is the server running on host…
Benito
- 181
- 1
- 9
0
votes
0 answers
Citus logs show error after upgrade to 11.2
I have upgraded Citus extension from 10.2 to 11.2 running on postgres version 14. I disabled the version checks for citus and was able to apply the extension to database for the coordinator and workers nodes and than on coardinator node, I did run…
Devaddy
- 45
- 6
0
votes
8 answers
Error while installing Apache AGE on macOS with PostgreSQL Interactive installer by EDB
I recently downloaded the PostgreSQL Interactive installer by EDB from the official website (https://www.postgresql.org/download/macosx/) and successfully installed it in the Macintosh HD Library folder. Following the instructions in a YouTube video…
Muhammad Suhaib
- 23
- 4
0
votes
0 answers
Postgres ShmemHash Extension
I try to develop a little Postgresql shared hash extension, just to store constant values to an key. This is onetime loaded and can be accessed by any connected client.
Not really a rocket-science.
#include "postgres.h"
#include "fmgr.h"
#include…
Nik
- 53
- 1
- 9
0
votes
1 answer
pgp_pub_decrypt function fails after upgrade from PostgreSQL 12 to PostgreSQL 15
I have a weird behaviour after upgrading our database server from Postgresql 12 to Postgresql 15. I created all the required extensions with pgcrypto even the same version 1.3.
It looks like the pgp decryption function with pgp_pub_decrypt works…
Niels
- 193
- 2
- 13
0
votes
1 answer
PostgreSQL: count all grouped by month including gaps
I have a pretty simple query to do - a table has a date field and I need to select count of all rows, grouped by month including gaps.
I have the following query that works for days, but it does not work for month
SELECT f.date::date as period,…
Majesty
- 2,097
- 5
- 24
- 55
0
votes
0 answers
What can I do to troubleshoot Django's failure to connect to Postgres in Docker-Compose on Ubuntu server?
I am trying to deploy my django app on Ubuntu server. It is actually working on localhost with windows machine. Dockerfile
# pull official base image
FROM python:3.11.2-slim-buster
# set working directory
WORKDIR /usr/src/app
# set environment…
0
votes
0 answers
migrating from PostgreSQL 14 to PostgreSQL 15
is it possible to restore the backup taken from PostgreSQL 14 to 15, I am taking backup using pg_basebackup
We are also migrating from centos to ubuntu.
Please advice, thank you
Raju
- 27
- 5
0
votes
0 answers
Error: initdb failed | PostgreSQL Update from 13.6 to 15.3
I want to update my postgresql13.6 to latest one (15.3 for now).
Steps I followed :
I'm using AWS, I create Image from the instance[ ubuntu ] (runs postgresql 13.6)
From AMIs, I launch a new instance
Postgresql 13.6 is working fine
I used the…
kumardippu
- 599
- 4
- 11
0
votes
1 answer
Can postgresql use console apps for calculations?
I need to calculate a value for each row in my database. The calculation is quite involved, requiring lookup tables and parameters that are stored in the database too.
Now I know I can write an app, connect to the server, and calculate the value for…
Markus Winter
- 13
- 8
0
votes
1 answer
INSERT into table ON CONFLICT increase other column value -> column reference is ambigous? SOLVED
I have a large sourceTable (300 Million rows) with several columns:
id sequence orientation gc_content – etc
most sequences appear only once in the table, but others might be in there much more often
I need to know how often each sequence appears…
Markus Winter
- 13
- 8
0
votes
0 answers
table name is generated in lowercase and underscore when using spring boot and postgresql
package com.example.demoo.domain;
import jakarta.persistence.*;
@Entity(name = "RedFlag")
@Table(name = "RedFlag")
public class RedFlag {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "red_flag_id")
private…
0
votes
2 answers
The specified module could not be found. Postgres 15.2 with timescale 2.10.3
I am trying to add timescaledb extension in my postgres 15.2 with timescale 2.10.3.
When I run the command
create extension if not exists timescaledb;
I get below message
could not load library "C:/Program…
Amit Kumar
- 591
- 2
- 8
- 24