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
pgAdmin4: An error message appears before app successfully loads and opens in Windows 10, what to do?
Some more details to help you guys see what is exactly the problem.
pgAdmin4: 7.4
Chromium: 92.0.4515.107
PostgreSQL: 15
NW.js: 0.55.0
OS: Windows 10-10.0.19045-SP0
Related problem (I think):
I am developing a node.js API that connects to a…
migsm
- 91
- 1
- 5
0
votes
1 answer
Grouping by calculated experience in PostgreSQL
In my PostgreSQL database, I have the following table:
CREATE TABLE public.experiences (
id bigint NOT NULL,
consultant_profile_id bigint NOT NULL,
position character varying NOT NULL,
years INTEGER NOT NULL
);
--Consultant Profile #1…
Mateusz Urbański
- 7,352
- 15
- 68
- 133
0
votes
0 answers
Sorted index not being used in ORDER BY
Consider the following table structure:
create table feed
(
id bigserial primary key,
event_date timestamp(0) not null,
...
);
create index feed_event_date_index on feed (event_date desc);
And the following query:
explain…
Majesty
- 2,097
- 5
- 24
- 55
0
votes
1 answer
Can I build Postgres 15 binaries on Linux so that they work on any distribution?
Previously, binary files of Postgres 10 could be downloaded from the site and they worked on any Linux. I need to build binaries for Postgres 15 in the same way so that they work on any distributions.
cd…
evstratovkirill
- 11
- 1
0
votes
0 answers
PostgreSQL COPY Syntax Failure (My issue - PostgreSQL is fine)
I'm sure it is obvious that I am a "NEWB" - gotta start somewhere, right? Having an issue understanding how to implement PostgreSQL COPY as depicted in the image below: PostgreSQL COPY Error
Here's the query I attempted to run:
COPY…
BEB_1963
- 1
- 1
0
votes
0 answers
Need to find all views in a database which reference a certain table, cannot get this to work
Good morning.
I would be grateful if someone could help with the following issue I am having on PostgreSQL v15.2 on AWS RDS.
This is an AWS managed instance, in the dev environment, we have a number of users creating tables and views in about 10…
0
votes
2 answers
Object already exists errors while restoring a clean pg_dump
I am creating pg dump of a database using following command:
pg_dump mydatabase -Fc -c -U mydatabaseuser -f mydatabase_pgdump_$(date +^CY%m%dT%H%M")
Then i am trying to to restore that dump using following:
pg_restore -d mydatabase -U postgres…
Maven
- 14,587
- 42
- 113
- 174
0
votes
1 answer
Barman Backup failed issuing start backup command
barman backup pg
$ barman list-server
pg - Backup PostgreSQL Database (via SSH)
---
$ barman check pg
Server pg:
PostgreSQL: OK
superuser or standard user with backup privileges: OK
wal_level: OK
directories: OK
…
khaled ghazy
- 1
- 2
0
votes
1 answer
pgAdmin 4 is stuck in one page. How can solve this problem?
I have tried to install postgresql multiple times. My environment is Window 11 and the postgresql version is 15.3 winx86-64. The installation completed but when I run pgadmin, it just stuck in one page.enter image description here
Is there any…
Moinul Islam
- 3
- 1
0
votes
1 answer
Django new entry fetching previous entry in Postgres and not creating a new one
This is my first time here, and I'm trying to develop an app for a personal project (journal app) using Django and Postgres. When I use the Shell method, I am able to create a new entry into a table defined in my Postgres DB. However, when using the…
Misael Lopez
- 1
- 1
0
votes
0 answers
How to access the local files to restore in remotely accessed PgAdmin4 in centos 8
I have one Web Server with PHP and one Database Server with PostgreSQL 15. Both with Cent OS 8. I have installed pgadmin4 in the web server to access the Remote Database server through browser and it's accessible.
Now with the help of PgAdmin4 I can…
Jayanta Kumar Nath
- 27
- 1
- 10
0
votes
0 answers
How to allow user to create/delete/ all privileges to any database that starts with a prefix (PG 15)?
For example,
User potato can only create and delete databases that starts with abc_ .
The purpose is to allow a CI process to create/delete prefixed databases on a shared postgresql cluster. So I want to limit the permission of this user to only be…
thclpr
- 5,778
- 10
- 54
- 87
0
votes
0 answers
postgresql-setup --upgrade failure trying to upgrade databases from postgresql 14 to postgresql 15 on Fedora 38
Trying to update postgresql using the postgresql-setup package I get the following log file:
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is the…
ivanistuk
- 1
- 1
0
votes
1 answer
What is the postgres user that is setup by the PostgreSQL@15 homebrew formula?
Background
I am new to Postgres and currently going through the documentation as I'm learning to use it. I am having trouble understanding the Postgres user.
I noticed that I can run psql postgres without inputting any kind of password, and I have…
GeorgeCiesinski
- 191
- 1
- 3
- 11
0
votes
1 answer
Connection issue from Lambda to RDS PostgreSQL 15
In RDS PotgreSQL 12, I can connect to DB using psycopg2 from local and also from Lambda function.
But when I upgrade to RDS PotgreSQL 15, I cannot connect to DB from Lambda anymore (I still can connect from local though).
The error that Lambda gives…
LoMaPh
- 1,476
- 2
- 20
- 33