Questions tagged [docker]

The container software docker. https://www.docker.com

Filter by
Sorted by
Tagged with
0 votes
0 answers
27 views

How can I improve disk performance on PostgreSQL on disks with slow write performance?

For a little personal project I have a docker-swarm running and I am using glusterfs as data storage. With docker-swarm, a container can be stopped at any point in time by the service and be re-...
user avatar
  • 631
0 votes
0 answers
25 views

Firebird database - isql command not found

I have a problem with the firebird database. When I use docker run -it jacobalberty / firebird bash my isql command works but when i run docker exec -it firebird bash my isql command no longer works ...
user avatar
0 votes
0 answers
21 views

Postgres 11 docker container fails to start: Segmentation fault

I am running a Postgres 11 instance in a docker-container started with docker-compose together with Wiki.js on a raspi. A longer time ago, I pulled a new image which resulted in termination by signal ...
user avatar
  • 101
0 votes
1 answer
73 views

docker exec --user db2inst1, unable to find user db2inst1: no matching entries in passwd file

I'm playing around with docker and db2 but I'm getting into trouble when I try to execute commands as user db2inst1 into a running container. I start the container as (it is 1 line but I split it up ...
user avatar
  • 21k
0 votes
1 answer
29 views

How to set the 'source address' ProxySQL uses to connect to MariaDB?

I'm deploying ProxySQL on Docker. When I try connecting to my database via ProxySQL, MariaDB rejected my login attempt as follows: Access denied for user 'usarr'@'172.18.0.1' (172.18.0.1 is the ...
user avatar
  • 187
0 votes
1 answer
30 views

pgpass entries for multiple SSH tunnels with randomly assigned local ports using the same credentials but different passwords

Let's say I have 4 SSH tunnels to different remote servers, each having different PostgreSQL databases up and running. Each tunnel is mapped to a specific port on my local machine (localhost) as ...
user avatar
  • 216
4 votes
2 answers
963 views

Is there a way to use standard CLR functions on Azure SQL Edge for Ubuntu Docker on an M1 Mac?

I have a MacBook with an M1 chip, so (about) the only option for me to run SQL Server is to run it as a Docker container. This works fine for standard SQL, but our application uses some CLR features ...
user avatar
  • 2,117
2 votes
1 answer
220 views

How to migrate a mysql into a mariaDB docker container?

I am running a local instance of $ mysql --version mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) and would like to move the whole database into mariaDB docker container. If I see ...
user avatar
  • 121
0 votes
1 answer
161 views

I get the error "(psycopg2.OperationalError) FATAL: role "wsb" does not exist", but the user does exits

I am trying connect to my postgress database using SQLAlchemy. I was working fine yesterday (01/27/22). Now I get the following error: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) ...
user avatar
0 votes
0 answers
14 views

How to perform remote migrations without exposing a port?

I have some SQL migration scripts and my migration tool allows me to specify a remote target which works fine. My concern is having to expose a port to the production database server. Normally I ...
user avatar
0 votes
1 answer
24 views

does using PV and pipe affect perfomance importing database?

