Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ubuntu]

Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

Ubuntu logo

Ubuntu is a desktop and server operating system based on Debian GNU/Linux. It has a steady release cycle and a large active user community. This tag is for questions specifically relating to databases residing on or being accessed from Ubuntu.

There is a Stack Exchange site dedicated to Ubuntu which is a good place to ask any Ubuntu-related questions.

572 questions
279
votes
10 answers

List the database privileges using psql

I'm in the middle of a database server migration and I can't figure (after googling and searching here) how can I list the database privileges (or all the privileges across the server) on PostgreSQL using the psql command line tool? I'm on Ubuntu…
pedrosanta
  • 3,093
  • 3
  • 15
  • 7
51
votes
3 answers

How to make MySQL table name case insensitive in Ubuntu?

I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default. Now, I want to make MySQL work as case insensitive in Ubuntu. Is it possible? If yes, how can I…
java baba
32
votes
2 answers

Preventing PostgreSQL from starting on boot in Ubuntu

I am using PostgreSQL 9.2 and it runs automatically when I start the system (Kubuntu). How can I avoid this? I need to start it manually, and I don't want it to start unattended because I need to look at the console.
DarkCoffee
  • 507
  • 1
  • 7
  • 11
27
votes
10 answers

How do I access Postgres when I get an error about "/var/run/postgresql/.s.PGSQL.5432"?

I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted. nmap commands show port 5432 is open. Postgres seems to be working correctly: service postgresql status postgresql.service - PostgreSQL RDBMS …
Victor
  • 373
  • 1
  • 3
  • 5
23
votes
1 answer

How to connect to an remote PostgreSQL database on Ubuntu using pgAdmin3?

I'm trying to setup a PostgreSQL database on an Ubuntu machine. I would like to be able to access it using pgAdmin3 from a remote machine. How do I setup this? I have installed the PostgreSQL database on Ubuntu using: sudo apt-get install…
Jonas
  • 31,495
  • 27
  • 59
  • 64
20
votes
3 answers

How to connect to SQL Server using sqlcmd on Linux?

I have set up the Microsoft ODBC Driver 13 for SQL Server on an Ubuntu 16.04 machine. I am now trying to test a database connection, that includes both the server name and an instance name. The following both work fine from a Windows…
geographika
  • 493
  • 2
  • 4
  • 15
18
votes
2 answers

Redis takes up all the Memory and Crashes

A redis server v2.8.4 is running on a Ubuntu 14.04 VPS with 8 GB RAM and 16 GB swap space (on SSDs). However htop shows that redis alone is taking up 22.4 G of memory! redis-server eventually crashed due to out of memeory. Mem and Swp both hits 100%…
Nyxynyx
  • 1,081
  • 6
  • 15
  • 25
15
votes
1 answer

How to Install postgresql-client-11 on Ubuntu 18.04

I need to use the pg_basebackup/pg_dump program on an Ubuntu 18.04 system to connect to a remote PostgreSQL 11.6 server. However, the current system only contains pg_basebackup 10.10 and the remote database is using PostgreSQL 11.6. Running…
Nyxynyx
  • 1,081
  • 6
  • 15
  • 25
15
votes
4 answers

MySQL SSL error: Unable to get private key

Getting an error while trying to enable encryption: [ERROR] SSL error: Unable to get private key from '/etc/mysql/ssl/nginx.key' [Warning] Failed to set up SSL because of the following SSL library error: Unable to get private…
Velkan
  • 401
  • 1
  • 3
  • 8
14
votes
1 answer

How do I totally remove SQL Server 2017 on Ubuntu?

The docs has instructions about how to remove SQL Server. However, this leaves certain packages behind. How can I remove all traces and uninstall SQL Server 2017?
Evan Carroll
  • 59,330
  • 43
  • 219
  • 447
13
votes
2 answers

Install MariaDB 10 on Ubuntu without prompt and no root password

Pretty much the same as this question but I don't want to have a root password (this is just a dev machine). Here's what I've got: export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< 'mariadb-server-10.0 mysql-server/root_password…
mpen
  • 417
  • 2
  • 6
  • 18
13
votes
2 answers

How do I disable MySQL on Linux from starting on boot or statup?

After adding MySQL to Ubuntu, it automatically starts up on server boot. I would like it to not start up with the system. How can I disable it and manually start it?
Evan Carroll
  • 59,330
  • 43
  • 219
  • 447
13
votes
7 answers

"ORA-24454: client host name is not set" when connecting from Ubuntu instance on AWS EC2

Some background: I am attempting to connect to an Oracle database. I have a username, password, IP address, port, and service name. I only have access to this database from an Ubuntu EC2 instance on AWS because the Oracle database is located inside…
Karl Johnson
  • 361
  • 1
  • 2
  • 6
13
votes
2 answers

Unable to start SQL Server on Ubuntu 16.04

I had SQL Server v.Next public preview on my Ubuntu 16.04 machine installed and working yesterday. But it's not working today. Getting below error: root@OraServer:/var/opt/mssql/log# systemctl status mssql-server ● mssql-server.service -…
Rak
  • 417
  • 1
  • 3
  • 13
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
  • 8
1
2 3
…
38 39