Stack Overflow
Stack Overflow

Questions tagged [postgresql-14]

Use this tag to indicate that your question is about PostgreSQL version 14. Questions concerning database administration should go to https://dba.stackexchange.com/

227 questions
0
votes
2 answers

Unused index in PostgreSQL

I'm learning indexing in PostgreSQL now. I started trying to create my index and analyzing how it will affect execution time. I created some tables with such columns: also, I filled them with data. After that I created my custom index: create…
Dark_Phoenix
  • 368
  • 3
  • 14
0
votes
0 answers

I have an error in Postgresql building a trigger and cannot seem to find a solution

I am working in PGAdmin4, learning postgresql (yes, I am still green to this), and trying to build a trigger for a project. Everything seems to be working well until I get to the create trigger: CREATE OR REPLACE TRIGGER Mail_List_upd BEFORE…
Samuel Wright
  • 55
  • 8
0
votes
1 answer

Resolving PostgresSQL install on Mac Pro (macOS Monterey)

I need help connecting my postgreSQL14 EDB Download to terminal on mac. Download was successful but... when I type psql at terminal as below I receive this message: ~ » psql zsh: command not found:…
Simon Hall
  • 17
  • 2
0
votes
0 answers

Pgpool standby server's status is "down" some time after starting replication with online recovery

I have setup a 2 server cluster system using this configuration examples. They are in the same LAN. Master is node 0 on 192.168.1.31, slave is node 1 on 192.168.1.32. The problem is that approximately 10 minutes after I started streaming…
Ozan Başkan
  • 51
  • 1
  • 7
0
votes
0 answers

facing problems with psycopg2 django

My python version is 3.10 and postgre version is 14 I am working on django, there I got an issue that is: my settings.py 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'testdb', 'USER':…
EducatedLegend
  • 1
  • 2
0
votes
0 answers

WHERE on normal varchar column fails for some values, but works with trim, lower, ILIKE

I have a SQL table that looks like this (irrelevant parts excluded): # \d users Table "public.users" Column | Type | Collation | Nullable | …
Sahib
  • 223
  • 1
  • 10
0
votes
1 answer

Postgres full text search dictionary strip special charachters

I'm using postgres full text search for (amoung other things) to provide autocomplete functionality for usernames and tags. However, I'd like autocomplete to match the column value 'dashed-tag-example' against a ts_query like 'dashedtag:*'. My…
Peter Gerdes
  • 2,288
  • 1
  • 20
  • 28
0
votes
1 answer

change default postgresql.conf location on ubuntu

I can't seem to find a way to change the default location of postgresql.conf file from /etc/postgresql/14/main/postgresql.conf to my/own/location/postgresql.conf. I am running postgresql on Ubuntu server. I tried changing it using the postgres…
Shery
  • 1,808
  • 5
  • 27
  • 51
0
votes
0 answers

How to dis-connect and then re-connect a postgres tablespace?

Is it possible to dis-connect and re-connect a POSTGRES tablespace and all the associated objects within that tablespace? I have a Postgres database with two tablespaces, one on a high-speed SSD drive (I've named this FASTSPACE) , and the other on a…
ConanTheGerbil
  • 677
  • 8
  • 21
0
votes
3 answers

Is there any alternative to the ```\d+``` to describe database schema in PGSQL 14?

I want to describe a table schema in postgresql 14. However when I use the older \d+, the error is thrown: pgsql=# \d+ ERROR: column c.relhasoids does not exist LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity,…
Sahil Naphade
  • 1
0
votes
0 answers

FATAL: password authentication failed for user "username" in PostgreSQL

I'm new to PostgreSQL. I just installed the Postgres.app on my Mac and wanted to use the psql command in the terminal. However, when I type psql in the terminal, I'm asked to input the password. I was never asked to set a password during…
Kai Li
  • 55
  • 1
  • 7
0
votes
1 answer

Why does PgAdmin 4 (v 6.1) not allow me to Add Data in the GUI>

I am using PgAdmin4 v 6.1 on Mac OSX Monterrey 12.1 and I cannot add data in the GUI. Why can i not add the data? I created my first table in the Gui And defined 3 columns I cannot add a row in the GUI using Rt Click The Return…
Mark Wardell
  • 493
  • 7
  • 25
0
votes
2 answers

Postgresql not using index on WHERE IN but works with WHERE =

I'm querying a table with a few millions rows. When I use a sub select with = select * from "parcels" where "parcel_id" = (select "parcel_id" from "parcels_properties" where "property_id" =…
Yunwei.W
  • 1,589
  • 1
  • 14
  • 31
0
votes
1 answer

Postgres version mismatch

I had Postgres version 13 installed on my windows machine. I've upgraded to version 14 and left the old version there. I've updated my path variable to the new version. In PGAdmin 4 I created a new database called education_system and can use it…
bluethundr
  • 1,005
  • 17
  • 68
  • 141
0
votes
1 answer

Based on previous records, stop sum fields

I have a table like this: |id | date | point | +---+------------+-------+ | 6 | 2022/01/06 | 9 | | 5 | 2022/01/05 | 7 | | 4 | 2022/01/04 | 1 | | 3 | 2022/01/03 | 4 | | 2 | 2022/01/02 | 6 | | 1 | 2022/01/01 | 1 | My…
Saeed
  • 3,294
  • 5
  • 35
  • 52
1 2 3
…
14
15