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

learn more… | top users | synonyms

0
votes
3answers
370 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
797 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 ...
1
vote
2answers
192 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
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: ...
2
votes
1answer
581 views

Error starting up postgresql in 12.10

The following NEW packages will be installed: libpq5 postgresql-9.1 postgresql-client-9.1 postgresql-client-common postgresql-common 0 upgraded, 5 newly installed, 0 to remove and 2 not upgraded. ...
1
vote
1answer
34 views

Unable to boot ubuntu 12.04 Blank Screen

I install likewise open and connect to sama on some other server when i restart the computer, curser blinks but nothing happens. when I press the power button on the CPU then only screen displayed, ...
1
vote
1answer
59 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 ...
1
vote
1answer
133 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
58 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
1answer
250 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
899 views

PostgreSQL postmaster not starting

I'm trying to install a PostgreSQL instance after building it from source, but running the postmaster daemon prior to starting up the database cluster doesn't seem to work. Here's the error message I ...
0
votes
1answer
411 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
189 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
34 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
151 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
0answers
67 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
80 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
733 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
316 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
433 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
vote
0answers
247 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
397 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
17 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
112 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
276 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
52 views

Automatize production server deployment

I have some java servlet to deploy to production enviroment. I want to automatize installation and deployment of whole service. My servlet is running on Tomcat and use PostgreSQL as DB. I want to ...
0
votes
0answers
525 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
281 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 ...
0
votes
0answers
69 views

How do I move a Postgres DB to my home directory?

I have a large Postgres DB that I am using for some data analysis. I didn't realize that Postgres defaulted to store data on the root partition, and now I am running out of room on that partition. ...
0
votes
0answers
1k views

variety of instructions for this error: Error: Unable to initialize gtk, is DISPLAY set properly?

I have pgadmin3 installed on a remote ubuntu server (running nginx) following the instructions I got here https://help.ubuntu.com/community/PostgreSQL Error: Unable to initialize gtk, is DISPLAY set ...
0
votes
0answers
268 views

pgadmin3 Error connecting to the server

I can't connect to the server through pgadmin and the error was: Error connecting to the server: server closed the connection unexpectedly. This probably means the server terminated abnormally ...
0
votes
0answers
66 views

Ubuntu crashes while upgrading from 11.04 to 11.10 while installing Postgresql

I am in the process of upgrading from Ubuntu 11.04 to 11.10 , but I've experienced the same error for the second time now after trying to upgrade for a second time. I used the Update Manager program ...
0
votes
0answers
434 views

13.04 Upgrade Options from Terminal

I will be upgrading a production server from 12.10 to 13.04 from the terminal. I encountered issues upgrading my notebook which resulted in uninstalling PostgreSQL 9.2 (full details here). This ...
0
votes
0answers
27 views

Is there a way to install specific Postgresql driver version

I need to install a specific version(version 9.1.5)of Postgresql Driver for PHP, I am currently using version 9.1.8 and I do not know if the driver version is causing the errors on my code. I am ...
0
votes
0answers
244 views

Installation of : Django-CMS+PostgreSQL+Ubuntu12.04 on a separate system user account

I am new to Django CMS and Ubuntu. I would like to install Django-CMS on a separate system user on Ubuntu, so that my python environment dedicated to Django-CMS would not conflict with other python ...
0
votes
0answers
210 views

Getting a mongodb error whlie installing python-psycopg2?

I tried to install python-psycopg2 But the installation fails and I get this error: E: mongodb-10gen: subprocess installed post-installation script returned error exit status 1 Preparing to replace ...