Tagged Questions

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

learn more… | top users | synonyms

-1
votes
1answer
54 views

libq-dev fails to install [closed]

When I try to install libpq-dev It fails to install and gives me the folowing error: The following packages have unmet dependencies: libpq-dev: Depends: libpq5 (= 8.4.8-0ubuntu0.10.04) but ...
0
votes
0answers
43 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 ...
1
vote
1answer
40 views

Deploying a specific version of a software from a juju charm?

Suppose I'm using the postgresql charm to deploy my databases. How can I control the version of the PostgreSQL (9.1, 9.2, 9.3, etc) that is deployed? Thank you
0
votes
2answers
1k views

Could not open connection to host (ubuntu server) on port 23, 5432, 3306

I have recently installed few packages for telnet, mysql and postgreSQL. I can access all these service locally on the ubuntu server but somehow I am not able to access these services from other ...
0
votes
2answers
327 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: ...
1
vote
1answer
58 views

How can I determine the available amount of disk space when using a charm?

When using juju to deploy a DB, how can I determine the available amount of disk space when using the DB charm? Suppose that I'm using EC2 (or anywhere else) to deploy a PostgreSQL/MySQL/WhateverDB ...
1
vote
1answer
2k views

Remotely access postgresql database

I need to access a postgresql database from a remote machine on a VPS at DigitalOcean running 12.10 and postgresql 9.1. How do I do this? I noticed port 5432 is closed, how do I open this?
1
vote
1answer
55 views

Unable to boot ubuntu 12.04 Blank Screen [duplicate]

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
3answers
7k views

Postgres password authentication fails

I've installed PostgreSQL 9.1 and pgadmin3 on Ubuntu Server 13.10. I configured postgresql.conf with: listen_addresses = '*' also I configured ph_hba.conf by changed peer connections to md5 Plus I ...
1
vote
1answer
103 views

postgresql, how do I connect to it using pgadmin?

I did the following: sudo juju bootstrap juju deploy postgresql juju expose postgresql juju status environment: local machines: "0": agent-state: started agent-version: 1.16.5.1 dns-name: ...
1
vote
2answers
2k views

upgrade pgadmin3 1.16 to 1.18

I'm running Ubuntu 13.04 and have pgadmin3 1.16 installed. I downloaded pgadmin3-1.18.1.tar.gz from http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/src/ I followed all the instructions found ...
1
vote
0answers
51 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
355 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
1k 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
584 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
86 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
380 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
1k 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
184 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
6k 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
566 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
456 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
137 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
403 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 ...
2
votes
3answers
3k 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
9k 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 ...
2
votes
2answers
966 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
329 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
103 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 ...
11
votes
1answer
5k 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
3k 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
1answer
245 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 ...
1
vote
0answers
100 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 ...
2
votes
1answer
863 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
640 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
350 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
1k 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
453 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
201 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
347 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
136 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
410 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
1answer
3k 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
513 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
68 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
150 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
717 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 ...