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

learn more… | top users | synonyms

1
vote
1answer
93 views

Extending postgresql code

In postgresql source code there is a file called postgres.c precisely in /src/backend/tcop/. Inside there is a function called exec_simple_query. I want add a line that call my_function that is in ...
8
votes
3answers
33k views

How do I find the path to pg_hba.conf from the shell?

I would like to obtain the path to pg_hba.conf from the shell. The path varies between versions of PostgreSQL. For instance, for 8.4 and 9.1: /etc/postgresql/8.4/main/pg_hba.conf ...
0
votes
1answer
1k views

Installing PostgreSQL 9.x on Ubuntu 11.04

I tried following the direction from various websites: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgresql Unfortunately, it still wants to install 8.4. ...
0
votes
1answer
816 views

Can't update or remove PostgreSQL 9.1

The last update of PostgreSQL 9.1.7 seems to break my APT. When I try to update, I get the following error: Reading package lists... Done Building dependency tree Reading state information... ...
0
votes
1answer
424 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? # ...
5
votes
1answer
2k views

Postgres-xc won't uninstall (Fails on Stopping Co-ordinators)

I was doing some rails development and accidentally installed postres-xc instead of the normal postgres package. I immediately went to remove postgres-xc, but apt-get will not uninstall it. I also ...
5
votes
2answers
3k 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 ...
4
votes
2answers
343 views

Why is there a shell given to user for PostgreSQL?

cat /etc/passwd |grep postgre postgres:x:115:127:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash apt-cache show postgresql Package: postgresql Priority: optional Section: database ...
2
votes
3answers
1k views

Unmet dependencies. Try using -f

I'm running into the following error when I'm installing any package on 12.04. Reading package lists... Done Building dependency tree Reading state information... Done You might want to run ...
1
vote
1answer
120 views

I did not install postgresql, so why do I have postgresql related binaries in 12.04?

I am going to compile postgresql from source, but the system already has postgresql related binaries such as pg_config, which gives me a lot of environment variables etc when I run it. I did not ...
0
votes
3answers
406 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 ...
2
votes
0answers
215 views

Postgresql 8.2 service will not stop and uninstall

My system config is as follows: System (running on Amazon EC2) Ubuntu 10.04 Postgresql-8.2 installed and it is working. ubuntu@ip:~$ sudo /etc/init.d/postgresql-8.2 status: Running clusters: ...
2
votes
1answer
175 views

Remove a previously deselected package to install postgres?

So I was meant to run add-apt-repository ppa:pitti/postgresql apt-get update apt-get install postgresql libpq-dev but instead I ran without the previous two commands apt-get install postgresql ...
6
votes
3answers
2k views

How to manually restart services affected by apt upgrades?

How can I issue apt upgrades without automatically stopping/starting daemons? I'd like to manually restart services. To cite a specific example: I'll revisit a long-running machine and run sudo ...
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: ...
0
votes
3answers
877 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
1answer
68 views

Locating Postgres database

I am working on this new ubuntu 12.04 server and I need to work on the Postgres database which is PostGIS enabled. The problem is I am not sure how to locate the database using command line. It is ...
3
votes
1answer
61 views

juju override defaults in service

Working on the postgresql charm a bit, and I'm wondering if there is a way to supply overrides for default values in a "juju-way". In my charm that will be consuming the services provided by ...
3
votes
3answers
17k views

How do I install pgAdmin III for postgreSQL 9.2?

I have a Windows server that runs postgresql 9.2. I want to hit it using pgAdmin III from my Ubuntu 12.10 workstation box. I installed pgAdmin III from synaptic and also tried direct download from ...
0
votes
3answers
480 views

apt-get no longer works after manually deleting folders of a previously installed application

I have been struggling all weekend, to upgrade an existing postgresql database from version 8.4 to 9.1. I have (had) both versions of databases after I updated my OS from 10.0.4 to 12.04. I finally ...
0
votes
1answer
2k 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
731 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
198 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 ...
1
vote
2answers
53 views

Regarding inbuilt application PostGreSQL

In my work I need to study about FOSSology. This tool supports only in Linux. So i have installed Ubuntu version 12.10 Quantal. Through net i have come to know Ubuntu has inbuilt postgreSQL ...
0
votes
1answer
21 views

What packages do I need to install in order to bulld postgres from source?

I need to be able to build postgres-8.4.2 from source. What dependencies should I install?
1
vote
1answer
1k views

Postgresql fails to start on Ubuntu 10.04.4 LTS

