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

learn more… | top users | synonyms

0
votes
1answer
365 views

Move PostgreSQL temporary file location

How do I move the PostgreSQL temporary file / cache location? I have limited space on my system partition so it keeps throwing me errors like this one: ERROR: could not extend file ...
0
votes
1answer
342 views

failed to uninstall postgres-xc

While trying to set up my rails environment to use postgresql I mistakenly installed postgres-xc. However an error occurred in installation, so when I tried to remove the package I get the following ...
1
vote
1answer
94 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
2answers
363 views

why there is difference between psql -version output and the psql version connected to my application? how can I resolve this

I am building up a rails application that I cloned from my friend. I am using Ubuntu 13.10, rails 3.2.14. I am using a postgresql database and when I try to run rake db:migrate it gives me some error ...
1
vote
3answers
2k views

Install postgresql. Why is initdb unavailable?

I'm following these instructions, however I can only get to step 17.2. Despite installing postgresql successfully via the sudo apt-get install postgresql command, upon running initdb -D ...
2
votes
3answers
5k views

Uninstall postgresql from Ubuntu

I simply don't understand what's going on. sudo apt-get remove postgresql results in: Reading package lists... Done Building dependency tree Reading state information... Done Package ...
1
vote
2answers
600 views

APT tries to configure PostgreSQL each time I try to install a package

I'm getting some strange errors lately whenever trying to apt-get install anything. Here's an example from trying to install fluidsynth. $ sudo apt-get install libfluidsynth1 Reading package ...
1
vote
2answers
282 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 ...
1
vote
0answers
92 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 ...
2
votes
1answer
4k views

Trying to install Postgres 9.3 in a non-LTS version of Ubuntu, how do I go?

I'm trying to install Postgres 9.3 with the instructions here. But the install is failing. [ubuntu:~]$ lsb_release -c Codename: raring [ubuntu:~]$ [ubuntu:~]$ cat ...
9
votes
1answer
3k views

Postgres doesn't have hstore extension

I was trying to run the following command but i threw me any error. template1=# CREATE EXTENSION hstore ERROR: could not open extension control file ...
2
votes
2answers
2k views

Installing postgres on 13.04: no valid OpenPGP data found [closed]

Following the UbuntuGeek instructions for installing Postgres on Ubuntu 13.04 (and reinforced here), I'm getting stuck at this command: wget --quiet -O - ...
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 ...
1
vote
1answer
179 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
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 ...
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 ...
0
votes
0answers
61 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
660 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 ...
2
votes
1answer
773 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. ...
3
votes
1answer
611 views

Installing postgres removes rabbitmq and vice versa. How to make both stay?

I need both rabbitmq-server and postgresql to be installed on my machine and apt-get installing one removes the other. Here is the output from install commands: $ sudo apt-get install postgresql ...
1
vote
0answers
339 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
909 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 ...
0
votes
0answers
81 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
1answer
360 views

Unable to start PostgreSQL: Operation not Permitted

I have a question about starting and using postgresql once it has been installed. Here is the command that I have used and the error message: dbacc@dbacc-Compaq-615:~$ /etc/init.d/postgresql start ...
0
votes
1answer
161 views

how to take rcp to take daily backup of database from my ubuntu server to my local system?

I found this article http://www.howtogeek.com/135533/how-to-use-rsync-to-backup-your-data-on-linux/ but it looks outdated and I felt I may get a better answer at AsuUbuntu :) I have a server running ...
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', ...
2
votes
2answers
106 views

Will apt-get dist-upgrade blow away my PostgreSQL server setup?

I'm about to upgrade my webserver, my site relies heavily on PostgreSQL database and settings. I started apt-get dist-upgrade, and it says it wants to upgrade Postgres. I cancelled, but will it wipe ...
0
votes
1answer
332 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 ...
1
vote
1answer
1k views

Configuring Postgresql 9.1 and PostGIS 2 on Ubuntu 13

I'm following this manual to Configuring Postgresql 9.1 and PostGIS 2 on Ubuntu 13 in Amazon AWS, when executing sudo apt-get update I get lot of errors and warnings for example: Err ...
1
vote
0answers
465 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
1answer
2k views

How to install postgresql-8.4?

sudo add-apt-repository ppa:pitti/postgresql # ... OK sudo apt-get install postgresql-8.4 Reading package lists... Done Building dependency tree Reading state information... Done Package ...
0
votes
1answer
479 views

Setting up Django and Posgtresql on ubuntu

I am running Kubuntu 12.04 LTS. I have been reading the django book and I have hit a snag where I'm unable to set up posgresql to work with the django app. I have installed both python-postgresql ...
0
votes
1answer
66 views

