PostgreSQL is a powerful, open source object-relational database system.

learn more… | top users | synonyms

0
votes
3answers
413 views

Updating problem with post-gresql 9.1

I have the following error when updating my ubuntu: $sudo apt-get upgrade [...] Lecture des listes de paquets... Fait Construction de l'arbre des dépendances Lecture des informations ...
0
votes
3answers
899 views

Postgres gem won't install on 12.10

I am trying to get Ruby on Rails working on my computer but the pg gem keeps failing. I have found a lot of other questions saying that you just need to use the libpq-dev package from apt and that ...
2
votes
2answers
29 views

I'm unable to remove postgresql 9.3 after installing it

I installed Postgresql 9.3 for Ubuntu 14.04 trusty using this command: sudo apt-get install postgresql-client-9.3 libpq-dev I wanted to remove postgresql and instead install 9.2 so I ran this ...
1
vote
2answers
291 views

Trying to install postgresql:i386 on 12.04 amd64

Due to some legacy 32 bit libraries being used in postgresql functions I need to get a 32 bit install of Postgresql on a 64 bit native system. But it seems like there is a problem with the multiarch ...
0
votes
2answers
185 views

Trouble with rake db:setup

everyone! I am trying to pull a github file using rake db:setup, but I get an error every time, no matter how many times I reinstall postgresql or check rails. Here's the error I'm getting: ...
0
votes
2answers
1k views

Postgresql - configuring as Upstart job problem

I need Postgresql configured to start with the Upstart system because I use Upstarts events to start another app which depends on pgsql to be running. This is the tutorial/script I've used: ...
1
vote
1answer
531 views

Does postgresql (server) setup a main cluster after installation? (14.04)

I'm surprised that installing postgresql on ubuntu doesn't give me a working postgres server setup immediately: it requires additional steps: Setting up postgresql-common (154) ... * No PostgreSQL ...
1
vote
1answer
295 views

Can't use RStudio any more after trying to set up an ODBC connection to a postgreSQL database

I tried to Setup an odbc connection from R to my PostgreSQL database located on a server (package RODBC). When trying to connect the connection failed because I entered a wrong Username in the DSN ...
1
vote
1answer
99 views

Attempt start postgres server fails and gives no response?

When I do on my local machine. sudo service postgresql start I usually get the following or some error. * Starting PostgreSQL 9.1 database server [ OK ] But when I ...
0
votes
1answer
29 views

how to hiding Ubuntu and postgreSQL versions?

I'm seeking to closing some vulnerabilities of my postgreSQL server that is running over ubuntu 12.04 server, some of these vulnerabilities is an ability of scanners to checking versions of my OS and ...
0
votes
1answer
85 views

install and load uuid-ossp on PostgreSQL

How can I install uuid-ossp extension on PostgreSQL 9.3? Is it using apt-get install? I did select * from pg_available_extensions; but I found no extensions that relates to uuid-ossp.
0
votes
1answer
194 views

Removing old postgresql after upgrading?

I upgraded my postgresql to 9.3 following the instruction found here When I run sudo service postgresql start it shows * Starting PostgreSQL 9.1 database server ...done. * Starting ...
0
votes
1answer
349 views

Postgres uninstall: “server.key has group or world access” error

I'm trying to uninstall postgresql, but its really complaining. I suspect something is broken. I'm on 12.04, installed via apt-get. sudo apt-get remove postgresql returns: Reading package ...
0
votes
1answer
492 views

Ubuntu 12.04 Depends: postgresql-9.1-postgis

I am installing LocalWiki on a Virtual Machine hosted by 1&1.com It is Ubuntu 12.04. When I run sudo apt-get install localwiki as instructed by http://localwiki.org/install/, I get the following ...
0
votes
1answer
1k views

Installing PostgreSQL 9.x on Ubuntu 11.04

I tried following the direction from various websites: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgresql Unfortunately, it still wants to install 8.4. ...
0
votes
1answer
1k views

apt-get -f install gives error

When I run apt-get -f install, it gives the following error: # apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting ...
2
votes
0answers
220 views

Postgresql 8.2 service will not stop and uninstall

My system config is as follows: System (running on Amazon EC2) Ubuntu 10.04 Postgresql-8.2 installed and it is working. ubuntu@ip:~$ sudo /etc/init.d/postgresql-8.2 status: Running clusters: ...
1
vote
0answers
47 views

Error while upgrading postgres

Ubuntu 14.04. Package manager reported that postgresql was broken. When I tried to upgrade it produced the following error: (synaptic:30668): GLib-CRITICAL **: g_child_watch_add_full: assertion 'pid ...
1
vote
0answers
28 views

PostgreSQL Backup With Barman

I'm trying to backup my server which i created on PostgreSQL (9.1). While on my normal user i type "su barman", it asks me barman's password, i enter the password. On barman's shell i type "barman ...
1
vote
0answers
485 views

Postgis + could not access file “$libdir/postgis-2.1”: No such file or directory

I am running postgresql9.3 and postgis2.1 , it works fine. When i installed QGIS by using the following commands: sudo apt-get update sudo apt-get install qgis After installing QGIS the postGis is ...
1
vote
0answers
46 views

Connecting sublime_text3 editor with postgresql

I am new in sublime_text3. I want to connect my sublime_text editor with my system PostgreSQL in ubuntu12.10. I have tried few plugins but its not working. Any one have any idea how to do that?
1
vote
0answers
94 views

Symbolic link error to Java / LIBJVM

All, When trying to install postgresql, I get the following error: /sbin/ldconfig.real: usr/lib/jvm/java-1.7.0-openjdk-amd64/jre/lib/amd64/jamvm/libjvm.so is not a symbolic link I think this is ...
1
vote
0answers
97 views

