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

learn more… | top users | synonyms

2
votes
2answers
101 views

postgresql broken after 14.04 despite succesful pg_upgrade [SOLVED]

I'm running an Ubuntu VPS where i'm am upgrading to 14.04. everything has gone smoothly so far. Except the PostgreSQL migration from 9.1 to 9.3. The server hosts a Django 1.6 site and the traceback ...
0
votes
1answer
92 views

PHPPgAdmin not working in Ubuntu 14.04

After a fresh install of Ubuntu 14.04, I've installed postgresql and phppgadmin from the Ubuntu repos. I am using the Apache2 webserver. PHP is working fine in the webserver, as is PHPMyAdmin, but ...
0
votes
0answers
56 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
2answers
47 views

When will PostgreSQL 9.3 be supported on any version of Ubuntu LTS?

according to http://packages.ubuntu.com/saucy-updates/database/ the latest version of PostgreSQL that's supported in Ubuntu 12.04 LTS is 9.1, specifically the package name is postgresql-9.1 ...
7
votes
5answers
11k views

Problem Installing and configuring PostgreSQL

I am a newbie here and to the server administration. A couple of days back I have registered a server with Hetzner with Ubuntu 11.04. I intend to work with PostgreSQL, for which I have installed ...
0
votes
1answer
42 views

How to remove a package after incorrect installation attempt

I was trying to install PostgreSQL 9.3 from the downloaded installer: postgresql-9.3.4-3-linux-x64.run Still learning the ropes with Linux, I believe I originally installed it using an incorrect ...
1
vote
3answers
2k 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 ...
0
votes
1answer
47 views

Postgresql server installation keeps failing due to postgresql-common error

The installation of postgresql server in Ubuntu 12.04 fails. Its seem to be due to incomplete configuration of postgresql-common package. I purged all packages related to postgresql, tried to ...
1
vote
1answer
556 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
votes
1answer
30 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 ...
1
vote
1answer
118 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: ...
2
votes
3answers
2k 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
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 ...
16
votes
3answers
27k views

How do I upgrade to Postgres 9.2?

Just recently, I've read that PostgreSQL 9.2 is released. My Ubuntu 12.04 has PostgreSQL 9.1.5 installed. How can I update to 9.2 version? I tried apt-get update and apt-get upgrade but no updates for ...
1
vote
1answer
27 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
165 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
1answer
69 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
45 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 ...
2
votes
4answers
9k 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 ...
2
votes
1answer
89 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
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
0answers
156 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
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
votes
3answers
310 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
55 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
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
3answers
865 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 ...
0
votes
1answer
394 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 ...
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 ...
5
votes
2answers
3k views

PostgreSQL 9.1 adminpack install

everywhere I see guides for postgre, it seems to be on version 8.4. In that case the instruction is: sudo -u postgres psql < /usr/share/postgresql/8.4/contrib/adminpack.sql that location doesn't ...
14
votes
6answers
29k 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 ...
0
votes
1answer
200 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
72 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 ...
16
votes
2answers
21k views

How to fix PostgreSQL installation

I upgraded from Maverick to Natty recently and everything went fine except during the dist-upgrade something went wrong with PostgreSQL. I've since tried reinstalling, removing, and even purging it ...
5
votes
2answers
8k views

rails & libpq-dev nasty dependencies

I don't know if this question belongs here, but I'll take a shot. Hi. I'm running ubuntu 11.10 dual-boot with windows vista on my machine. On Ubuntu, I've installed RVM, rails gem, & PostgreSQL ...
0
votes
1answer
159 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
3answers
807 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 ...
0
votes
2answers
399 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
603 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... ...
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
1answer
67 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 ...
6
votes
2answers
3k views

Where can I get a Postgres 9.0 package?

I want to use Postgres 9.0 in Ubuntu. Does anybody know any repository that already has the debian package for Postgres 9.0? Do you think I should wait for the next Ubuntu release or Postgres 9.0 is ...
1
vote
3answers
1k views

When will postgres 9 be supported?

When will Ubuntu support postgres 9?
0
votes
1answer
164 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
0answers
534 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
1answer
203 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 ...
0
votes
2answers
271 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 ...
0
votes
1answer
282 views

postgresql errors when installing anything

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
1answer
1k views

I'm trying to install postgresql on 12.04, and it's just not working

I've got a new installation and I'm trying to get Postgresql working. The database was installed and I started a restoration from a dump on another machine, but that ran into problems because I had ...
1
vote
0answers
755 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 ...