Hello SO & Django community, My problem is related to Django 4, as the feature to use passfile to connect to Postgres has appeared in this version. Though I
For an academic experiment I need to restrict the total amount of memory that is available for a pgSQL server to compute a given set of queries. I know that I c
I missed a bit with chmod and permissions. And now got a lot of problems with access to folders. If I start server I see in browser: could not connect to ser
I'm writing a function in PL/pgSQL, and I'm looking for the simplest way to check if a row exists. Right now I'm SELECTing an integer into a boolean, which does
I have created an serial_num (auto incremented/ serial type ) column in our postgress db. my contact struct type is as of below and i am using upsert operation
This is the sql query. I need to convert into postgres query SELECT a.tablespace_name, a.maxbytes, a.mbytes, (a.maxbytes - a.mbytes),
Here's my function declaration and part of the body: CREATE OR REPLACE FUNCTION access_update() RETURNS void AS $$ DECLARE team_ids bigint[]; BEGIN SELECT
I tried to establish a connection in pgAdmin to the PostgresSQL server. I always get the message: could not receive data from server: Software caused connectio
I have a table my_friends_cards: id | name | rare_cards_composite[] | ---+---------+------------------------ 1 | 'timmy' | { {1923, 'baberuth'}, {1999, 'j
I am using SQLite3 for development and PostgreSQL for deployment. However, I am facing the following problem: My simple search using SQLite3: def self.search(
I need to specify sslmode=allow when using psql to connect to my PostgreSQL DB, like: psql sslmode=allow -h localhost -p 5432 otherwise I get server does not su
I am having an issue running migrations with TypeORM (with the intent of establishing my database for use in local development). In running a migration on the i
I wonder if there is an alternative to the psql command to test the connection to a postgresql database using bash. I'm setting up a Core OS cluster and have a
I wanted to create a replicate of my production database for staging and created the staging DB instance from a production snapshot. However, this new instance
Trying to connect to an Azure PostgreSQL server from my local Strapi project (eventually deployed in a docker container). I have the connection configured accor
I have installed PostgreSQL. However everytime I try to connect through PGAdmin or through psql it gives me the below error. could not connect to server: Conne
Background Users can type in a name and the system should match the text, even if the either the user input or the database field contains accented (UTF-8) cha
Hello i get this error after i run docker-compose build up But i get this error postgres_1 | Error: Database is uninitialized and superuser password is not spec
I've got a problem with Criteria from Doctrine2. Iusing Criteria to check a SMALLINT type in PostreSQL like this : $criteria = Criteria::create()->where(Crit
Using Postgres, I'm trying to use AUTO_INCREMENT to number my primary key automatically in SQL. However, it gives me an error. CREATE TABLE Staff ( ID