PostgreSQL

07 Nov 2024 14:02

I want to find all the procedures where I used the multiplication function... I can't simply use 'not like '%*%' because I already used /* */ for comments line... Please help me to write query..

PostgreSQL

07 Nov 2024 13:00

Don't have 32, all the other databases are working fine, except just one

PostgreSQL

07 Nov 2024 12:59

And the first error looks like a catalog corruption and this is why I recommend to use a catalog checker tool

PostgreSQL

07 Nov 2024 12:57

The second error are related to mixing 32 and 64 bits binaries

PostgreSQL

07 Nov 2024 12:56

Yeah, they are compatible

PostgreSQL

07 Nov 2024 11:39

Why don't you check pg_catcheck that is going to check your catalog?

PostgreSQL

07 Nov 2024 10:10

You can set SKIP fkeys in your config file, so you will turn off foreign keys constraints during the loading of the data

PostgreSQL

07 Nov 2024 09:14

JobOpportunity #ContractualRole #PostgreSQLDeveloper #RemoteJob #ImmediateHiring

Role: PostgreSQL Developer
Experience: 6 to 7+ Years (Relevant)
Location: Remote
Shift Timings: 12 pm to 9 pm IST
Contractual: No PF

Key Requirements:

Expert-Level Proficiency in PostgreSQL: Expertise in stored procedures, window functions, CTEs, and subqueries.
Database Architecture Knowledge: In-depth understanding of PostgreSQL database architecture, partitioning, scaling, performance tuning, and optimization.
Event Streaming: Intermediate experience with one of the following - Kafka, Kinesis, or Event Hub.
Python Skills: Intermediate-level experience in Python programming.
Problem Solving & Independence: Strong analytical skills and ability to meet tight deadlines.
Communication: Excellent collaboration and communication skills.
Motivated & Self-Driven.
For application or inquiries, contact:
📞 7233911117
📧 chitra.vgemperts@gmail.com

Tags: #PostgreSQL #DatabaseDeveloper #RemoteJobs #Kafka #Python #ImmediateHiring

PostgreSQL

07 Nov 2024 01:42

Even i can print

Raise notice '%', (a*b);

PostgreSQL

06 Nov 2024 20:47

Hi team anyone can share db size growth script daily basis

PostgreSQL

06 Nov 2024 17:40

I can't fix this problem

PostgreSQL

06 Nov 2024 15:22

You can do pg dump without data and comapre the files

PostgreSQL

06 Nov 2024 15:08

You just want to compare the schema?

PostgreSQL

06 Nov 2024 15:01

https://www.depesz.com/2024/02/07/waiting-for-postgresql-17-add-new-copy-option-save_error_to-rename-copy-option-from-save_error_to-to-on_error/

PostgreSQL

06 Nov 2024 14:59

This the copy command of redshift

PostgreSQL

07 Nov 2024 13:06

And what was the output of pg_catcheck execution?

PostgreSQL

07 Nov 2024 13:00

Yeah, it is a catolg corruption happened

PostgreSQL

07 Nov 2024 12:58

Don't have 32 bits binaries

PostgreSQL

07 Nov 2024 12:57

Linux Amd64 Ubuntu 22.04

PostgreSQL

07 Nov 2024 11:51

What operating system and arch are you using and timescale packages are compatible?

PostgreSQL

07 Nov 2024 11:18

do any can know the reason behind this, or how to fix these kind of issues??

Only I have a db that causing this issue and it is timescale, and have other extensions on it too.

I can connect on it normally, but I cannot view schema or tables ir anything, despte the fact that I still can query from tables... some queries failed and some passed.

I guess it is a corruption in the catalog maybe


These are the errors:

1) cach lookup failed for type 0

2) Unsupported Byval length:4100

PostgreSQL

07 Nov 2024 09:47

Running: ora2pg -c config/ora2pg.conf -t COPY --pg_dsn "dbi:Pg:dbname=test;host=lsp-oratl01;port=5432" --pg_user test
[2024-11-07 08:45:57] [========================>] 7/7 tables (100.0%) end of scanning.

SET client_encoding TO 'UTF8';
SET synchronous_commit TO off;

FATAL: ERROR: insert or update on table "countries" violates foreign key constraint "countr_reg_fk"
DETAIL: Key (region_id)=(2) is not present in table "regions".
Aborting export...
ERROR: an error occurs when importing data.
[oracle@lsp-oratl01 test_project]$
can someone help over this

PostgreSQL

07 Nov 2024 08:26

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

06 Nov 2024 21:15

Last lines from Postgres' log are useful, you could share them if you need help

PostgreSQL

06 Nov 2024 19:29

When I install postgres, the database cluster failed

PostgreSQL

06 Nov 2024 17:39

Everybody can help me with the "database cluster is failed" problem

PostgreSQL

06 Nov 2024 15:09

Pgadmin4, livecompare and several other postgres desktop client have this type of functionality

PostgreSQL

06 Nov 2024 15:07

How to compare the two databases in the same cluster? I have scenario where cluster having 2 databases as “test” and “test_old” so want to compare the tables,functions and indexes of both databases

PostgreSQL

06 Nov 2024 15:01

Standard copy command have added a parameter that allow you to get rows that rise an error during the execution of the copy

PostgreSQL

06 Nov 2024 14:51

Value Separator=\t
Include Header=Line true
Quote Character="
Escape Character=\p
Comment Marker=No value set
Null String=No value set
Trim Fields=true
Quote Mode=Quote All Values
Record Separator=\n
Include Trailing Delimiter=true

copy ${table_name}
from 's3://yyy-dwh/load2redshift/2load/${filename}'
REGION 'us-east-1' iam_role 'arn:aws:iam::45645645:role/redshift-s3'
FORMAT AS CSV  TRUNCATECOLUMNS IGNOREHEADER 1 DELIMITER '\t'  STATUPDATE OFF QUOTE '"' ;