Tag Info

Hot answers tagged

5

14.04 shipped with PostgreSQL 9.3, so that's what you're going to get if you use Ubuntu's repositories. If you want PostgreSQL 9.4 or newer releases you need to add a 3rd party package repository, like the official PostgreSQL repositories from http://apt.postgresql.org/ . See the instructions there for details. (You should also probably read ...


3

Though I have serious doubts in your description, let's first clean up some misconceptions. Oracle is what is called a Relational Database Management System or RDBMS (the company developing it is called Oracle For short, too). It is used – who would have guessed it – to store and retrieve data based on its relations. It requires an operating system to run. ...


2

I suspect you had MongoDB 2.4 installed previously. In MongoDB 2.4 the service was called mongodb and used /etc/mongodb.conf (ref: Install MongoDB 2.4 on Ubuntu). With MongoDB 2.6 there was an attempt to have more standard package names across Linux distributions, so the service was renamed to mongod (to reflect the actual daemon being started) and the ...


2

I have been asking the same question for several months and have also been unable to find a clear answer on the internet. Perhaps that means that I'm more concerned than I should be; perhaps I should not be doing database server maintenance... So I was forced to do this yesterday, and everything worked well. This is how I went about it: I upgraded the ...


2

Option 1: remove createdb for 9.1 When in doubt, use dpkg -S to learn which packages provide a certain command. Example: $ dpkg -S createdb postgresql-doc-9.1: /usr/share/doc/postgresql-doc-9.1/html/tutorial-createdb.html postgresql-doc-9.1: /usr/share/doc/postgresql-doc-9.1/html/app-createdb.html postgresql-client-9.1: ...


2

Since your error is: Failed to restart mongod.service: Unit mongod.service failed to load: No such file or directory. This is pretty much saying that your startup path is not in the expected location or else the Ubuntu install has led to problems. See: http://docs.mongodb.org/manual/tutorial/manage-mongodb-processes/ EDIT: Updated with link to what ...


2

If the PostgreSQL version and architecture is the same on the target so they're binary compatible: Set up streaming replication with WAL archive fallback, so the new host replicates from the old one. Enable hot_standby mode so you can connect to the new host read-only. Test. Then when you're ready to cut over, stop the old server and pg_ctl promote the new ...


1

Here you are a few steps: Install postgreSQL 9.x from packages; Configure ubuntugis repository from here; Add the following lines to /etc/apt/source.list with your ubuntu version: deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu YOUR_UBUNTU_VERSION_HERE main deb-src http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu ...


1

This is the same issue as described here (for MySQL): High CPU usage from MySQL with no queries at all running sudo date -s now Caused by leap second and a bug in the kernel.


1

You have to configure the following two files pg_hba.conf host all all 0.0.0.0/0 md5 postgresql.conf listen_addresses='*' Make sure to restart postgres service after changing the files. You have to check if the port 5432 is open: http://www.yougetsignal.com/tools/open-ports/ If it's not then add a rule to your iptables: iptables -A INPUT -s 0/0 -p ...


1

Reason: Is it the same version of Mongo on both servers? Record Padding : http://docs.mongodb.org/v2.4/core/record-padding/ No Padding Allocation Strategy Changed in version 3.0.0. For collections whose workloads do not change the document sizes, such as workloads that consist of insert-only operations or update operations that do not increase document ...


1

Ok so a bit of egg on my face - I was overlooking the fact that my shiny new /etc/mongod.conf.yml contained processManagement.fork: true. Setting this to false allows start-stop-daemon to capture the appropriate PID.


1