I'm importing a database that's almost 2.5 GB inside a docker postgres container. I wanted to know the stimated time and the progress so to check the progress I use PV command like this (I'm not sure ...
user avatar
0 votes
0 answers
18 views

Which option should I use to avoid error #2006 on MySQL (Docker Compose)

I am getting error #2006 - MySQL server has gone away while trying to restore a 11.9 mb database using PhpMyAdmin. It worked with a 4.70 mb database, but not with this one I thought that if I put --...
user avatar
0 votes
1 answer
138 views

Barman Postgres 14 recovery

I updated my postgres from 10 to 14 few weeks ago. The recovery used to work before (restoring the backup on a different postgres server): Put the barman backup into the folder ssh -i ./do.pem root@...
user avatar
0 votes
1 answer
51 views

General Questions about using MySQL with Docker, logging options

I have a number of questions about logging / backup strategies when using MySQL with Docker specifically and also just general questions. The particular scenario is MySQL DB's for a small medical ...
user avatar
  • 103
0 votes
0 answers
20 views

How to do database replication correctly in this case?

I have a large PostgreSQL database on my local computer in docker volume, then I need to copy the database to a remote computer (VPS). This database will be static (read only), the data will be ...
user avatar
1 vote
0 answers
74 views

Moving the PostgreSQL data corresponding to a single table on another disk when pgdata is a docker volume

I have a PostgreSQL database with one table having especially large amount of geographic data. Because of that, I'm facing this kind of error today: FATAL: could not write lock file "postmaster....
user avatar
  • 216
0 votes
1 answer
31 views

CockroachDB upgrade not finalized

I am running a three-node CockroachDB docker cluster (Debian OS) and I recently upgraded the cluster from version v21.1 to version v21.2 following the procedure outlined in the documentation using the ...
user avatar
1 vote
1 answer
519 views

Postgresql RAM optimization for containers and kubernetes

I wondered how to optimize the RAM usage of my PostgreSQL database deployed in Kubernetes. Particularly I'm interested in configuring the shared_buffers and effective_cache_size values. Typically the ...
user avatar
  • 113
-2 votes
2 answers
1k views

How can I install SQLServer in MAC M1?

I want to run SQL on my MAC M1, I used guidelines according to this website: https://phoenixnap.com/kb/install-sql-server-macos and I used this instruction: docker pull mcr.microsoft.com/mssql/server:...
user avatar
0 votes
0 answers
63 views

MS SQL 2019 operator in k8s is ready for production?

ITNOA I am searching about MS SQL Server 2019 K8s operator very much, but I don't find any comprehensive documentations or help pages I just found Availability Groups on Kubernetes in SQL Server 2019 ...
user avatar
0 votes
2 answers
40 views

What do I need to put in pfile to change NLS_CHARACTERSET?

Im not an expert in databases. I am using docker Oracle 12c database for local dev environment. Its an official image from Oracle but they dont give any option to change the NLS_CHARARACTERSET during ...
user avatar
  • 127
-2 votes
1 answer
313 views

Why SQL Server docker image uses high CPU all the time, and how to fix it?

Using this docker-compose.yml I have created a container: version: "3.9" services: database: image: mcr.microsoft.com/mssql/server user: root restart: always ...
user avatar
2 votes
1 answer
311 views

How can I change the RSA key length from 1024 to 2048?

SQL Server Environment: OS version: Windows 2012 R2 Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64) Instance type: Named instance When I am attempting to connect from a Docker ...
user avatar
  • 12.2k
0 votes
1 answer
78 views

Cant communicate from Docker container to Oracle server through IP SCAN

I am actually running a .Net Core app in a docker container that communicates with a Oracle Database. All runs well when I use the direct database server IP address in the connection string. Next step ...
user avatar
0 votes
1 answer
87 views

Why scaling up an app by 50x exceed the PostgreSQL max_connection value of 100? [closed]

