Questions tagged [postgresql]
PostgreSQL is an open-source, relational database management system (RDBMS) available for all major platforms, including Linux, UNIX, Windows and OS X. Mention your version of Postgres when asking questions. Consider dba.stackexchange.com for questions concerning the administration or advanced features.
postgresql
177,593
questions
0
votes
0
answers
6
views
Title: Improving Performance for Netting and Settlement Cron Job in Spring JPA
I am working on a netting and settlement process in the banking and finance sector. Specifically, I need to run a cron job every 4 hours and 15 minutes to retrieve data from the transaction table for ...
0
votes
0
answers
5
views
Error with pg in Jest-ts testing : Jest has detected the following 1 open handle potentially keeping Jest from exiting: ● TCPWRAP
I have been facing the problem where my Jest test is not ending gracefully. (I prefer not to use --force-exit).
this is my jest code. FYI the tests passes. This is an integration testing.
import ...
1
vote
1
answer
20
views
How to pass dynamic value to a FOR loop?
I can do this:
for i in 1 .. (select pays from schema.table_name where pk_id='12' and pk2_id='123')
But it only works for this particular row. How to do it for all rows in the table?
Getting below ...
-2
votes
0
answers
19
views
What language would you reccommend for building a UI to access and manipulate large SQL databases? (Why? Benefits/Drawbacks?)) [closed]
I'm fairly new to coding and have been learning and building a personal archival database using SQL over the past few months. However, I would also like to develop a simple (at first) UI to use for ...
23
votes
6
answers
36k
views
PostGIS Error: type "geography" does not exist
I just upgraded my development machine to Windows 7 and am therefore reinstalling PostgreSQL and PostGIS. I used the Postgres Plus installer, as recommended on the Postgres website, and followed this ...
0
votes
1
answer
18
views
Client Encoding in psycopg3 missing, yet gives error
So I see in psycopg 2, there is a set_client_encoding('UTF8') function. In the psycopg 3 documentation it reads:
client_encoding is gone
Here I create the connection:
conn = psycopg.connect(...
0
votes
0
answers
20
views
Materialized view with Postgresql/Hibernate/Panache
I have created a panache entity in Quarkus which map existing Materialized view. When I execute a refresh view from a test it's not work.
@Entity(name = "MY_VIEW")
@Immutable
@...
1
vote
1
answer
46
views
How to modify a PHP class to accept PgSql\Result as an attribute
I need to find a way (if possible) to make a PHP class accept a PgSql\Result object as an attribute. PHP 8.1+ has migrated the pgsql result resource to the PgSQL\Result instance. In prior versions ...
0
votes
0
answers
11
views
Delete record and record associations based on multiple reference attributes
I have a join table that handles the logic of who owns what:
create_table :exercise_drills do |t|
t.references :exercise, foreign_key: { on_delete: :cascade }, null: false
t.references :drill, ...
2
votes
1
answer
7k
views
Insert data into postgreSQL using nodejs typescript
My code looks like this
signup.post('/signup', urlendcodedParser, async(req: Request, res: Response) => {
const username = req.body.username;
const password = req.body.password;
...
0
votes
1
answer
20
views
Difference between creating replication slot before subscription and creating subscription before replication slot
I'm using Postgres 15.2 with Patroni.
Patroni deletes unrecognized replication slots that are Active = false.
I know there is a way to add to Patroni's configuration a list of slots to ignore, but I ...
0
votes
1
answer
18
views
How to add permission to custom role in postgres to create index
I am currently creating a role for a particular database using the below sql script executed as master user (postgres).
CREATE USER customrole WITH PASSWORD 'mypassword';
-- removed CREATE ...
-1
votes
0
answers
23
views
Quickfix/n App - Kafka - Missing messages in Kafka [closed]
First of all if I need to separate the post in multiple questions please tell me how to do it by preserving the diagram and general information. thanks
I implemented a dropcopy fix reader and ...
231
votes
14
answers
273k
views
psql: FATAL: Peer authentication failed for user "dev"
when i create a new user, but it cannot login the database.
I do that like this:
postgres@Aspire:/home/XXX$ createuser dev
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to ...
3
votes
1
answer
1k
views
psql \copy from program fails with "The syntax of the command is incorrect"
I'm trying to import a CSV file into a
Postgres table using the psql \copy from program command.
\copy tablename from program 'cmd /c "type file.csv"' with DELIMITER ',' CSV HEADER;
However,...