Questions tagged [docker]
The container software docker. https://www.docker.com
211
questions
0
votes
0
answers
14
views
Managed database or docker image with data-volume?
I've mostly used managed database (AWS RDS) for production. I was fiddling with docker and was wondering if it's a good idea to have containerised postgres database with data-volume?
I feel it may not ...
- 101
0
votes
1
answer
26
views
Configure Oracle 23c docker image in 19c compatibility mode
I need to build an Oracle 19c development environment using Docker; however there is no dev version of Oracle 19c with Partitioning available, whereas 23c does have a free version for developers with ...
0
votes
1
answer
63
views
MariaDB writes more the 30GB/day temp data
I´ve a Synology NAS where I´m running a Nextcloud in a Docker Container and a MariaDB in an other Docker Container. On a day the the NAS and also the Nextcloud doesn´t do anything, on my SSD are over ...
- 1
0
votes
0
answers
19
views
How to install Docker and Postgres on AL2023
What I want to do:
Install Docker and use a Postgres image to create a database to use with a Nest.js tut
What i have tried:
I have installed docker using:
yum install docker
Which yields when I do ...
0
votes
1
answer
41
views
Binary path in pgadmin
I am running pgadmin via Docker desktop. I am unable to restore a sql file in the database. I get the following message - "Please configure the PostgreSQL Binary Path in the Preferences dialog.&...
0
votes
0
answers
105
views
Connection timeout from host MongoDB compass to docker mongo replication
docker-compose file:
version: '3.8'
services:
mongodb-primary:
image: mongo:latest
hostname: mongodb-primary
container_name: mongodb-primary
ports:
- "27018:27017"
...
- 3,606
0
votes
0
answers
107
views
PostGIS in docker file FATAL no pg_hba.conf entry for host
I have a docker-compose.yml file with two image (Postgres extended PostGIS and pgadmin4):
version: "3.8"
services:
postgis:
image: postgis/postgis:15-3.3
container_name: ...
- 101
0
votes
0
answers
47
views
Connecting to SQL in docker in EC2 becoming slower
I am now running a PostgreSQL inside a Docker inside a EC2, and a Node.js instance is connecting to it.
I recently found that the connection is becoming slower. Before, restarting the instance only ...
- 103
0
votes
1
answer
64
views
How to restore a SQL Server bak file (Enabled FileStream ) to Docker version SQL Server?
I have SQL Server 2014 installed on Windows and enabled the FileStream feature. I backed up the database to a .bak file. Now I want to restore the file to my Docker container of SQL Server 2019. ...
XBruce
1
vote
0
answers
359
views
ORA-27046: file size is not a multiple of logical block size
I have oracle19c container, running by docker-compose:
version: '3.7'
services:
oracle:
image: container-registry.oracle.com/database/enterprise:19.3.0.0
container_name: oracle19c
ports:
...
MiH
0
votes
1
answer
144
views
Oracle19c container cannot startup after turning on archive log
I'm running oracle19c container.
This is the docker-compose file:
version: '3.7'
services:
oracle:
image: container-registry.oracle.com/database/enterprise:19.3.0.0
container_name: oracle19c
...
MiH
0
votes
0
answers
26
views
Advice about how to optimize DB setups when using Docker containers and Docker Compose
I have some general questions about how best to build and manage DB servers (Postgres and MySQL mostly) when using Docker builds with docker-compose.yml. In the past, I've sometimes bound the MySQL ...
- 103
0
votes
0
answers
30
views
Docker instances with MySQL replication and reboot
After a reboot of the system with two docker instances with MySQL replication, the slaves always breaks the replication with a Slave_IO ending not running.
Last time I had to redo all the process from ...
- 1
0
votes
1
answer
69
views
What's the purpose of mysql@localhost (password unknown) created by the MariaDB docker image?
Set MARIADB_MYSQL_LOCALHOST_USER to a non-empty value to create the mysql@locahost database user. This user is especially useful for a variety of health checks and backup scripts.
But the password is,...
- 145
2
votes
1
answer
80
views
How do I backup data of Cassandra nodes running in Docker?
I hope to receive some tips and assistance.
I have three virtual machines running Ubuntu 22.04, and each one has Cassandra deployed via docker-compose, forming a cluster.
My current task is to ...
- 21
1
vote
1
answer
50
views
[[FATAL]] [[DBT-06103]] The port (5,500) is already in use in Docker Container
I'm trying to use Oracle 19c DB Container for my test cases in Jenkins Job but DB Container is intermittently failing with this error
[FATAL] [DBT-06103] The port (5,500) is already in use.
ACTION: ...
1
vote
1
answer
34
views
Why does my SQL Server Docker instance report a tiny amount of "space available"?
I have a SQL Server 2022 instance running in a Docker container on Linux. My understanding is that Docker containers can simply expand their disk usage to fill the entire volume space available. The ...
- 685
0
votes
1
answer
251
views
Can't log into Oracle 19c database running inside a container from the host
I have a server running Oracle 19c inside a Docker container, and I would like the ability to log into the database from the host using sqlplus.
Inside the container, I am able to run this command ...
- 101
0
votes
2
answers
2k
views
How to fix MySQL using large amount of memory
I am running a MySQL database on my computer (in Docker) as part of a local development environment. Since this is far from a production instance, it is basically just using default settings and hasn'...
- 139
1
vote
1
answer
671
views
Can't get MariaDB docker to work without password
I want to add MariaDB to my docker compose file, like this:
version: '3'
services:
mariadb:
image: 'mariadb:10.3'
ports:
- "3306:3306"
volumes:
...
- 123
2
votes
1
answer
170
views
Is Apache Cassandra Quickstart broken?
I'm following the steps in the current (2023-03-13) Cassandra quickstart:
STEP 1: GET CASSANDRA USING DOCKER
docker pull cassandra:latest
STEP 2: START CASSANDRA
docker network create cassandra
...
0
votes
1
answer
1k
views
Using pgagent with docker?
I wanted to dive into the world of postgresql so I installed both postgresql and pgadmin using docker (with the portainer web ui) and I found out that for automatic jobs you gotta install pgagent too ...
- 11
1
vote
0
answers
101
views
pgadmin 6.20 running in docker on ubuntu, problem with binaries path
I've spent some hours googling and messing around with this but can't figure it out.
Running pgadmin 6.20 in docker on Ubuntu 22.04 VM. Postgres installed on same VM, but "bare metal" ...
- 11
0
votes
0
answers
80
views
Backup Maria DB data that is already down in docker but the data is persistent
MariaDB (running in Docker), whose storage is mounted on a drive of the host machine is currently down. I can navigate to the storage in Linux and can see the data. How do I back it up as the usual ...
- 1
0
votes
1
answer
106
views
SQLServer replication between windows and linux server
I'm trying to setup a replication between a SQLServer 2016 in a windows server and a SQLServer 2019 host in linux server.
The linux instance run in a kubernetes setup and the docker image is simcube/...
Alexandre Beaulieu
0
votes
0
answers
252
views
Postgresql stops logging in docker
I am using postgres 12.12 via the official docker image and it sometimes stops logging, seemingly randomly. I am trying to figure out what could be causing this.
I'm running it on my development ...
- 101
1
vote
0
answers
352
views
After creating a table in postgres with psql, \dt gives "Did not find any relations"
I'm working with postgres14 in a docker container on a remote Rocky Linux VM. After a little bit of pain I managed to access the database from outside the container, at which point I wanted to create ...
- 11
2
votes
1
answer
285
views
Installing PostGIS SFCGAL 1.4 extension in the latest official PostGIS docker image (Debian bullseye based)
I do need to use the PostGIS SFCGAL extension in its latest version (i.e. 1.4.1 at the time of writing).
This extension is based (and needs) the libsfcgal system library.
Because the official PostGIS ...
- 342
0
votes
0
answers
198
views
MS SQL Edge running on Docker randomly quits within an hour of starting
I set up a new CentOS 7 VM (1GB of RAM, x86-64) and installed the latest version of Docker as instructed on the Docker website.
After following the instructions on Microsoft's website to create an ...
- 1
-1
votes
2
answers
193
views
Is there a short script to safely perform a major-release upgrade on a postgreSQL docker container?
The question specifically focuses on the assumed required upgrade of the data structures when stepping up to the next or even latest major release.
I know it usually involves dumping the data before ...
- 123
2
votes
1
answer
182
views
Is there a short and proven linux shell command or script to safely perform a major-release upgrade on a mariadb docker container?
The question is basically in the title already. At first I thought about a one-liner but maybe a short script is fine as well.
The command or script is meant to initiate all updating on the actual ...
- 123
0
votes
1
answer
148
views
How can I create a sql dump from postgres that I can restore on a new server with no psql options?
I want to have an easy, repeatable process of upgrading a dockerized postgres database to a new version. Minor and patch versions are easy -- the container can simply be upgraded to the new version, ...
- 765
0
votes
0
answers
117
views
MySQL 8.0.31 replications fails when running in docker container?
Since a couple of days I'm trying (unsuccessfully) to start a replication between two MySQL 8.0.31 running each in a docker on a custom port. This always fails with (Original Post):
Last_IO_Errno: ...
- 111
0
votes
2
answers
3k
views
Repeating error message "password authentication failed for user "postgres"" for PostgreSQL in a simple container
I start PostgreSQL 14.4 in a simple container in an own network (no brigde mode):
postgres:
image: postgres:14.4
volumes:
- /var/data_comm/postgresql:/var/lib/postgresql/data
...
- 1
0
votes
1
answer
3k
views
SQLSTATE[HY000] [2002] Connection refused when trying to initiate connection via Dockerfile's CMD
I'm trying to run a Docker container based on:
PHP 8.1
Apache 2.4
MariaDB (latest official docker image)
Dockerfile:
FROM php:8.1-apache
WORKDIR /var/www/html/
RUN pecl install xdebug \
&&...
- 163
0
votes
1
answer
201
views
Sql Server Management Studio does not have access to a .bak file on a remote server
I'm trying to restore a database backup that is on a server. This server is on a remote machine and runs in a docker container. The container OS is Ubuntu 20.04.
I can access the database, make ...
- 101
0
votes
0
answers
525
views
Can't connect to Dockerized MariaDB ColumnStore database from host machine
I have setup a MariaDB ColumnStore Database as described in the MariaDB ColumnStore Quick Start guide. The guide is missing some steps so these are the exact steps I took:
docker run -d -p 3306:3306 --...
0
votes
0
answers
125
views
How can I access a Docker container remotely using my domain?
I have a computer running Debian 11 and I’m trying to set up Supabase self-hosting. The official documentation only goes as far as starting the Docker containers and accessing them from http://...
- 101
0
votes
0
answers
55
views
Is it possible to add some procedures and functions to a custom SQL Server docker file?
I have this Dockerfile to customize a SQL Server image for our developers:
FROM mcr.microsoft.com/mssql/server:latest
ENV PATH="${PATH}:/Company/Commands/DatabaseContainer"
ENV ACCEPT_EULA=Y
...
- 205
0
votes
0
answers
246
views
Cannot install MySQL 8 in the Ubuntu container
I would like to install Mysql in my Ubuntu container. The reason is my app inside the container needs mysql command to run mysql -u root -p -h "mysql server IP address". But I received this ...
- 111
0
votes
1
answer
404
views
IN restrictions are not supported on indexed columns [closed]
I pull the cassnadra:latest image in Docker and run the container.
When I exec into the container and run the following query:
select count(*)
from items
where item_id in (
ef2ca439-ce2a-4254-...
- 41
1
vote
1
answer
438
views
Unable to connect to Bitnami Cassandra container from cqlsh
I am very new to cassandra I am trying to bring up cassnadra using docker-compose but it is giving connection error for cqlsh. Can you please let me know what am I missing here and how can I run init....
- 111
0
votes
0
answers
406
views
ORA-65100: missing or invalid path prefix when opening newly built PDB
After successfully executing the following;
CREATE PLUGGABLE DATABASE R237
ADMIN USER R237 IDENTIFIED BY R237
ROLES = (dba)
DEFAULT TABLESPACE R237_DATA
DATAFILE '/opt/oracle/oradata/ORACLE19C/R237/...
- 21
2
votes
1
answer
643
views
How can I access cassandra.yaml in Docker?
I use cassandra image to create cassnadra container. I use volumes as follow:
- ./samt_tmp/cassandra_data/cassandra:/etc/cassandra/
I want create cassandra.yaml from docker in my pc but this path isn'...
- 41
2
votes
3
answers
54
views
How do I block all IP addresses from connecting remotely to Cassandra?
I want access to remote cassandra with one ip address. how can I change cassandra.yaml to block all ip address except ip that I want to connect?
Can I do by cassandra.yaml ?
- 41
1
vote
1
answer
705
views
How to update mongodb configure at Docker?
I am unable to enable security parameter at docker of mongodb at mongod.conf file. So how can I configure any parameter at mongod.conf file?
I found a file inside mongodb container named it as mongod....
0
votes
0
answers
207
views
Are there any unintended side effects of limiting a mongodb docker container's CPU or RAM?
It's easy to limit RAM and CPU usage for a docker container with the docker update -m command.
We have limited RAM and CPU using docker update on multiple docker mongodb containers, particularly on an ...
- 101
0
votes
2
answers
1k
views
Converting PostgreSQL dump file into CSV files
I have a PostgreSQL database running in a docker container. I used the below command to get a dump file of the Postgres database - "docker exec -t your-db-container pg_dumpall -c -U postgres > ...
0
votes
1
answer
932
views
Can't connect to pgBouncer running in Docker [closed]
I'm not great at Docker so please bear with me.
I have a Postgres database running and exposed to the public, I now want to use PgBouncer to connect to it. The catch is that I can't use docker compose....
3
votes
0
answers
2k
views
Replication instantly fails with 1032 error; Coordinator stopped because there were error(s) in the worker(s)
I have two databases, which I'm attempting to configure in a master-slave relationship (the eventual goal is to set them as master-master, but I'll settle for getting master-slave working at this ...
