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

learn more… | top users | synonyms

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
1answer
298 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 ...
0
votes
1answer
833 views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
0
votes
1answer
464 views

“ERROR: role ”$user“ does not exist” when setting up postgresql server

When I tried to follow the "alternative server setup" as detailed here: PostgresSQL, I got the error ERROR: role "$user" does not exist when I ran postgres=# \password $USER and entered my new ...
1
vote
1answer
85 views

Can't select postgresql in libre base

After freshly installing Ubuntu 13.10 (64 bit) and Libre Base 4.1 (using the software center) the selector for PostgreSQL databases is missing. Can't figure out what might be missing. I installed all ...
0
votes
1answer
305 views

Interacting with PostgreSQL on remote server through SSH tunnel?

I have User A setup on my webserver with it's public SSH key copied over to User B's ~/.ssh/authorized_keys over on my database server. The idea is to use an SSH tunnel to facilitate the communication ...
0
votes
2answers
979 views

Postgresql installation on Ubuntu 12.04

I have trouble installing postgresql with apt. postgresql-9.1 (or postgresql-9.3) installation fails with: * Starting PostgreSQL 9.1 database server * Error: could not exec ...
0
votes
1answer
141 views

Cannot connect to PostgreSQL server

I'm trying to set up a PostgreSQL server using the instructions found on here. I installed the package via apt-get install postgresql and now I'm on the step: sudo -u postgres psql postgres which ...
2
votes
3answers
4k views

pg_ctl: command not found, what package has this command?

I have installed pgadmin using the ubuntu software center and am trying to access a local database (recently downloaded from the internet). I have tried to run the pg_ctl command (running as postgres) ...
0
votes
1answer
425 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
368 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
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
2answers
382 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
6k 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
707 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
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 ...
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 ...
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
4k 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
127 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
1answer
196 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
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
687 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
798 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
617 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
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
957 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
1answer
389 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
172 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
119 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
353 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 ...
0
votes
0answers
470 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
481 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
67 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
139 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
625 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
736 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
804 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
299 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 ...
17
votes
7answers
33k 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 ...