Tagged Questions

0
votes
1answer
65 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 ...
0
votes
1answer
65 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
2answers
49 views

How do I downgrade PostgreSQLl?

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
0answers
42 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
1answer
96 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 ...
2
votes
1answer
106 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 ...
0
votes
1answer
220 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
54 views

Attempting to re-install postgres fails due to rabbitmq

On 12.04, when I do apt-get install on postgresql (which is already installed), it returns an error that mentions rabbitmq-server. What are the circumstances that could cause this type of failure? # ...
4
votes
2answers
995 views

apt-get upgrade stuck on postgresql dependency

I ran sudo apt-get upgrade on my 12.04 server, and I have become stuck with a PostgreSQL dependency. The console output (of sudo apt-get -f install) is below: dpkg: dependency problems prevent ...
0
votes
3answers
255 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
1answer
377 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: ...
0
votes
1answer
230 views

How to make psql to default to localhost?

I have the following scenario: saji@geeklap:~$ psql -U postgres psql: FATAL: Ident authentication failed for user "postgres" saji@geeklap:~$ psql -h localhost -U postgres Password for user ...
0
votes
1answer
289 views

pgAgent installation in PostgreSQL

I have installed PostgreSQL 9.1 on ubuntu 12.04 64-bit. I try to run Aplication Stack Builder and install pgAgent. At first I am asked for root password, which I provide, after I choose PostgreSQL ...
1
vote
1answer
104 views

postgreSQL installation from graphical installed

I tried to install postgreSQL on ubuntu 12.04 64-bit. I have version pgsql9.1 on my windows machine and wanted to make both installation the same with the same components. I downloaded ...
0
votes
0answers
463 views

Problems in installing postgresql-9.1 in 12.04

I have installed postgresql via apt-get install postgresql, but have an error, don't make the folder /etc/postgresql/9.1. The error on psql: psql: could not connect to server: No such file or ...
1
vote
0answers
257 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: ...
1
vote
2answers
456 views

Creating symlink for Postgres

As a developer, I often ssh right into my local database, just to test my application before pushing my code. However, I find that every time I want to access Postgres, I have to type in ...