Ubuntu login black screen after postgis install

I just built a new computer running an ASUS P8Z77-V LK motherboard with no graphics card. Can boot into Ubuntu, run a bunch of the usual programs (Chrome, etc) no problem. However, when I install ...
1
vote
0answers
344 views

Installation of postgis 2, postgresql 9.1 dependency errors

A couple of months ago I installed Postgesql 9.1 and Postgis 2.0 on my Ubuntu 12.04 server. Now I can't do any apt-get upgrades or installs because of this installation with broken libgdal1 ...
1
vote
0answers
955 views

Postgresql starting error

The postgresql 9.1 database server is not starting. Can anyone help in this. * Restarting PostgreSQL 9.1 database server * Removed stale pid file. The ...
1
vote
0answers
334 views

How to run Python- postgresql in ubuntu 12.04

I am trying to test pyhton-postgresql script in ubuntu 12.04. The script is this: import psycopg2 import sys con = None try: con = psycopg2.connect(database='mydb', ...
1
vote
0answers
298 views

ldap postgresql backend segmentation fault

I am running the latest version of LDAP on XUbuntu 12.4 LTS and it works pretty fine as long as I use hdb or bdb as the backend. Nevertheless when I change the backend to sql and try to restart the ...
1
vote
0answers
428 views

Postgresql server doesn't listen

I just recently install PostgreSQL on our server via SSH. The installation went successful, until the time I tried to connect to it using pgAdmin on my Windows machine. I received this kind of error: ...
0
votes
0answers
28 views

weird behaviour

I am using the Ubuntu 12.04 Precise Pangolin, from past few days I am observing a strange behaviour with my ubuntu server. Let me give you a brief introduction to my server. Installed Softwares and ...
0
votes
0answers
14 views

How can I install pg_test_fsync on Ubuntu Server 14.04?

I attempted to install pg_test_fsync on Ubuntu 14.04 LTS and it appears it cannot be installed without removing postgresql. How can I install pg_test_fsync and keep postgresql? $ pg_test_fsync The ...
0
votes
0answers
22 views

Depending on postgresql-plpython for every installed version of postgresql

I'm working on a project which gets installed as an Ubuntu package. This is part of the code for generating the database (modified): CREATE EXTENSION plpythonu; CREATE FUNCTION foo (str text) ...
0
votes
0answers
18 views

packet-o-matic on Trusty 14.04

I'm trying to install pom on Trusty and have installed the pre-reqs listed at http://wiki.packet-o-matic.org/pom/installation but pom ./configure fails to recognize postgresql root# ./configure . ...
0
votes
0answers
39 views

installing plperl in postgresql

I am trying to use the perl language in postgresql, thus I need to install plperl. I am running all of my queries in pgadmin III. When I first tried create extension plperl; I get the following ...
0
votes
0answers
23 views

Postgresql ubuntu 12.04 not starting

I installed PostgreSQL on ubuntu 12.04, using apt-get install postgresql Everything worked fine. I made database, inserted data etc. Then I rebooted my computer, and postgres did not start. There is ...
0
votes
0answers
220 views

Problems in installation of Postgresql

I got following error while installing postgresql client The following packages have unmet dependencies: postgresql-9.3 : Depends: postgresql-client-9.3 but it is not going to be installed Depends: ...
0
votes
0answers
65 views

Problem installing postgresql on ubuntu 12.04 LTS error "cannot find proc/version

I'm trying to install PostgreSQL on my VPS running Ubuntu 12.04. A month ago I success installed Postgresql 9.3 but I forgot the Postgis extension, after I installed the Postgis there come a problem ...
0
votes
0answers
151 views

Failure to install postgresql-plperl-8.4 on Ubuntu 14.04

I have recently had a problem installing postgresql-plperl-8.4 on the new Ubuntu 14.04 distribution. The reason why I am installing older version of plperl is that the server getting upgraded needs to ...
0
votes
0answers
35 views

Automate backups of multiple Postgresql _CLUSTERS_

I'm looking for a way to automate backing up multiple PostgreSQL clusters. Any thoughts/hints before I do the following? I've already found the autopostgresqlbackup package. Which is a functional ...
0
votes
0answers
125 views

~/.pam_environment isn't being set on reboot

I want to use PostgreSQL PlPython3u on Ubuntu 12.04. At first I run create extension plpython3u I has error, so I add python path to PATH sudo su - postgres stop service ...
0
votes
0answers
283 views

Ubuntu login screen doesn't show up after installing postgresql

I just installed Ubuntu 12.04 on my new machine and everything works fine. However, when I install postgresql and shut down the computer, when I log back in, there's no graphical login screen. The ...
0
votes
0answers
62 views

Automatize production server deployment

I have some java servlets to deploy in a production environment. I want to automatize installation and deployment of the whole service. My servlet is running on Tomcat and uses PostgreSQL as DB. I ...
0
votes
0answers
684 views

Postgres - psql could not connect to the server

I instaled using: sudo apt-get install -y postgresql postgresql-contrib When I run psql, there is an error: psql: could not connect to server: No such file or directory Is the server running ...
0
votes
0answers
469 views

Upgrading Postgresql from 9.1 to 9.2 on Ubuntu

I am trying to upgrade Postgresql on Ubuntu from 9.1 and running into dependency issues. sudo apt-get install postgresql-9.2 outputs: Reading package lists... Done Building dependency tree Reading ...
-1
votes
0answers
14 views

CakePhp does not work in Ubuntu 14.04

I have installed cakephp v2.4.6 in Ubuntu 14.04 (64 bit) and database is PostgreSQL. The same system works fine in Windows environment but after I transfer it into Ubuntu, it shows some issues. 1) ...