I have tried many possible solutions to it, Not able to make any of them work. Here it goes: I built a nodejs container and a postgres docker container. Used docker compose to configure them both and used Dockerfile to…
I have written some applications in Delphi for a production company, the purpose of this application is label printing and production data acquisition.All of these applications are Client-Server (Using ZeosLib connecting directly to PostgreSQL through 5432 port). In recent days,…
Background: I am using PostgreSQL 11 on CentOS. I have a database having UTF-8 encoding, in specific tables I have some Latin characters as follows [ÄéÒçòý] Objective: I want to replace those with standard English characters for that I am…
I have an app using knex for migration. Earlier someone made an unique index on one column using knex.raw like this: const createProgrammeTable = knex => knex.raw(` CREATE TABLE programme ( id serial PRIMARY KEY, date date NOT NULL, published…
I need to upgrade a postgresql database inside a running container. For that I need to stop the old server so I can start the new. The problem is that I didn't find how to stop the running postgres process…
I have a kubernetes cluster running an app. Part of the cluster is a postgresql pod, currently running version 10.4. Unfortunately, I discovered that I need to upgrade the postgresql version. The postgres yaml is as follow: apiVersion: apps/v1 kind:…
I'm currently developing a Python application and I would like to know if there are any ways to pack MongoDB and MySQL (or Postgresql) into the application. By packing I mean taking those application binaries and distribute them with the…
I am developing the Heroku toy app and want to use the PostgreSQL database to store configurations. I either see tutorials on how to use Java + PostgreSQL or Java on Docker. I cannot find a way on how I…
I have a docker-composer.yml that is setting up two services: server and db. The Node.js server, which is the server service, uses pg to connect to the PostgreSQL database; and the db service is a PostgreSQL image. On the server…
I am running postgres in Kubernetes cluster and seeing this warning. What kind of problem/warning it is? How can I fix this? Here is full log on container startup: .. PostgreSQL Database directory appears to contain a database; Skipping initialization…