ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Compare suitability, operational responsibilities and limits before choosing this technology for a project. Which trade-offs should guide the decision?
I am trying to run my Django app (Nginx, Gunicorn) in docker. But for request http://167.99.137.32/admin/ I have error: (full log https://pastebin.com/0f8CqCQM ) onnection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (::1), p
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 have a table called "LogBookSystemUsers" and I want to setup many to many functionality in EF Core 5. I almost have it working but the problem is my ID columns are named SystemUserId and LogBookId but when EF does the join it tries to use SystemUserID and LogBookID . This is my current configuration code: modelBuilder.Entity<SystemUser>() .HasMany(x
I'm using DBeaver to connect the postgres db and want to access the logs via DBeaver. I run the command below to find log destination and got stderr as the location. show log_destination ; How can I reach that file on DB app? FYI, I want all logs, not the logs that are from DBeaver.
can I get a list of enums values of a model on the client-side like for select option? Sample enum enum user_type { superadmin admin user } I want this as a select-option on the client-side. How can I get them as JSON data?
I have recently tried my hands on Postgres. Installed it on local (PostgreSQL 13.0). Created a maven project and used Spring Data JPA, works just fine. Whereas when I tried using Gradle project, I am not able to connect to the DB and keep getting the following error. org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that y
When migrating data from an external PostgreSQL instance to a Supabase project using the postgres_fdw extension, the transfer of table rows does not automatically synchronize the state of sequence generators. In a zero-downtime migration strategy, data is pulled into the target Supabase instance while the source continues to accept writes. If the target sequ
I have a table with a "currency" column. I'd like to prevent further insertion of certain currencies, without removing the existing ones. Initially I was thinking of a validation trigger. Then I discovered the NOT VALID option of ALTER TABLE ADD CONSTRAINT , which prevents the validation of existing data. The documentation seems to imply that the NOT VALID o
docker
nginx
django
dbeaver
prisma
gradle
java
supabase