In a Postgres DB, given the following simplified dataset of orders: ID STORE_ID UPDATED_AT 1 "store-1" 2021-01-01 2 "store-2" 2021-01-02 3 "store-3" 2021-01-03 4 "store-1" 2021-01-04 5 "store-2" 2021-01-05 6 "store-3" 2021-01-06 ... 1000 "store-1" 2021-02-05 How can I write…
Background I'm running Postgres 11 on CentOS 7. I recently learned the basics of recursive CTEs in Postgres thanks to S-Man's answer to my recent question. The problem While working on a closely related issue (counting parts sold within bundles…
My goal To calculate the sum of components sold as part of their parent assemblies. I'm sure this must be a common use case, but I haven't yet found documentation that leads to the result I'm looking for. Background I'm…
I am trying to set up multiservices architecture in my Node.js backend with docker. I have currently two services with two separate databases version: "3" services: server-api-getaway: build: context: "." dockerfile: "./server-api-gateway/Dockerfile" depends_on: - db - redis ports: - "7100:7100"…
django+gunicorn+nginx gives 404 while serving static files I am trying to deploy a Django project using nginx + gunicorn + postgresql. All the configuration is done, my admin panel project static file will serve , but other static files; it…
I am using psql to connect to a PostgreSQL database on Debian 10. I am trying to connect as the postgres user, to the default postgres database. By default, this is using the 'peer' authentication method, which does not require…
This is the table schema: CREATE TABLE public.page_by_category ( id integer NOT NULL DEFAULT nextval('page_by_category_id_seq'::regclass), page_id bigint NOT NULL, category_id bigint NOT NULL, weight integer NOT NULL, CONSTRAINT id_pk PRIMARY KEY (id), CONSTRAINT category_id_fkey FOREIGN KEY (category_id) CONSTRAINT page_id_fkey FOREIGN…
I made some updates to a project: add 1 admin model, add 1 template I'm using wagtail. I pulled the updates to my server, ran migrations, got success. I restart nginx and gunicorn, I even rebooted the server. When I…
I just create a user and new database on my local machine. sudo su - postgres -c "createuser gauthier" sudo su - postgres -c "createdb local-ag-db" Then: $ sudo -u postgres psql sudo -u postgres psql psql (11.9 (Debian 11.9-0+deb10u1))…
I have Go as my API and PostgreSQL as my database. I can run my backend using the docker container when executed in development environment. However, when I run my dockerfile and docker-compose. The database is not connecting to postgres.…