I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2 At the end of the install and every time I try to launch postgresql by using the following ...
4
votes
2answers
1k views

pgadmin III doesn't work due to “The server lacks instrumentation functions.”

When pgAdmin III is used to open a PostgreSQL database the following message appears. There does not seem to be any obvious package listed in the Ubuntu Software Center for this. The server lacks ...
4
votes
2answers
3k views

How to uninstall PostgreSQL installed from .run file?

I am a new Ubuntu 12.04 user and I'm using 64bit. This morning I installed Posgresql 9.2 from the graphical installer (not from Ubuntu repository) . Now I want to uninstall it, but I don't know how. ...
5
votes
2answers
7k views

Where is a postgresql 9.1 database stored in ubuntu 12.04?

I installed and created a Postgresql database on ubuntu. I then created the database using the following command: sudo su postgres createdb mydatabase However, I can't figure out where the database ...
17
votes
3answers
29k 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 ...
7
votes
2answers
4k 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 ...
1
vote
0answers
426 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
1answer
3k views

Script to establish SSH tunnel and then run another program that uses the tunnel

I am running a GUI app (Gnucash) that connects to a remote Postgres database via a secure shell session. I can use the SSH -L command to tunnel a local port and then separately run Gnucash and this ...
1
vote
2answers
10k views

How to uninstall Postgresql properly?

I have messed around with the template1 database, and would like to reset everything as it was. Hence I have done a sudo apt-get purge postgresql However the next time I reinstalled it, the ...
0
votes
1answer
2k views

Deleted files not increasing available free space as reported by df -h

I am writing data munging scripts (python and bash), to munge data and import large quantities of text files into a database. I am currently in the test phase, so I am generating several K's of files ...
2
votes
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
1answer
582 views

Package candidate/alternative for the python-pgsql package in 11.10

What is the package candidate or alternative for the python-pgsql (module) package in Ubuntu 11.10 ? An error indicator that could help: Error: You need to have the python-pgsql module installed to ...
1
vote
1answer
508 views

How do I start the postgreSQL service upon boot?

I am running PostgreSQL (v 8.4) on Ubuntu 10.0.4. The PG service currently starts on reboot (after I installed PG on my machine), however, I want the service to use a new data directory. ...
0
votes
1answer
1k views

apt-get -f install gives error

When I run apt-get -f install, it gives the following error: # apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting ...
2
votes
2answers
6k views

How do I install older PostgreSQL (8.4) in Ubuntu 12.04?

Well, it's the whole question. I installed 9.1 before, but I need older version now and I haven't yet found out how to do that.
5
votes
1answer
627 views

Why isn't the new “postgres” user I created showing up in User Accounts?

I just did a fresh install of Ubuntu 12.04 on a Dell Inspiron 1545, then downloaded & installed all the latest updates. Now when I create a new user postgres in the "User Accounts..." window, it ...
2
votes
1answer
4k views

Run a PostgreSQL instance locally

I'm trying to follow this tutorial, but at the beginning it says to run a postgresql instance "locally" instead of as a daemon using the following commands. $ initdb pg $ postgres -D pg & $ ...
1
vote
2answers
789 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 ...
0
votes
2answers
873 views

How to Install PostgreSQL 8.4 on 8.04?

How can I install Postgresql 8.4 for Ubuntu Hardy 8.04 ? sudo apt-get install postgresql will install postgreSQL 8.3 I tried installing individual packages from ...
6
votes
1answer
2k views

How do i install postgresql-8.3?

I get > sudo apt-get install postgresql-8.3 Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql-8.3 is not available, but is referred ...
7
votes
2answers
9k 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 ...
9
votes
6answers
7k views

What is the difference between “service restart” and “service reload”

I'm trying to understand the difference between service restart [someservice] and service reload [someservice]. I understand that "restart" restarts the service whereas "reload" reloads the ...
2
votes
1answer
4k views

Packages having unmet dependencies: Broken Packages

When I try to install postgresql i get the following error: sudo apt-get install postgresql-client Some packages could not be installed. This may mean that you have requested an impossible ...
1
vote
1answer
641 views

Does libpg-java support passwordless login? [closed]

The following command runs fine, that is, doesn't ask for a password, prints no warnings or errors, and simply provides a DB prompt: $ psql -U dbuser dbname psql (8.4.10) Type "help" for help. ...
1
vote
1answer
858 views

How do I install Davical?

i'm using ubuntu 11.4 oneiric ocelot and tried to set up the Davical Server. I have installed it and added the users davical_app and davical_dba. A tutorial on ...