Does anybody know how to run Django Tests using pytest-django against an existing (e.g. production) database? I know that in general, this is not what unit tests are supposed to do, but in my case...

This error is showing after running this command: sudo systemctl status [email protected] [email protected] - PostgreSQL Cluster 10-main Loaded: loaded (/lib/systemd/system/[email p...

creating a new rails-app (6.0.2) with postgres, on mac, could not get it to run. Getting this error on app start: dyld: Symbol not found: _PQresultMemorySize Referenced from: /Users/dev/.rvm/gem...

I have an existing MATERIALIZED VIEW in my postgresql database. I am trying to create typeorm entity for that. Can anyone tell me how to do that. I already went through typeorm View Entities docs b...

I am using postgresql 15 and I tried running these: grant all privileges on database my_database to my_database_user; grant all privileges on all tables in schema public to my_database_user; grant ...

I need to calculate period medians per seller ID (see simplyfied model below). The problem is I am unable to construct the ORM query. Model class MyModel: period = models.IntegerField(null=True,...

I've tried to specify the schema in my connection string dbCredentials: { connectionString: "postgresql://postgres:pwd@localhost:5432/drizzle?schema=manytomany"} ,but it does not work. So...

I am trying to install postgresql for the meta data of hive on Amazon EC2 Linux machine. And at that point, I am trying to connect postgresql outside docker image. Inside, I can connect the postgre...

Today I was prompted to upgrade my OS from Ubuntu 14.04 LTS to 16.04 LTS. Generally speaking, it went smoothly. However, I did receive error messages indicating that the upgrade of PostgreSQL from ...

I have two identical tables: A : id1, id2, qty, unit B: id1, id2, qty, unit The set of (id1,id2) is identifying each row and it can appear only once in each table. I have 140 rows in table A an...

I successfully installed Postgres Debezium CDC. Now, I'm able to catch all changes happening to the database. But the problem is "before" field always stays empty. So, if I insert a record (id = 1,...

Other than looking over release notes, is there any way to find what versions of postgresql a given version of Flyway would support? We are trying to upgrade some Postgresql 9.6 servers, so looking...

I am trying to use Prisma with a local instance of Supabase running on docker. I created a very basic model inside prisma/schema.prisma file: // This is your Prisma schema file, // learn more about...

I'm trying to connect my db from render to pgAdmin, but it always give me this timeout error I tried this guide and this other guide, but I got the same result

I was trying to embed some documents on postgresql with the help of pgvector extension and langchain. Unfortunately I'm having trouble with the following error: (psycopg2.errors.UndefinedObject) ty...

I switched my postgres version from 9.2.24 to 9.6 because I need jsonb compatibility along with other recent features. I am running a vm on centos 7. I decided to wipe all existing instances of po...

I'm performing a regular expression match on a column of type character varying(256) in PostgreSQL 8.3.3. The column currently has no indices. I'd like to improve the performance of this query if I...

I has been writing java web-app using the servlets+jsp, JDBC, and tomcat how a servlet container. When I connect to the database and trying to get some data, i given a current exception : enter ima...

I have a crosstab function that I've used successfully many times in the past, but now it's dumping all the data at the end instead of pivoting it into the output table. It can't seem to find Cross...

How do I only create a trigger if it does not exist? When I do create or replace, I get a syntax error so I am looking for a way to test for the existence of a trigger. I can always select * from...

Sorry for the basic question. I have a table with the following columns. Column | Type | Modifiers --------+---------+----------- id | integer | doc_id | bigint | text | text | I am t...

Is it possible to create a partial foreign key (similar to partial indexes) in general sql / postgresql? I have not found a way to force referential integrity in the following case: Table A is soft...

When loading pages in my Django + Postgresql setup I occasionally get this error but not all the time: psycopg2 in connect InterfaceError: only protocol 3 supported psycopg2/__init__.py ? in connec...

CREATE TEMP TABLE wirednull ( id bigint NOT NULL, value bigint, CONSTRAINT wirednull_pkey PRIMARY KEY (id) ); INSERT INTO wirednull (id,value) VALUES (1,null); INSERT INTO wirednull (id,value) V...

I want to create a Postgres user with the CREATE USER command and an already hashed digest for the password. After much searching, I thought it was only possible with MD5 until I found this link. I...