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

learn more… | top users | synonyms

1
vote
2answers
2k 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: http://...
18
votes
7answers
37k 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 ...
13
votes
5answers
20k 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 ...
5
votes
4answers
69k views

The following packages have unmet dependencies!

I am writing this because I am very confused about installing postgresql 9.3 on mine Ubuntu 14.04. First I need it for mine Python/Django development, and I ran in to the problem, when i tried to ...
9
votes
2answers
5k views

What is the easiest way to install PostGIS?

What is the easiest way to install postgis on Ubuntu Server 11.10? apt-get install ...
0
votes
1answer
59 views

Which is the proper way to install postgresql [14.04]

Recently I have been trying to install a postgres server instance on 14.04 but I've run into the issue of not knowing which install I need/want. here are the different ones I've found https://help....
27
votes
3answers
27k views

How do I migrate my postgres data from 8.4 to 9.1?

I have upgraded my ubuntu development machine from 11.04 to 11.10. In the process my postgres was also upgraded from 8.4 to 9.1. But I seem to have lost all my data. If I look, I can see that my data ...
15
votes
1answer
7k views

How do I set which PostgreSQL version is to be used by default?

I have 2 different versions of PostgreSQL installed on my system (Ubuntu Lucid): /var/lib/postgresql/8.4 /var/lib/postgresql/9.0 By default, when I run a PostgreSQL command such as createdb or ...
7
votes
1answer
4k 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 ...
7
votes
3answers
32k 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
1k views

PgAdmin 3 @ Ubuntu 14.10: low responsiveness when typing

I've been using PostgreSQL and PgAdmin 3 for years without problems so far. Recently I installed Ubuntu 14.10 at new notebook with PgAdmin. The problem is that I have to type very slowly to get the ...
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 ...
6
votes
3answers
6k 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 apt-...
9
votes
3answers
20k views

How install postgresql 9.4

After trying apt-get install postgresql-9.4, updating, trying again etc etc. It seems I can't install it: Couldn't find any package by regex 'postgresql-9.4' I know there is a similar question in ...
3
votes
2answers
10k views

How can I update pgadmin3 to v1.14?

I installed Ubuntu 11.10 yesterday. From the repos I installed postgresql and pgadmin3. postgresql 9.1 is the current version but it seems pgadmin3 v1.12 is not properly compatible with 9.1. How can ...
2
votes
2answers
2k views

How to install older version on PostgreSQL and PHP5?

Because of differencies in package versions between my development machine and my provider's server, I have to downgrade packages installed on my computer. In Ubuntu 10.04 LTS default PostgreSQL ...
2
votes
1answer
876 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 ...
1
vote
1answer
3k 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
270 views

installing Ubuntu Openstack - Canonical Distribution on a virtual environment

I've tried to install Ubuntu Openstack - Canonical Distribution using this new Ubuntu guide. During step 3, i use the following command to install MaaS; sudo apt install maas I've received this ...
1
vote
1answer
1k views

Problems using PostgreSQL with XAMPP

I seem to have trouble getting PostgreSQL to work on XAMPP (using Lubuntu 14.02). I am new to working with both PHP, servers and databases, but I get the following error message. Fatal error: ...
1
vote
2answers
7k 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 ...
15
votes
3answers
73k 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 ...
6
votes
3answers
11k views

pgadmin3: Unable to initialize gtk, is DISPLAY set properly? [closed]

I'm having some trouble getting pgadmin3 to run on a remote server. I'm logging in to the server using SSH with the -X option. When I first installed pgadmin3, I was able to launch it using the ...
4
votes
2answers
4k views

How do I downgrade PostgreSQL?

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?
4
votes
2answers
4k 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. ...
2
votes
1answer
236 views

not able to uninstall postsql-xc

Postgressql installation was broken once I installed postgres-xc and postgres-xc-client. I tried uninstalling but not able to do it. The log of activities follows: postgres@ashUbuntu:~$ sudo apt-get ...
2
votes
1answer
749 views

How do i configure postgis

PostGIS has been installed on ubuntu server 11.10... Now how do i create a database, admin user, etc.. where does it get installed ls -l /etc/...?
2
votes
2answers
14k 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.
1
vote
2answers
1k views

Unable to install PostgreSQL

I am trying to install postgresql on Ubuntu. I tried installing it using the following command: apt-get install postgresql Which results in Reading package lists... Done Building dependency tree ...
1
vote
1answer
232 views

Pgadmin3 not working on ubuntu 15.10

I installed postgres than pgadmin3 on ubuntu 15.10. install was successful but when I type pgadmin3 in terminal and hit enter I get this following error : Fatal Error: Mismatch between the program ...