Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.
1
vote
1answer
25 views
Moving postgresql data directory
I moved postgresql's data directory by following the following steps:
Stop postgres
cp -a source_data_directory destination_data_directory
export PGDATA=destination_data_directory
Changing data ...
2
votes
1answer
29 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. ...
0
votes
1answer
29 views
Ubuntu / MySQL - How to choose from the various downloads?
I have Ubuntu 12.04.2 LTS. I would like install MySQL 5.5.29.
So I go to the MySQL 5.5 archive page
http://downloads.mysql.com/archives.php?p=mysql-5.5&o=other
and scroll down to section 5.5.29
...
0
votes
1answer
41 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
4answers
79 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:
...
2
votes
1answer
27 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 ...
1
vote
1answer
170 views
MySQL my.cnf Optimization
We are an email marketing company and we recently switched our setup to MySQL. We need to configure MySQL (my.cnf) for extreme performance.
We have tried to configure my.cnf but heavy queries got ...
1
vote
2answers
143 views
Ubuntu / MySQL / Percona XtraBackup gives error “sh: 1: xtrabackup_55: not found”
Hello I installed Ubuntu 12.04.2 LTS on a fresh box.
This installed MySQL 5.5.29.
I installed percona-xtrabackup-2.0.6-521.tar.gz, and moved the executables to /usr/bin/
But innobackupex is ...
1
vote
1answer
49 views
clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
After a fresh PostgreSQL install (version 9.2) on my Ubuntu server 12.04, clusterdb utility stopped working. I used the same config files as I used with version 9.1.
Below is the actual command:
...
2
votes
2answers
113 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, ...
1
vote
1answer
407 views
How to Install/Configure Oracle Instant Client on Ubuntu
Installing the Oracle Instant Client on Ubuntu/Debian based systems is awkward since Oracle is RPM centric regarding its Linux support.
What's the best way to easily install and configure the Instant ...
0
votes
1answer
172 views
upgrade mysql 5.1 to 5.5 on Ubuntu 11.10
I currently have mysql server 5.1 installed via apt-get on my production Ubuntu 11.10 server
root@Ubuntu-1110-oneiric-64-minimal$ dpkg --get-selections | grep sql-server
mysql-server ...
3
votes
1answer
146 views
Enable MySQL to use more than 1 core (multicore) [duplicate]
I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28
Is there a way to ...
0
votes
1answer
153 views
Ubuntu 12, PostgreSQL 9.2, PostGIS 2.0
At the current moment, March 4th 2013, can PostGIS2.0 be install with PostgreSQL 9.2?
I checked their website and to my understanding it is not possible...
I hope that's not the case. Can anyone ...
0
votes
2answers
190 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
1answer
278 views
Very poor insert performance MySQL / Percona Server
I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been ...
1
vote
2answers
440 views
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 ...
0
votes
1answer
216 views
libreadline.so.6
when I was installing PostgreSQL from source code I had to install the libreadline.so.6 library.
From that moment I can't update my kubuntu system.
The error is:
Setting up ubuntu-keyring ...
1
vote
2answers
212 views
Freeware GUI tool for DB2 , usable in Ubuntu Linux
Are there any freeware user interface tools for DB2 to be used in Linux (Ubuntu 11.04)? RazorSQL is pretty good, but it's not freeware.
2
votes
1answer
2k views
Installing Oracle 11g XE on Ubuntu 12.04
I have spent the last 6 hours trying to install Oracle 11g on Ubuntu. Obviously, I'm not the only one who has struggled with this, as there is a lot of (often misleading) "documentation" online on how ...
1
vote
1answer
225 views
restore compressed dump query in postgresql asks password
I'm using ubuntu OS and I took backup using
sudo -u postgres pg_dump dbname | gzip > filename.gz
in the file path as...
/home/administrator/Documents/DB_Backup# sudo -u postgres pg_dump dbname ...
1
vote
3answers
457 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 ...
2
votes
2answers
1k 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 ...
4
votes
1answer
1k views
Install PostGIS v2 for PostgreSQL v9.2
I have installed the latest stable version of PostgreSQL v9.2 and I want to install the PostGIS v2 extension.
I've been searching for it for 3 days now, however can't find it.
I did however find ...
2
votes
1answer
1k 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
...
1
vote
0answers
73 views
MySQL replication backup
How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu.
What happens if,
I issue or schedule ...
1
vote
1answer
117 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 ...
3
votes
2answers
4k views
Error: couldn't connect to server 127.0.0.1:27017 src/mongo/shell/mongo.js:91 when changing mongodb data directory
I already change the owner of the directory I want to use
root@ip-10-138-30-205:/media/newdrive# ls -l ...
2
votes
2answers
86 views
Which option do I have to modify to see more records without press `q`
I'm connected remotly to my database server with cygwin in full screen.
When I query my database with
select id, name from table limit 27;
I get 27 records and I can do a new query seeing the ...
0
votes
1answer
343 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 ...
0
votes
2answers
76 views
Trying to create PostGIS database
I am trying to create a spatially enabled PostGIS database. I am following the PostGIS documentation, http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2648455.
In the short ...
4
votes
2answers
837 views
Recover PostgreSQL database from WAL errors on startup?
I'm trying to set up an OpenStreetMap server on an Ubuntu 12.04 machine using the Ubuntu packages listed at switch2osm.org. I initially installed and set up everything using a Northeast US-only map ...
1
vote
3answers
2k views
Starting postgresql service and specifying data directory
I have recently installed pg 8.4 on Ubuntu 10.0.4 using apt-get install.
It installed pg as a service which starts ehenever the machine starts. However I have created a db cluster in a specific ...
3
votes
2answers
814 views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
5
votes
3answers
1k views
Upstart script in ubuntu for mongodb
I am new to linux and mongodb.
I've already installed mongodb on ubuntu but I want to run one more instance on different port.
As I understood from other questions and forums , there must be upstart ...
0
votes
2answers
279 views
MySQL upgrade on Ubuntu - any heads ups?
I am needing to upgrade MySQL on Ubuntu, it is a production server and naturally cautious.
My many googles look to be essentially saying that I need to :
Backup my current mysql database and ...
5
votes
1answer
7k views
How to connect to an remote PostgreSQL database on Ubuntu using pgAdmin3?
I´m trying to setup an 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 ...
0
votes
1answer
1k views
MySql 5.5 in ubuntu repository
Sorry for duplicate question.
I am looking for the best way to install mysql 5.5 on ubuntu.
So far, there are few options:
Installing from tar.gz
Installing from PPA.
Alien on RPM.
All of them ...
1
vote
1answer
1k 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 ...
3
votes
1answer
329 views
oracle 11g seems to die every 2 days, how can i debug what's happening?
I installed oracle 11g on ubuntu 11.10, but it seems that every couple of days I'll get to work and the database isn't running but the listener is.
To fix it, all I have to do is login and start it ...
2
votes
1answer
1k 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 ...
1
vote
2answers
3k views
Installing Oracle 11g on Ubuntu 11.10
Does anyone know to how to install Oracle 11g on Ubuntu 11.10?
1
vote
0answers
735 views
Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2?
Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ?
updated to answer the 3 questions:
mysql> show variables like 'version%';
...
6
votes
2answers
928 views
View Postgresql Memory Usage
I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
4
votes
1answer
495 views
Substantial difference between database size under MySQL and actual size on disk
When I check the size of my databases under MySQL I get this:
MariaDB [(none)]> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", ...
4
votes
1answer
2k views
Connection to an oracle db from another computer
I have installed Oracle 11g to an ubuntu, I can connect to DB using sqlplus from the localhost, But I cannot connect from another computer, I have configured my tnsnames.ora as followed;
ELIF =
...
1
vote
2answers
394 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
233 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 ...
5
votes
5answers
3k views
MySQL said “InnoDB: Initializing buffer pool, size = 128.0M”, does it mean it is using 128MB RAM?
I am just using a very few InnoDB tables (e.g. less than 1MB), but during MySQL startup, it said
InnoDB: Initializing buffer pool, size = 128.0M
Does it mean even I am using in such a small size, ...
2
votes
2answers
1k views
Mysql consumes a lot of memory
Here is my situation.
I have an ubuntu server monitored by nagios.
recently nagios sends alarms regarding the memory consumption on the server. I logged into the server and executed the top command ...
