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

learn more… | top users | synonyms

2
votes
2answers
982 views

QGIS PostGIS Authentication Failure with “trust” option

I'm trying to setup a PostGIS db using PostgreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
2
votes
1answer
3k views

Error “cannot connect to server” installing MongoDB on Ubuntu

I'm trying to install MongoDB on Ubuntu 10.04. I followed these installation instructions. I got the following error: Error: couldn't connect to server 127.0.0.1:27017 src/mongo/shell/mongo.js:91 ...
2
votes
1answer
6k views

How to set a specific directory location for individual MySQL database?

Is it possible to set each database in MySQL to use a separate datadir? I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user ...
2
votes
1answer
128 views

To make a LVM backup of a MySQL database, would I have to reduce the logical volume size?

I am trying to learn how to do a Ubuntu LVM backup of a MySQL database. For this test I installed a fresh copy of Ubuntu 12.04.2 LTS on a new box, along with MySQL 5.5. The box has one hard drive. ...
2
votes
3answers
3k views

Installing Oracle 11g on Ubuntu 11.10

Does anyone know to how to install Oracle 11g on Ubuntu 11.10?
2
votes
1answer
71 views

Disk I/O Utilization at 95%

My disk I/O utilization is at 95% at my MySQL server. What are steps I could take to fix this? It is a Ubuntu VP with 16 GB Memory and 8 cores. Here is a screen-shot of the load:
2
votes
2answers
5k views

MongoDB service not working after upgrade to Ubuntu 15.04

I have recently upgraded my Ubuntu from 14.10 to 15.04. All features seems to be working fine except MongoDB. It is not controllable from service as we do normally in Ubuntu. sudo service mongodb ...
2
votes
1answer
325 views

MongoDB installation Ubuntu 12.04 LTS errors

I need some help with my MongoDB installation on a clean, fresh Ubuntu 12.04 LTS server with no nonsense installed. I thought it would be a piece of cake, but I got some errors and the Ubuntu-forums ...
2
votes
1answer
5k views

Merge multiple tables in a database

I have a MySQL database with table names like 1,2,3... upto 1000 Each tables have 2000 rows and has the same structure. This is how all my 2000 table's structure look like id,url,title,content id ...
2
votes
2answers
837 views

MySQL Synchronous Replication on Ubuntu 12.04 with DRBD

I have been looking around for some easy and open-source ways to handle database synchronous replication. DRDB on a Linux server seems to be one of the fastest and easiest methods to handle database ...
2
votes
1answer
3k views

Is there a PPA for MySQL 5.5 for ubuntu 10.10 and 11.10?

I want to install MySQL server 5.5 on ubuntu 10.10 and 11.10 servers but have not yet found a problem free PPA or installation method as of yet. Has anyone managed to do this with the said versions of ...
2
votes
1answer
461 views

Postgres 9.4.1 on Ubuntu 14.04.2 LTS fails to install properly

I'm trying to install PostgreSQL 9.4.1 on Ubuntu 14.04.2. I'm using the packages from apt.postgresql.org. The package installs but it fails running pg_createcluster. If I run manually, I get: ...
2
votes
1answer
941 views

Warnings while running AutoMysqlBackup

I am using Automysqlbackup.sh file to take MySql backups on Ubuntu.I have only 1 database. But when i run this script then it generates several Warnings (plus a error mail) like below Errors reported ...
2
votes
1answer
250 views

Easiest way of shutting down a PostgreSQL server on Ubuntu

According to pg_lsclusters I have 2 servers running on Ubuntu 14.04: Ver Cluster Port Status Owner Data directory Log file 9.1 main 5432 online postgres ...
2
votes
2answers
3k views

Installing and configuring postgresql 9.3 on ubuntu 13.10 using puppet

I'm having some trouble getting postgresql[1] to install with puppet[2] on a blank ubuntu box. I need to install postgresql 9.3 on Ubuntu 13.10. Since postgresql 9.3 is apparently not in the official ...
2
votes
3answers
1k views

Issues installing MySQL server on Ubuntu 13.04

I'm currently trying to install a MySQL server on my Ubuntu 13.04 machine. The problem is, when I try to install it, I get error messages indicating that not all packages could be downloaded. When I ...
2
votes
5answers
9k views

MySQL gives me:“Can't open and lock privilege tables: Table 'host' is read only”

