A simple question about scalability. I have been studying about scalability and I think I understand the basic concept behind it. You use an orchestrator like Kubernetes to manage the automatic scalability of a system. So in that way, as a particular microservice gets an increase demand of calls, the orchestrator will create new instances ..
I am making a Telegram bot with a PostgreSQL database. Everything works correctly on the local computer, but when I upload the code to the server using docker-compose, the following errors appear in the console from time to time: 2021-10-10 02:08:58.865 UTC  FATAL: password authentication failed for user "pgadmin" 2021-10-10 02:08:58.865 UTC  DETAIL: ..
Hi guys I understand there are a lot of threads on this topic, however I have been unable to find anything that works and am I completely stuck. my Docker-Compose file looks like : version: "3.8" services: app: build: . ports: – 9090:5000 links: – db:database db: platform: linux/x86_64 image: mysql command: –default-authentication-plugin=mysql_native_password restart: unless-stopped ..
I want to create a user from JDBC (if possible) in an ORACLE Express database. That user can’t have the ORACLE_MAINTAINED flag in the DBA_USERS view. Trying CREATE USER newuser IDENTIFIED BY xxx, but it throws a ORA-65096: invalid common user or role name. To avoid it, I had to set the flag ALTER SESSION ..
Input Data wk_end_d Total Volume 2/6/2021 236255 2/13/2021 231962 2/20/2021 190785 2/27/2021 209750 3/6/2021 234347 3/13/2021 210586 3/20/2021 217937 3/27/2021 266082 4/3/2021 228382 4/10/2021 200622 4/17/2021 260464 4/24/2021 229509 5/1/2021 259193 Output how iam looking for is .How can I achieve this the calculations are interdependent |wk_end_d| |Total Volume| |New Volume| |Worked Volume| |Remaining Volume| ..
We recently moved our database to a centralised server for our whole team to use the same data source instead of using dumps from the database and spinning it up in a docker container. Recently, I noticed that when executing the same SQL-query multiple times on the server returns different results whereas when using the ..
I can connect my docker postgresql in my local server windows via ip or localhost. When I try to connect it remotely from my personal windows I have timeout error. Thinking about 5432 port is blocked or not listening. I have changed pg_hba.conf & postgresql.conf files for remote connection and also checked for firewall but ..
I have a VPS running Ubuntu 18.04. The server is running an ASP.NET Core application in a docker container and SQL Server Express 2019 is NOT in a container. I am trying to access a database from an application. My connection string: Server=host.docker.internal,1433;User ID=SA;Password=mypass;Database=mydb In application services.AddDbContext<UniversityContext>(options => options.UseLazyLoadingProxies().UseSqlServer(Configuration.GetConnectionString("ConnectionString"))); I get an error SqlException: A ..
I am trying to inspect a database content inside an Oracle XE from a Docker POD, but when I create a query string I get only the first 80 characters from each text column. How could I get the entire content using only the sqlplus terminal, NOT the SQL Developer? I tried to use spool ..
Cannot connect to mssql localhost instance via Azure Data Studio. Get: ‘login failed for user sa’. In the same time I’m able to successfully connect via terminal: mssql -u sa -p myPassword mssql is in docker with status up sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=myPassword -p 1433:1433 –name sql1 -h sql1 -d mcr.microsoft.com/mssql/server:2019-latest os: ..