ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
Configuration must be available to the application without exposing credentials in source control, logs or browser code. What belongs in the runtime and which access controls matter?
Docker hub contains several versions(tag) of Postgres db such as: 12.3, 12, latest 12.3-alpine, 12-alpine, alpine -... What is diff between postgres version 12.3 and 12.3-alpine?
I'm writing a script for PostgreSQL and since I want it to be executed atomically, I'm wrapping it inside a transaction. I expected the script to look something like this: BEGIN -- 1) Execute some valid actions; -- 2) Execute some action that causes an error. EXCEPTION WHEN OTHERS THEN ROLLBACK; END; -- A.k.a. COMMIT; However, in this case pgAdmin warns me a
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,
The story so far: I have installed Postgres on my Linux based desktop (HOST). I have created a test database, with test data, on HOST. I have added to the end of the pg_hba.conf file on HOST: host samerole all 0.0.0.0/0 md5 I have added to the end of the postgresql.conf file on HOST: listen_addresses = '*' I have installed PGAdmin4 on the Linux virtual machi
Parallel Execution and Expression Indexes PostgreSQL 14+ utilizes a cost-based planner to determine if a query should be executed in parallel. This decision depends on the max_parallel_workers_per_gather setting and the estimated cost of a serial plan versus a parallel plan. When queries rely on expression indexes rather than standard B-tree indexes on base
Managing database connectivity in a containerized environment requires balancing application-level pool sizes against the global limits of the managed database instance. In a Scalingo deployment, each container maintains its own independent connection pool, meaning the total number of concurrent sessions is the product of the pool size per container and the
Not sure which option is latest best practice? I read on on this tutorial that: https://www.postgresqltutorial.com/postgresql-identity-column/ PostgreSQL version 10 introduced a new constraint GENERATED AS IDENTITY that allows you to automatically assign a unique number to a column. The GENERATED AS IDENTITY constraint is the SQL standard-conforming variant
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) type "vector" does not exist LINE 4: embedding VECTOR(1536), ^ [SQL: CREATE TABLE langchain_pg_embedding ( collection_id UUID, embedding VECTOR(1536), document VARC
answered · 31 Dec 2022, 04:18 UTC
docker
linux
scalingo
python