ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Recovery needs to recreate the working service and its required data after a machine or process is lost. Which artifacts and state need protection, and how should the restore be checked?
I often just want to test out a function, or see what a variable might look like. This could be done by creating a temporary table, but I suspect that there is an easier way. Basically, WITH cte1 AS ( SELECT VALUES(1,2,3) AS temp_var1 , VALUES(4,5,6) AS temp_var2 ) SELECT temp_var1 , temp_var2 , (temp_var1 + temp_var2) AS temp_var3 FROM cte1 This would retur
I am getting an error after moving the project to production. The error is as follows while running with production server pg_connect(): Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above. Here is my PostgreSQL version: Development Version : PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150
I understand that explain in postgresql just estimates the cost of a query and explain analyze does the same and also executes a query and gives the actual results. But I can't figure out in which cases I should use explain and explain analyze.
I am having some issues performing a nested find query with TypeORM. Here's the basic code: const { completionId } = req?.params; const user = req.user; const retrievedCompletion = await getRepository( CompletionGoogleSearch ).findOne({ relations: ['run', 'run.user'], where: { id: completionId, // run: { user: { id: user.id } }, // This is the code that brea
I've tried to connect Prisma with postgreSQL several times. prisma show this error message : "Error: undefined: invalid port number in "postgresql://postgres:password@localhost:5432/linker")". -error -prisma/.env DATABASE_URL=postgresql://postgres:password@localhost:5432/linker -schema.prisma datasource db { provider = "postgresql" url = env("DATABASE_URL")
I am trying to configure Spring Batch to use PostGres DB. I have included the following dependencies in my build.gradle.kts file: implementation("org.springframework.boot:spring-boot-starter-data-jpa") implementation("org.postgresql:postgresql") My application.yml for my SpringBatch module has the following included: spring: datasource: url: jdbc:postgresql:
Ok, I'm having trouble with getting the relations with typeorm. When I run the service it returns all the data from the relation, and I want only specific fields, like id and name. Here's my code: async findById(id: string): Promise<UsersUseOfferHistoric> { return await this.repository.findOne({ where: { id }, relations: ['userId', 'offerId'], }); } He
Not really sure what caused this but most likely exiting the terminal while my rails server which was connected to PostgreSQL database was closed (not a good practice I know but lesson learned!) I've already tried the following: Rebooting my machine (using MBA M1 2020) Restarting PostgreSQL using homebrew brew services restart postgresql Re-installing Postgr
javascript
prisma
typescript