I am facing problem restoring a MySQL database. My primary database was MySQL 5.1 and now I am trying to copy it to MySQL 5.5. The database was backed up by using Xtrabackup. I am using Ubuntu ...
2
votes
1answer
38 views

Which MySQL directories to back up using FTP

My server has been hacked and I only have FTP access to recover my data before reinstalling the OS. Which/where are the directories that needs to be backed up? Will MySQL be recovered back to its ...
2
votes
2answers
5k views

The best MySQL configuration for my server

I'm little newbie in configuring mysql and I need some advices. Few days ago I made little home server on Ubuntu Server 12.04 with samba, mysql 5.5, apache 2.2, PHP 5.4.6 etc. I'm using it to ...
2
votes
1answer
2k views

Ubuntu Multiple MySQL instances and Apparmor

I am trying to set up multiple instances of MySQL on an Ubuntu dev machine and running into AppArmor problems. I get this error in the syslogs: kernel: [227631.776360] type=1400 ...
2
votes
1answer
330 views

MySQL Replication not working properly on Ubuntu Lucid Lynx Server

I have two Linux boxes. On the master following is the configuration file (my.cnf) log-bin = master-bin log-bin-index = master-bin.index binlog-do-db = test_db server-id = 1 master ...
2
votes
0answers
90 views

Server Doesn't Listen Error when connecting to PostgreSQL from Client

I have done a lot of research through the Google and have not been able to come up with a solution. I installed PostgreSQL 9.5 and PostGIS 2.1.8 On Ubunutu Server 14.04 and configured PostgreSQL as ...
2
votes
2answers
87 views

Filesystem tuning for PostgreSQL

I want to install PostgreSQL 9.x version in an Ubuntu 14.04 workstation and I'm looking for a recommendation on how to set it up in order to get a good read-write (50/50-balance) performance keep a ...
2
votes
0answers
14 views

how to convert mongodb(2.4.10) startup2 to primary

I have standalone bitnami mongodb(2.4.10). The output of rs.status() command is below : rs.status() { "set" : "test", "date" : ISODate("2015-11-13T08:07:41Z"), "myState" : 5, ...
2
votes
1answer
72 views

MySQL Memory & max_connections Performance Tuning

So, our site runs WordPress and in the past few days we have been getting tons of spam comments etc. I believe that we are becoming the victims of some kind of bot army that has been crashing our ...
2
votes
1answer
647 views

MongoDB Replica Set: Can't Add Member/Connect

I'm building a MongoDB replicaset w/ three Ubuntu 14 servers. I'm connected to the primary server and authenticated w/ userAdminAnyDatabase and clusterAdmin privileges. When I run ...
2
votes
1answer
3k views

Setting password for 9.3 PostgreSQL server [closed]

I currently have a 9.3 server running (on Ubuntu 14.04) with "trust" set as the authentification method in pg_hba.conf. How can I set the password again. In pgadmin the server currently doesn't allow ...
1
vote
4answers
3k views

PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima

I have searched many articles in Google about the performance of PostgreSQL vs MS SQL 2008 R2 and found that many of those articles say the performance of PostgreSQL is better than that of MSSQL 2008 ...
1
vote
1answer
2k views

Do I need to set tcpip_socket = true to allow remote connections to a postgresql database?

I am trying to enable remote connections to my postgresql 9.1 db running on ubuntu 12.04. This tutorial says to "set tcpip_socket to true" -- but it is for a centos server. I am on ubuntu. I ...
1
vote
2answers
2k views

Postgresql - Segmentation fault (core dumped)

I'm working on postgresql code (server side). I installed a version from source code following the official tutorial: http://www.postgresql.org/docs/8.4/interactive/install-short.html I did same ...
1
vote
2answers
795 views

Mysql master-master permission replication issue

I came to know it's safe to replicate mysql database to have the users and permissions replicated, from a post in ServerFault is-it-ok-to-replicate-mysql-db. I have setup master-master replication ...
1
vote
2answers
4k views

PostgreSQL cannot start after replacing contents inside its Data folder

When recovering the Postgresql database from a hacked Ubuntu 12.04 server, I copied the data directory to another location, reinstalled the OS and PostgreSQL, stopped PostgreSQL service, removed the ...
1
vote
1answer
367 views

I have accidently deleted ibdata1 on an ubuntu server

I have accidently deleted the 'ibdata1' file on the server having innodb, Is there any way I can recover it? the mysql service has restarted since the deletion.
1
vote
1answer
153 views

Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?

I've set up a Postgres database on a server with 2 CPU cores, 4GB of RAM and an SSD volume (on top of RAID 10 of course). This is our (sort-of) "beefy" production database server (I can easily add ...
1
vote
4answers
8k views

How to change the data directory on Postgresql 9.1 on Ubuntu

I am having a problem changing the data directory on postgresql 9.1 on ubuntu 13.04: I first did a: sudo pg_dropcluster --stop 9.1 main and then attempted to create a new one in the desired path: ...
1
vote
1answer
248 views

What happens to existing MySQL databases when I upgrade my Ubuntu distro?

I am in the midst of upgrading my Ubuntu distro from 10.4 to 12.4. Fearfully, it asked me for root password on MySQL when I was upgrading the distro. I used to have databases on that server, would ...
1
vote
1answer
45 views

How to use SSL/TLS between server and client with Postgres?

I don't know much with it comes to security. I'm deploying a virtual machine with my database in a cloud service. I would like to encrypt all the communication between this server and any clients. How ...
1
vote
1answer
37 views

Moving postresql 9.1 database - live

This question has probably been asked and answered before, and if so, I would appreciate if that could be pointed out to me. I have googled this point quite a bit, but I want to be very sure as to ...
1
vote
1answer
101 views

Install PostgreSQL using source code or using apt-get?

I want to install PostgreSQL on a server that runs Ubuntu 14.04.2 LTS. I understand that I have two options: 1) Install PostgreSQL using the source code distribution e.g., ...
1
vote
1answer
403 views

