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.

606 questions
314
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,463
  • 3
  • 17
  • 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
  • 517
  • 2
  • 7
  • 11
31
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
  • 413
  • 1
  • 4
  • 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
  • 33,945
  • 27
  • 62
  • 64
21
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
  • 533
  • 2
  • 4
  • 15
19
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,131
  • 6
  • 18
  • 29
17
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
  • 65,432
  • 50
  • 254
  • 507
16
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,131
  • 6
  • 18
  • 29
16
votes
5 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
  • 411
  • 1
  • 3
  • 8
14
votes
1 answer

What does PostgreSQL Status active (exited) mean?

I have PostgreSQL with PostGIS intalled on Ubuntu 22.04. I can access the PostGIS-Layers from QGIS and work with them. When i check the status of PostgreSQL with: sudo systemctl status postgresql it returns: Active: active (exited). My apache has…
fsg
  • 243
  • 1
  • 2
  • 5
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
  • 65,432
  • 50
  • 254
  • 507
13
votes
4 answers

How to run specific version (8.4, 9.1) of postgresql pg_* command (e.g., pg_dump)

I have Postgresql versions 8.4 and 9.1 installed. For any given Postgresql command, how do I specify a specific version of the command to run? (e.g., psql, pg_dump, pg_ctlcluster, pg_restore, ...) My question is motivated by wanting to do a…
Rob Bednark
  • 2,253
  • 6
  • 22
  • 22
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
  • 371
  • 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
1
2 3
…
40 41