Unable to run PostgreSQL 9.2 [duplicate]

I followed an instruction on how to setup Ubuntu 10.04 with PostgresSQL $ psql Or this: lucid@ubuntu:~$ sudo -u postgres psql postgres [sudo] password for lucid: psql: could not connect to ...
0
votes
2answers
2k views

How to create .s.PGSQL.5432?

I installed postgresql 9. By mistake,I deleted the .s.PGSQL.5432. Now i cant able to add server from pgAdmin. I don't have any server in on . How to create .s.PGSQL.5432? No such file or directory ...
1
vote
1answer
136 views

What accounts for the differing instructions on setting password for postgres?

I'm following this blog post http://hendrelouw73.wordpress.com/2012/11/14/how-to-install-postgresql-9-1-on-ubuntu-12-10-linux/ to install postgres on ubuntu. These are steps two and three. STEP 2: ...
3
votes
1answer
589 views

I don't want to store passwords in an unencrypted file

I'm using Ubuntu 12.04 LTS on my developer machine and just realized that psql stores passwords in '~/.pgpass'. Furthermore this file is unencrypted. So anyone who has super user rights (i.e. is in ...
2
votes
2answers
1k views

Cannot open port

I've been struggling to open the port 5432 for remote PostgreSQL access. Which I installed on a Ubuntu 10.04 desktop machine. Here is the shell log: xybrek@ubuntu:~$ sudo ufw allow 5432 [sudo] ...
1
vote
3answers
1k views

Install postgresql. Unmet dependencie “ postgresql-common”

I'm trying to install postgis on Ubuntu 13.04. I've attempted to follow a number of different blogs and wikis on line, but always run in to the same problem... $sudo apt-get install postgis ...
0
votes
1answer
705 views

Got “Package operation failed” error while installing postgresql using ubuntu software center

I am trying to install JDownloader. But, while installing it using sudo apt-get install jdownloader, I got some error. Like this: j@ubuntu:~$ sudo apt-get install jdownloader Reading package lists... ...
0
votes
1answer
792 views

How to setup DB in postgresql 9.2.4 on 12.04.2 LTS

I THINK I have PostgreSQL running correctly on my box: I have a PID and I see that postgres is "listening" on port 5432. I'm trying to create a DB to experiment with, using the "Book" db outlined in ...
1
vote
0answers
274 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 ...
18
votes
7answers
32k views

How to install PostgreSQL on Ubuntu 13.04?

How to install PostgreSQL in Ubuntu 13.04? I followed by this tutorial, How to install postgreSQL 9-2 - UbuntuGeek.com But in logs it says: the package is deprecated and no longer will be used ...
2
votes
1answer
5k views

Postgres - could not create shared memory segment: Invalid argument

Shmmax, Shmall, I just can't win ;) I've tried changing around my /etc/sysctl.d/30-postgresql-shm.conf file a fair bit uncommenting and changing the kernel.shmmax and kernel.shmall a bit but it ...
3
votes
4answers
13k views

Uninstall Postgresql 9.1.1

I have Postgresql 9.1.1 in my Ubuntu 12.04 which got installed due to automatic upgrades and whenever I uninstall it using the command: sudo apt-get --purge remove postgresql-9.1.1 I get an error ...
3
votes
2answers
1k views

How do I downgrade PostgreSQL?

In my ubuntu 12.04 x64 I installed PostgreSQL 8.4. It got automatically upgraded to 9.1.1. Due to some inconsistencies, I want to downgrade it to 8.4. How can I do this using the terminal?
0
votes
1answer
185 views

Update postgresql with latest security update

PostgreSQL announced on the 4th of April a security update to its PostgreSQL server. I really want to install that update. But if I run sudo apt-get update and sudo apt-get upgrade the update does ...
1
vote
0answers
14 views

How to upgrade postgresql from 9.2.0 to 9.2.4 [duplicate]

The title says it all. if I run sudo apt-get update and then sudo apt-get upgrade none of the postgresql packages get updated. While the psql version 9.2.0 is and the last update is 9.2.4. Am I ...
2
votes
1answer
220 views

Getting powernap's IOMonitor to work with postgresql

I have a 12.04 box running postgresql 9.1.8-0ubuntu12.04, which serves a Java webapp (an Atlassian Confluence wiki). I'm trying to take advantage of powernap's IOMonitor feature. However, if I ...
0
votes
1answer
1k 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 ...
3
votes
1answer
2k views

pg_connect(): Unable to connect to PostgreSQL server

I have read multiple articles detailing this fix for this exact issue. I have tried all kinds of variations of editing the pg_hba.conf file but no luck I still get the following error in my Apache log ...