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.

554 questions
258
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
  • 2,883
  • 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
31
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
  • 497
  • 1
  • 7
  • 11
23
votes
8 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
  • 333
  • 1
  • 2
  • 5
22
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
  • 30,365
  • 26
  • 57
  • 64
18
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
  • 473
  • 2
  • 4
  • 15
17
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,031
  • 6
  • 15
  • 23
14
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,031
  • 6
  • 15
  • 23
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
  • 57,249
  • 39
  • 210
  • 433
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
  • 407
  • 2
  • 6
  • 18
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
  • 351
  • 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
12
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
  • 1,873
  • 4
  • 20
  • 20
12
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
  • 57,249
  • 39
  • 210
  • 433
1
2 3
…
36 37