ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
I went to view a postgres schema on my local (MacOS 11) database, and was not able to view my schemas. Connection Refused in PGSQL Editor! (DBeaver specifically) So I opened my Postgres desktop application, and got the warning message, "Stale postmaster.pid file" How can I fix this? (This example is Postgres 12, but i'm sure this fix will work on later versi
I need a little help with migration. I'm trying to seed DB using migration. But I get an error "QueryFailedError: relation "account" does not exist". I think it's just typical newbie mistake. So please check my code: account.entity.ts import { BeforeInsert, Column, Entity, OneToMany } from 'typeorm'; import { AbstractEntity } from '../../common/abstract.enti
I'm trying load a tar file using pgAdmin, but it's failing and all I get is exit code 3221225781. This code seems to indicate a missing dll What is exit code 3221225781 on windows? but I'm not sure why this would be or what dll to look for.
My operating system is Linux. I am going to connect Superset to PostgreSQL. PostgreSQL port is open and its value is 5432. PostgreSQL is also running and not closed. Unfortunately, after a day of research on the Internet, I could not solve the problem and it gives the following error: The port is closed. Database port: command: lsof -i TCP:5432 python3 13127
I want to create an enum column in a Supabase table. Supabase uses Postgres under the hood, so I understand that technically it is possible if I do it manually using SQL. But is there any way I can do it via the frontend in an easier manner?
I'm trying to view the raw data from the AACT Database in pgAdmin 4. I'm on a Mac computer. When I just try to view the first 100 rows from the 'complete_oncology' table, I get the below error: ERROR: permission denied for schema public LINE 1: SELECT * FROM public.complete_oncology ^ SQL state: 42501 Character: 15 Do I have insufficient permissions? If yes,
I want to create database called "President" by rightclicking on PostgreSQL and selecting Create Database . However, I get the error in the screenprint below. I can create databases with other names like SomeOtherDatabase and SomeOtherDatabase2 (see screenprints). Any ideas how I can find and delete the database "President" that seems to exist already? UPDAT
postgresql
nestjs
supabase
dbeaver