Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [debian]

113 questions
79
votes
6 answers

Disable MySQL binary logging with log_bin variable

Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled: log_bin = /var/log/mysql/mysql-bin.log When I want to disable binary logging on such installation, comment out…
Nicolas Payart
  • 2,508
  • 5
  • 28
  • 36
25
votes
3 answers

How to reinitialise /var/lib/mysql files?

Due to a mishap I deleted the entire /var/lib/mysql directory. Since the database did not contain anything important, I do not want to go through the hassle of restoring it from an old backup, but instead create the directory structure from scratch.…
Konrad Gajewski
  • 353
  • 1
  • 4
  • 10
13
votes
1 answer

Postgres privileges: psql \dp - what is about the plus-sign

I used psql-command "\dp" to find out the given grants. Versions on test-server: PostgreSQL 9.1.15 on armv7l-unknown-linux-gnueabi, compiled by gcc (Debian 4.6.3-14) 4.6.3, 32-bit Out of the postgres-handbook: rolename=xxxx -- privileges granted to…
Markus
  • 300
  • 2
  • 6
13
votes
1 answer

PgAdmin 4 installation on Debian/Ubuntu

PgAdmin 4 1.0 has been just released, but on the download page for Linux there is only a link to a yum installer. Anybody knows if there are plans to create a deb installer? Or if there is already one?
Dan Mazzini
  • 293
  • 1
  • 2
  • 9
8
votes
3 answers

Unable to start mongodb as a service - Exception; Collection does not have UUID in KVCatalog

I have installed Mongodb 4.2 and when running sudo service mongod start|restart It does not start the server and I have the log below in mongod.log file. Exception in initAndListen: MustDowngrade: Collection does not have UUID in KVCatalog.…
ako
  • 183
  • 1
  • 6
8
votes
3 answers

Install SQL Server on Debian

I want to install SQL Server on Linux. From MS site I read that Red Hat, SUSE, and Ubuntu are supported but I want to use it under Debian. Since Ubuntu is based on Debian, is there a chance to succeed with…
i486
  • 255
  • 1
  • 2
  • 10
8
votes
1 answer

Command not found: pg_ctl on Ubuntu

PostgreSQL 9.4.8 Ubuntu 16.04 64 bit I just want an explanation of what is happening here. Why is this command not found? Nothing else. malikarumi@Tetuoan2:/usr/lib/postgresql/9.4/bin$ pg_ctl stop -m fast pg_ctl: command not…
Malik A. Rumi
  • 377
  • 2
  • 7
  • 12
6
votes
8 answers

"Table doesn't exist in engine" after moving tables from one VPS to another

I have two VPS's running right now. One, which I will refer to as the "old" server, runs on Debian 7 and gives this output for mysql --version: mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (x86_64) using readline 6.2 The other, which I will…
Mitch Talmadge
  • 160
  • 1
  • 1
  • 8
6
votes
6 answers

Problem with new MySQL Workbench connection

I'm working on Debian 8 and wanted to create database using MySQL Workbench. I did everything in this tutorial, but when I created a new MySQL Connection, the program returned: Failed to Connect to MySQL at 127.0.0.1:3306 with user root, Access…
mic132
  • 61
  • 1
  • 1
  • 2
5
votes
3 answers

how to match pg_repack binary and db version

I am using this command sudo apt-get install postgresql-11-repack to install pg_repack(default to 1.4.8). postgresql-11-repack is already the newest version (1.4.8-1.pgdg20.04+1). when i run "create extension pg_repack" in rds postgres 11, it…
Falcon
  • 101
  • 8
4
votes
2 answers

In Debian/Ubuntu, what are the exact SQL commands to run to create a new database and user for your app after running `apt install mariadb-server`?

In Debian/Ubuntu, after running apt install mariadb-server there is only a root user in the database, and one can only log in locally with e.g. sudo mariadb using socket authentication as root. To actually use MariaDB for an app, one needs to create…
Otto
  • 444
  • 10
4
votes
1 answer

Postgres 13/14 JIT execution increase execution time of query considerably

I have a complex DB query that I run on different systems with identical specs, but different OS (CentOS7 vs. Debian 11). The Postgres version is 13.7, but I also tried with 14.4. I get vastly different execution times for the query on both systems…
spa
  • 223
  • 1
  • 2
  • 4
4
votes
2 answers

Specific changes to glibc 2.28 that affect PostgreSQL

I am preparing for upgrading a PostgreSQL server to Debian 10 (Buster) with the warning from Debian release notes about changes to gclibc affecting PostgreSQL in mind. The PostgreSQL wiki provides two specific strings that will be sorted differently…
rookie099
  • 368
  • 1
  • 2
  • 9
4
votes
1 answer

InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3

I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times Cannot open table mysql/innodb_index_stats [duplicate] InnoDB: Error: Table…
papanito
  • 153
  • 2
  • 6
4
votes
1 answer

Subtract time difference between two columns in a table

Problem: How can I subtract the TIMEDIFF between two sensors (sensor 1 and sensor 2 in the example below) and return the the value in mili seconds? How do I get with the resolution of milliseconds? I am using the command line below to try to create…
will
  • 43
  • 1
  • 5
1
2 3 4 5 6 7 8