Stack Overflow
Stack Overflow

Questions tagged [postgresql-13]

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

368 questions
0
votes
1 answer

Most efficient method to import bulk JSON data from different sources in postgresql?

I need to import data from thousands of URLs, here is an example of the…
Lautaro Aguilera
  • 53
  • 5
0
votes
1 answer

How to set the wal_level on AWS RDS Postgresql 13?

After upgrading RDS to Postgres 13.1 our logical replication failed with the connections exceeds max_wal_senders (currently 0) error. When I checked the parameter group I could not find the option to set the wal_level anymore (should be logical).…
SiOx
  • 478
  • 1
  • 6
  • 13
0
votes
1 answer

Bulk update of one column with other column in same table

I'm using postgresql 13.1. I'm trying to update one column of a table with another column of same table. It's not fast enough. It's taking forever to update as I've millions of records in the table and I've index on the column which I'm trying to…
NoMan Ilyas
  • 33
  • 6
0
votes
2 answers

How to customize postgres for sharing read-only tables in multiple data-dirs between servers

Problem statement: I have to develop a solution in which a single source populates a table. Once the table is populated, it is considered as read-only and then we run many read-only queries on it. Such read-only tables are generated by multiple…
Maoz
  • 1
  • 1
0
votes
0 answers

Import .db file to postgresql using terminal

I am on ubuntu, i have Postgresql 13 installed on it. I have a file named (order.db) which is actually a database with a few tables in it. I want to import whole of (order.db) into postgres with same database name and of course the data. Is there…
Hard work
  • 45
  • 3
0
votes
0 answers

Postgres 2 node cluster setup

I want to setup 2 node cluster for postgres. How to configure primary and backup for a 2 node cluster I need to know the best way to do it also its necessary configurations.
R_S_C
  • 75
  • 1
  • 10
0
votes
1 answer

How to perform a select statement from inside a c-extension

I managed to get a c-extension to compile and run with the help of the official documentation https://www.postgresql.org/docs/13/xfunc-c.html. Now I don't see in the examples provided a way to perform a select inside of a c-extension. Generally I…
user2329125
0
votes
1 answer

PostgreSQL: `VIEW` returns no rows with `SPLIT_PART()` columns

Problem Description: Hi everyone, I'm having some troubles querying on a VIEW whose columns are, in part, the result of SPLIT_PART() function on og table's column; I created the VIEW as it follows: CREATE VIEW ClientsAddressList(Client_ID,…
noodles
  • 13
  • 4
0
votes
1 answer

Cannot connect to Postgresql using the terminal in Ubuntu 20

I am using postgresql 13. When I type psql I get this: psql: error: could not connect to server: Ficheiro ou pasta inexistente Is the server running locally and accepting connections on Unix domain socket…
Diego Alves
  • 2,462
  • 3
  • 32
  • 65
0
votes
1 answer

Issue while updating postgres pod version 12 to 13

I have a kubernetes cluster running an app. Part of the cluster is a postgresql pod, currently running version 12.4. Unfortunately, I discovered that I need to upgrade the postgresql version 13. Here i have delete my pod having version 12 then…
Kube_Charm
  • 1
0
votes
2 answers

PostgreSQL slow order

I have table (over 100 millions records) on PostgreSQL 13.1 CREATE TABLE report ( id serial primary key, license_plate_id integer, datetime timestamp ); Indexes (for test I create both of them): create index report_lp_datetime_index…
Alexey
  • 53
  • 5
0
votes
0 answers

Neo-4j ETL Tool won't connect to local postgres Server. org.postgresql.util.PSQLException: The authentication type 10 is not supported

I am using Neo4j version 1.4.1 and PostgresSQL 13 with PgAdmin 4.30. I recently installed PostgreSQL 13, before that I had PostgreSQL 12 and PgAdmin 4.24 when this ETL import thing worked. But now, after removing PostgreSQL 12, I was trying to…
Priyankesh Raj
  • 1
  • 3
0
votes
2 answers

How do I insert an empty row, but have the serial update correctly?

I would like to insert a blank record into a table and have its serial primary key value update. I would then like to get the new value and insert it into a temporary table. This will take place within a function using language plpgsql. So far I…
volume one
  • 6,800
  • 13
  • 67
  • 146
0
votes
2 answers

Why is this function not able to return an integer due to no destination for result?

I have a simple function that needs to return an integer from a select statement. This is it: CREATE OR REPLACE FUNCTION validate(_identityid integer, _postid integer) RETURNS integer LANGUAGE plpgsql AS $$ BEGIN SELECT postid FROM post…
volume one
  • 6,800
  • 13
  • 67
  • 146
0
votes
0 answers

Why am I getting a "[42883] ERROR: operator does not exist: unknown + text" response?

I have a very simple function that accepts _posttypeid and _url as parameters: CREATE FUNCTION rewrite(_postid integer DEFAULT NULL::integer, _url character varying DEFAULT NULL::character varying) RETURNS…
volume one
  • 6,800
  • 13
  • 67
  • 146
1 2 3
…
24 25