Questions tagged [docker]
The container software docker. https://www.docker.com
166
questions
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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) ...
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 ...
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 ...
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 --...
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@...
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 ...
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 ...
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....
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 ...
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 ...
-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:...
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 ...
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 ...
-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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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:...
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
----------------
...
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=...
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 ...
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 ...
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 ...
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 ...
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:~# ...
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 ...
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
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-...
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. ...
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 ...
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?
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:...
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: ...
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 ...
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 ...
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 \...
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"
...
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, ...
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 ...
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=...