I went into this issue on purpose by scaling up a dockerized Python application 50x using this command docker-compose up --scale app=50 app: This app connects to a single PostgreSQL database (also as ...
user avatar
  • 216
1 vote
0 answers
15 views

MySQL is not showing the history queries after the ETL is complete [closed]

I am using docker container for MySQL and Spark. Both containers are on AWS Ec2 instance. Pyspark ETL connects to MySQL with JDBC and start extracting the data. When the ETL is running i can see the ...
user avatar
1 vote
2 answers
1k views

Allowing remote connections to mariaDB docker conatiner?

so I'm really new to docker and I may be using it incorrectly here but it makes spinning up a mysql database REALLY easy so thats why I wanted to give it a shot rather than installing an instance on ...
user avatar
1 vote
2 answers
189 views

PostgreSQL connection URI works, but with parameters fails

I found a weird behaviour connection from command line. My server is a docker container with postgres user and example as password. if I connect with URI psql postgres://postgres:example@localhost:...
user avatar
  • 111
0 votes
1 answer
316 views

Docker postgres work_mem not using ram

I have set shared_buffers to 256MB. Using pg_buffercache extension I see that all of the buffers are in use: SELECT pg_size_pretty(COUNT(*)*8192) as used FROM pg_buffercache; used ---------------- ...
user avatar
  • 131
0 votes
1 answer
55 views

Why index not cached?

After running the same query twice I expected data to be cached, but I see data is still read from disk: -> Index Scan using product_pkey on product (cost=0.42..3.51 rows=1 width=4) (actual time=...
user avatar
  • 131
1 vote
0 answers
55 views

Postgres & docker os disk cache

I'm using docker-compose to run my database container that has fairly small memory limit (using mem_limit setting). Will the docker host disk cache be used (no mem limit) by the postgres container, or ...
user avatar
  • 131
0 votes
0 answers
56 views

Oracle database docker image is not working for 12.1.0.2, how to fix that?

I have registered with the docker image of oracle database and got below link to pull the image. docker pull store/oracle/database-enterprise:12.2.0.1 No other tags available to see on the page. But ...
user avatar
0 votes
0 answers
344 views

Upgrade Postgres database from 10 to 13 running in Docker

I have a Postgres database running in a docker container (https://hub.docker.com/_/postgres). The docker image is postgres:10.0 and I would like to upgrade to postgres:13.3. If I just change the image ...
user avatar
  • 111
13 votes
3 answers
307 views

How to limit memory consumption of mysql server to prevent OOM kills?

My MySQL instance is getting killed by the Linux oom_killer due to huge consumption of memory by mysql when inserting into longblob columns. This occurs when restoring a mysqldump which contains a ...
user avatar
  • 231
0 votes
0 answers
81 views

Docker container mysql 8 fail to start with './slave57_binlog.~rec~' not found (OS errno 13 - Permission denied)

I have a mysql (percona) master and slave setup on docker containers running. master57 - master container - 5.7.34 Percona Server slave57 - slave container - 5.7.34 Percona Server root@docker-host:~# ...
user avatar
1 vote
1 answer
258 views

SQL Server in a Linux Docker Container: Maximum size recommendation

Total docker noob here. Please forgive me for the lengthy post. We are currently use SQL Server 2019 on Windows for our database. In an effort to "dockerize" the applications and database in ...
user avatar
  • 11
3 votes
1 answer
456 views

Differences between MariaDB docker tags

I need to install MariaDB 10.5 latest GA with docker. What is the main difference between the following tags? 10.5.11-focal 10.5-focal 10-focal focal 10.5.11 10.5 10 latest
user avatar
  • 133
0 votes
1 answer
182 views

When a thread/process crashes on acquired DB locks, how does DB detects that and releases the lock?

Take MySQL as an example, say a thread run SELECT ... FOR UPDATE crashes before committing the update, how does MySQL detect the crash and release the lock? I assume most RMDBS will have some keep-...
user avatar
0 votes
1 answer
644 views

Unable to connect to an Oracle 12c Docker container

I'm working on a project with Oracle, and using a Oracle XE 11 container for testing. But recent developments have ended up with me running up against a brick wall: I need larger table names. ...
user avatar
1 vote
0 answers
544 views

pg_basebackup from docker postgres container and restoring to physical postgres [closed]

I am using pg_basebackup to backup data that is running in docker based postgres (alpine) to a physical postgresql cluster. Both postgres versions are 12. docker exec -t postgresql pg_basebackup -U ...
user avatar
  • 111
2 votes
0 answers
20 views

How do I know which timescale db docker image was used?

I see timescaledb.last_tuned_version = '0.8.0' in postgresql.conf. How can I know which docker timescaledb image (exact version) was used?
user avatar
0 votes
0 answers
203 views

Understanding how to set up the port value in pgadmin4 docker from the GUI and in the servers.json config file when using an SSH tunnel

This is extraordinary tricky but I just discovered that, when you first open an SSH tunnel manually in bash (and somehow, I hope that I'm wrong somewhere...); user@localhost:~$ ssh -N -f -L 2345:...
user avatar
  • 216
3 votes
2 answers
453 views

On docker volume restore: could not access file "$libdir/timescaledb-1.6.0": No such file or directory

I am trying to restore TimescaleDB data from one ubuntu machine to another ubuntu machine. On the both machines we have deployed TimescaleDB through docker and using the same tag. Docker image used: ...
user avatar
0 votes
1 answer
498 views

Reverse-proxy for SQL Server

Context: For our testing environment, we were migrating from on-premise SQL Server 2017 to Docker Linux SQL 2017 container. There is a large number of TestScripts in windows that try to connect to ...
user avatar
1 vote
1 answer
160 views

Linux Volumes for SQL Server + Docker on Linux [closed]

I am testing out a POC project for SQL on Docker containers on Linux and wanted some background info on how to request the storage on the Linux VM. The plan is to spin up 10 containers with SQL 2019 ...
user avatar
0 votes
2 answers
488 views

Unable to connect to postgres inside a docker container

I've started a new postgres:12 docker instance as: $ docker run -it -d --name newdb \ -p 5444:5432 \ -e POSTGRES_PASSWORD=postgres \ -e POSTGRES_USER=postgres \ --volumes-from dbstore \...
user avatar
  • 216
0 votes
0 answers
207 views

PostgreSQL PAM authentication with Docker

I want to authenticate Linux host's users with the PostgreSQL database running in the docker container (If PG is installed natively, it works fine). I have a compose file like: version: "3" ...
user avatar
0 votes
1 answer
47 views

How to set up mysql docker container with existing ib* files?

Related to a previous issue, I'm trying to recover some data from existing ib* files from a crashed server. The database version is 5.1.69, so quite old. One of the responses was to install MySQL 5.5, ...
user avatar
0 votes
1 answer
210 views

PostgreSQL high disk usage

I have a PostgreSQL database on a docker container with 50MB of data: SELECT pg_size_pretty(pg_database_size('db_1')); pg_size_pretty ------------------ 50 MB but the volume size is 8.5GB : sudo ...
user avatar
1 vote
0 answers
73 views

User names in postgres docker image logs

I'm looking to get thorough logs of user activity attributable back to users from the official docker image of Postgres. I'm running my docker image like so: docker run --name pg -e POSTGRES_PASSWORD=...
user avatar