Safely changing innodb_buffer_pool_size on MySQL replication master?

We have a MySQL server which is a replication master. We need to change the innodb_buffer_pool_size and innodb_flush_method to (hopefully) improve performance as the database has grown. What is the ...
1
vote
1answer
3k views

Howto disable Postgres listening on TCP?

Simply to avoid many problems in the first place I do not want my postgres server program to accept/listen to anything from any network (i.e. TCP/IP 4/6) connections. My setup is a Postgres 9.1 on ...
1
vote
3answers
1k views

Ubuntu: upgrading postgresql 8.4 database cluster for use with 9.2 server

I have installed PG 9.2 on my machine. I have a database cluster that was created about a year ago, using initdb, using postgreSQL version 8.4. The (8.4) data cluster consumes several Gb and so its ...
1
vote
1answer
2k views

Postgresql: what to do about upgrading “main” cluster from 8.4 to 9.1 when a 9.1 “main” already exists?

I have an existing 8.4 cluster (named main) that I want to upgrade to 9.1. However, when I go to upgrade it, I get an error because 9.1 already has a cluster named main (apparently a default cluster ...
1
vote
2answers
141 views

Trying to create PostGIS database

I am trying to create a spatially enabled PostGIS database by following the PostGIS documentation. In the short version, i executed, createdb yourdatabase createlang plpgsql yourdatabase But I did ...
1
vote
2answers
525 views

Moving MySQL database from UniServer to Ubuntu Server?

I have set up Ubuntu Server 11.10, and plan to host my website on it. Until this point I was using UniServer to host it in a portable fashion. Using the built in MySQL. This is fine, and through ...
1
vote
1answer
234 views

How can I be sure if MongoDB is doing the balance?

I have the following structure: Two Ubuntu 14.04.2, both with MongoDB v3.0.4 instaled. Both in the same LAN. I want to make them work as a cluster. In the first one, that I call "MC1", I run the ...
1
vote
1answer
179 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
1
vote
1answer
233 views

mongodb 3.0.3 Ubuntu 14.04.2 AWS m3.medium Upstart PID mismatch

(Cross posted from stackoverflow, seems like this belongs here but 10gen link to stackoverflow explicitly from their site...) Is it possible to run mongod via upstart and keep track of the PID ...
1
vote
1answer
186 views

How do you grant permissions to a MySQL user using a shell script with variables?

I'm trying to create a provisioning script for Scotch Box (Vagrant) that will populate a database with seed content when I fire up the server. When I name the actual user, database, password, and ...
1
vote
1answer
185 views

Slow database drop in mysql

Just installed a new 24 core server and it is noticeably slower when doing truncates and drops. Example: $ mysql -u root lmcdental_test2 Reading table information for completion of table and column ...