postgresql-12 Questions
3
I just upgraded my Postgres from 12 to 15 and I keep getting this error:
template database "template1" has a collation version, but no actual collation version could be determined
Here's ...
Sanctimony asked 15/3, 2023 at 14:34
1
I'm working with a relatively large Postgres db containing several terabytes of data. It consists of data from 5 years back. As a result all the indexes are growing and therefore reducing the query...
Olio asked 10/4, 2024 at 14:8
2
Solved
I'm currently working on a simple dummy project to refresh my knowledge on SQL and to learn a few new things :)
I have a table Article with the columns:
aID, price
I have another table Storag...
Norvol asked 8/11, 2019 at 19:38
3
Solved
I can view the total size of all indexes in a table with
SELECT pg_size_pretty (pg_indexes_size('table_name'));
and the size of a specific index with:
select pg_size_pretty(pg_relation_size('index_...
Handlebar asked 28/7, 2021 at 12:8
2
My understanding of an in-memory table is a table that will be created in memory and would resort to disk as little as possible, if at all. I am assuming that I have enough RAM to fit the table the...
Brashear asked 8/3, 2020 at 2:22
4
Solved
So recently (5th September) the Alpine Linux package repo was updated to postgresql-client 12.4
I'm referencing version 12.3 in my Dockerfile (apk add postgresql-client=~12.3). Is it not possible t...
Isostasy asked 17/9, 2020 at 13:55
3
We have a table of 180m rows, 20 GB in size.
Table DDL is:
create table app.table
(
a_id integer not null,
b_id integer not null,
c_id integer not null,
d_id integer not null,
e_id integer not...
Assailant asked 12/8, 2022 at 9:57
6
Solved
Since today, I get the following error when I try to locally connect to a postgres database (v 12) using knex.js.
Unhandled rejection TimeoutError: Knex: Timeout acquiring a connection. The pool is...
Humbert asked 15/7, 2020 at 9:48
3
Solved
I have Linux Mint 19.2 where I installed the newest PostgreSQL 12 using:
sudo apt-get install postgresql
Similarly, I installed the newest Postgis 3.0.1 using:
sudo apt-get install postgis
I setup ...
Jenninejennings asked 19/6, 2020 at 9:35
4
Solved
I'm trying to code along this React GraphQL TypeScript tutorial
The project uses MikroOrm to communicate with a PostgreSQL database. I have PostgreSQL(12.4) installed on my Ubuntu 18.04, created a ...
Chough asked 27/8, 2020 at 23:0
4
Solved
SQLAlchemy doc explain how to create a partitioned table. But it does not explains how to create partitions.
So if I have this :
#Skipping create_engine and metadata
Base = declarative_base()
cl...
Floria asked 1/5, 2020 at 15:38
1
Solved
TL;DR: we have long-running imports which seem to hold locks on the parent partitioned table even though nothing is directly referencing the parent table.
Background
In our system, we have inventor...
Gelatinous asked 8/4, 2021 at 21:55
3
Solved
Working with Postgres 12 / Windows 10.
Trying to copy a remote database to localhost with the following command:
pg_dump -C -h remotehost -p 5432 -U postgres remotedb | psql -h localhost -p 5432 -U...
Calcification asked 4/2, 2021 at 19:39
3
Solved
Recently, I've started playing around with an old Raspberry Pi 3 b+, and I thought it would be good practice to host a Postgres database on my local network and use it for whatever I want to work t...
Adellaadelle asked 28/1, 2021 at 13:58
1
I have a postgresql server set up on a CentOS 8 machine, and a js program running on the same machine, using the pg library.
const { Pool } = require('pg')
const pool = new Pool({
user: pro...
Warrantable asked 4/2, 2021 at 1:33
1
Solved
I am running the below query in postgres 12.4 :
SELECT (TABLE_SCHEMA || '"."' || TABLE_NAME) as table_name,
pg_size_pretty(pg_table_size(table_name)) as table_size,
pg_size_pretty(pg_...
Oedipus asked 22/12, 2020 at 22:40
1
Solved
I have a table like:
CREATE TABLE foo(bar int)
I have a script which inserts values into that table:
INSERT INTO foo(bar)
VALUES (1), (2), (3.2)
The float value is silently rounded to fit the dat...
Nilson asked 17/9, 2020 at 14:27
1
Solved
How to add Foreign key constraint on array in PostgreSQL?
look_up table for roles
CREATE TABLE party_role_cd
(
party_role_cd bigint NOT NULL,
code character varying(80) NOT NULL,
CONSTRAINT part...
Dammar asked 6/8, 2020 at 1:32
0
I have tried to run Postgres 12 on the docker and the following files I have created. I do not understand where do I made a mistake and what is an issue of PostgreSQL file permission.
Dockerfile:
...
Zeidman asked 17/4, 2020 at 18:19
1
EDIT: I have moved this question over to dba.stackexchange as I have received advice that that community can better address my question.
I have been reading about PostgreSQL's new CTE feature - th...
Humism asked 16/3, 2020 at 6:16
1
I have upgraded Postgres to 12.1, PostGIS to 3.0 and PGAdmin to 4.15. Running queries and using PGAdmin GUI results in some error messages:
ERROR: column rel.relhasoids does not exist
LINE 1: SEL...
Hieratic asked 28/11, 2019 at 17:40
1
I am using PostgreSQL 9.6, and I have a table named "ItemDbModel" with two columns looks like:
No integer,
Content jsonb
Say I put many records like:
"No": 2, {"obj":"x","Item": {"Name": "BigD...
Autoclave asked 9/2, 2017 at 7:34
1
© 2022 - 2025 — McMap. All rights reserved.