If you install from apt-get you will be able to use apt-get upgrade option later and other apt-get build in options (available from Ubuntu). Furthermore apt-get installs binaries and manages their versions. You just install and nothing more. Installing from source gives you the ability to do a more detailed installation. (You can customize the build and ...


1

In pg_hba.conf You should set # TYPE DATABASE USER ADDRESS METHOD local all all trust Authentication method should be TRUST, that will allow You to enter postgres without password and set it for postgres user. Below you see how to change password ;) ALTER USER postgres ...


1

I did the following. I wrote a script (testfile) as below and it worked. The big difference AFAICS is that with my script I export my variables before trying to use them. BTW, I wouldn't call it $USER - I'd go with $MY_USER - there's already a Linux system variable called $USER. I also didn't have these lines #!/usr/bin/env bash # ... I just chmod'ed the ...


1

I think Rick James is on the right track, the many 30k table handles are jamming memory. In MySQL 5.5, InnoDB uses the system tablespace, which places all table data in a single OS file. This means that individual internal table data allocation, as well as handle management, happens inside MySQL (which is to say, completely in RAM as you have no swap ...


1

Not an elegant solution but after installing the package using apt-get (which fails creating the cluster but installs PostgreSQL), I switched to the postgres user and created the database using initdb. Then back to root, I created the cluster using the pg_createcluster command. This moved the configurations to /etc/postgres/9.4/main and set it all up.


1

As noted in the install page, the MongoDB distribution is comprised of several packages: mongodb-org: This package is a metapackage that will automatically install the four component packages listed below. mongodb-org-server: This package contains the mongod daemon and associated configuration and init scripts. mongodb-org-mongos: This package contains the ...


1

It doesn't look like MongoDB provides a repo for Saucy: http://repo.mongodb.org/apt/ubuntu/dists/ So if you installed via Ubuntu-provided repository you have a few options: Remove the RPM and install via binaries Upgrade to Trusty Wait for Ubuntu to update its repo.


1

You have a memory problem, something very typical in a memory-bound system, and that can be confirmed on the line: 150207 17:31:42 InnoDB: Fatal error: cannot allocate memory for the buffer pool As InnoDB cannot allocate memory for its buffer pool, it fails, and MySQL cannot start if the InnoDB engine fails (MySQL 5.5). Nothing on your my.cnf seems out ...


1

Dunno if it was true when you wrote your question, but the puppetlabs/postgresql module does some pretty clever stuff with versions that are not standard for your OS distro, including installing the required repository. Snippets from my config: In one of my puppet classes I call: class { 'postgresql::globals': encoding => ...


1

From the manual: address Specifies the client machine addresses that this record matches. This field can contain either a host name, an IP address range, or one of the special key words mentioned below. ... If a host name is specified (anything that is not an IP address or a special key word is processed as a potential host name), that ...


1

It isn't possible as SQL Server Native Client is a client library for SQL Server, not for MySQL. If you want to access a MySQL server through ODBC, then you need the MySQL ODBC driver (Connector/ODBC).


1

If you suspect there's something wrong with our database (cluster), make a copy of your database directory before you continue. Just to be sure. On Ubuntu the default directory would be: /var/lib/postgresql/9.3/main/ - but your installation may differ. Actually, your command should work (in default Ubuntu installations), because the service command starts ...


1

Solution to your problem is below :- On line 115 there is a line that says removeIO Add this after removeIO: # Remove annoying warning message since MySQL 5.6 if [[ -s "$log_errfile" ]]; then sedtmpfile="/tmp/$(basename $0).$$.tmp" grep -v "Warning: Using a password on the command line interface can be insecure." "$log_errfile" > $sedtmpfile mv ...


1

As we can see here all the required packages are rightly updated in the official repository. To solve the problem you can find a good start point here.


1

You may try installing PostgreSQL 9.2 from repository then install PostGIS 2.0 from source using below commands: Install GEOS(for topology support) wget http://download.osgeo.org/geos/geos-3.3.9.tar.bz2 tar xfj geos-3.3.9.tar.bz2 cd geos-3.3.9 ./configure make sudo make install cd.. Install PostGIS 2.0 wget ...


1

This is almost certainly memory fragmentation, as redis is well-known and loved in production and you probably haven't found a memory leak. The recommendations about setting the size of the pool won't help fragmentation. You'll have to specifically lower the Redis size - lower than your actual memory size - because Redis can't account for fragmentation - ...


1

I use PGCLUSTER=8.4/main pg_dump ... PGCLUSTER=9.1/main pg_dump ...



Only top voted, non community-wiki answers of a minimum length are eligible