PostgreSQL

08 Nov 2024 13:47

I want postgre SQL notes

PostgreSQL

08 Nov 2024 12:52

Have you checked that pgagent daemon is working properly, I mean, daemon runs?, daemon have no errors?, then check property dialog that show you last run, last result..

PostgreSQL

08 Nov 2024 08:05

Hi, Can we discuss more?

PostgreSQL

08 Nov 2024 06:39

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

07 Nov 2024 17:37

postgres hacking session with Andrey and Kirk -- live right now https://www.youtube.com/watch?v=l-0IP-_meD0

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

08 Nov 2024 12:53

IMHO I would use plain crontab or pg_cron

PostgreSQL

08 Nov 2024 12:04

Hi i am new to postgresql..installed pgadmin & pgagent in Centos OS .after scheduling the jobs they are not starting in pgagent. No error messages also .can some one help me .

PostgreSQL

08 Nov 2024 08:00

Hi we are hiring for contractual job opportunity with no pf for PostgreSQL (High priority)
Remote
Contract-3 TO 6 months
Exp-6-8 Years
Timings-12 pm to 9 pm IST
Contact 7233911117
chitra.vgemperts@gmail.com

JD-
Expert-level proficiency in PostgreSQL, including stored procedures, window functions, CTEs and subqueries.
· In-depth understanding of PostgreSQL database architecture, partitioning, scaling, performance tuning and optimization.
· Intermediate level experience with any one of the following- Kafka, Kinesis, Event Hub
· Intermediate level experience of Python programming language
· Ability to work independently and meet tight deadlines.
· Excellent problem-solving and analytical skills.
· Strong communication and collaboration skills.
· Self-driven and motivated
We request you to please check your resource pool and share the available bench resources matching the mandatory skillset

PostgreSQL

07 Nov 2024 17:47

You'll have to use regular expressions then:

bluthg=# SELECT 'SOME SELECT /* some comment */'::text ~ '/\*'::text;
 ?column? 
----------
 t
(1 row)

bluthg=# SELECT 'some string containing "*"'::text ~ '/\*'::text;
 ?column? 
----------
 f
(1 row)

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