ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Migration leadership and lock ownership In a Mattermost high-availability cluster running v8.x, the first node to start acquires a PostgreSQL advisory lock and executes pending database migrations while other nodes block on the same lock. The documentation states that only the leader runs migrations, but it does not specify what happens to the advisory lock
The goal is to determine whether PostgreSQL 12 allows a partial index on a jsonb column that is defined using the ->> operator without an explicit cast. In PostgreSQL 11 a cast to text is required, while 12 accepts the operator directly, but the planner may still choose a sequential scan if the predicate includes a cast, resulting in suboptimal perform
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.
PostgreSQL service on Rocky Linux: configuring StopWhenUnneeded to control idle connections The goal is to ensure that idle PostgreSQL connections are released when the systemd service is stopped or restarted, thereby reducing the risk of connection pool exhaustion under variable workloads. Currently the default max_connections is 100, idle_in_transaction_se
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?
An Elixir application using Ecto with PostgreSQL needs to store all timestamps as UTC via :utc_datetime / timestamptz while accepting and presenting values in a per-user regional time zone. tzdata is available for Calendar.DateTime.shift_zone/3. Ecto does not perform automatic regional conversion. The documented pattern is UTC storage in the database with co
Database Backup Retention Configuration Constraint DigitalOcean App Platform's managed PostgreSQL databases expose backup retention periods as a configurable parameter during initial provisioning, with documented support for values between 1 and 30 days. However, the constraint that this setting becomes immutable after database creation introduces operationa
mattermost
dbeaver
rockylinux
prisma
ecto
digitalocean