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

learn more… | top users | synonyms

17
votes
2answers
28k 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 ...
0
votes
0answers
9 views

Using “service” to stop Postgresql service doesn't seem to work

I've been using an Ubuntu system for quite some time working on an application (well two applications). The application uses Postgresql 9.1 in production, so that's what I use, but 9.3 and 9.4 are ...
0
votes
1answer
14 views

Stopping a postgresql instance

For the sake of educational purposes I have two identical instances of postgresql running on my machine. I can easily stop the service of the instance that is running on port 5432 like this : sudo ...
1
vote
1answer
19 views

how to install pgbench?

I have postgreSQL 9.1 installed in my system. I want to run pgbench but the program is not istalled. I tried these but failed: apt-get install postgresql91-contrib no packet found apt-get install ...
4
votes
2answers
9k 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?
0
votes
0answers
12 views

Psycopg2 can't commit to a local database [on hold]

I've got a postgresql database on my local machine. I'm trying to write a python script, for use on many machines, that will query system information and then store it to a database, called ...
1
vote
1answer
79 views

PostgreSQL 9.4 hangs during installation at “Removing obsolete dictionary files:”

Good day. I am trying to install PostgreSQL on an Ubuntu server (15.04) 64 bit. I checked/updated the sources.list and ran: # apt-get update followed by: # apt-get install postgresql The ...
0
votes
1answer
8 views

Problem occuring while executing this command sudo apt-get install postgresql postgresql-contrib

E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it? How to resolve this ...
0
votes
3answers
42 views

install postgres 9.4 on ubuntu 14.04-2

I need to install postgresql 9.4 server but I only can find version 9.3. wit apt. How can I install or upgrade it?
1
vote
0answers
7 views

Postgres server start fails - WANTED: netstat -ant|grep 5432 output explanation

INFO: I'm working on a Ruby on Rails app. Hosting on Heroku with postgres. Tried running "heroku run rake db:migrate" as usual, but getting error "cannot connect,... check if something else is already ...
0
votes
1answer
37 views

How can I slove postgresql-9.3-postgis-2.1 unmet dependencies Ubuntu 14.04

I've installed PostgreSQL v9.3 (database) on Ubuntu 14.04 and I'm currently attempting to install the following: sudo apt-get install postgresql-9.3-postgis-2.1 However I'm getting the following ...
0
votes
1answer
39 views

Postgresql server not started in ubuntu 14.04

My problem is after postgresql installed try to configure postgresql database it's show error message like below: dineshlap@ss-laptop:~$ sudo -u postgres psql postgres psql: could not connect to ...
0
votes
0answers
17 views

Adding new Service to boot record doesn't work

I want to add postgresql as a new service to my boot records, which I normally do by doing this: sudo update-rc.d postgresql defaults However, when I then restart it still doesn't start at boot. ...
0
votes
0answers
21 views

Two factor authentication with password and USB Device for PostgreSQL server

I'm going to setup 2 factor authentication for my database server. I'm using PostgreSQL 9.4 DBMS on Ubuntu 14.10. I need to force two authentication methods for my database server. The authentication ...
1
vote
2answers
41 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 ...
1
vote
3answers
18k 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 ...
0
votes
1answer
66 views

How to hide / remove “postgres” user in Ubuntu 14.04?

I recently installed postgresql. (I know very little about it, but may try it out at some point.) I noticed that a user named postgres (which I do not recall creating manually) is now listed both on ...
4
votes
5answers
18k views

Can't uninstall postgresql package due failing to start service?

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

postgresql broken after 14.04 despite succesful pg_upgrade

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
0answers
20 views

find all references to program installed from source

Had I installed postgresql from the repositories, I could find all the files it installed on my system using: dpkg-query -L postgresql dpkg -l | grep postgres However, I installed it from source, ...
0
votes
1answer
646 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 ...
0
votes
1answer
380 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
0answers
21 views

Import OpenStreetMaps data fails

I work in project of geocoding. So i want to import the OpenStreetMaps Data. I created a database and name it nominatim and i tried this command: sudo ./utils/setup.php --osm-file ...
0
votes
0answers
52 views

Permission denied trying to setup postgres sql

I'm trying to setup Dspace for a uni job here, but this Protgres SQL is asking for a password (For the postgres user) but it's supposed to be indent, I have no idea what's going on. So, When I try to ...
0
votes
2answers
27 views

How do I keep track of directories being created during installation of PostgreSQL?

I want to install PostgreSQL (on a server that runs Ubuntu 14.04.2 LTS) using the source code distribution as per instructions in http://www.postgresql.org/docs/current/static/installation.html. The ...
0
votes
1answer
13 views

postgresql 9.3: can't connect with password

Created a user testdb1. Issued: postgres=# alter user testdb1 with password 'testdb1'; ALTER ROLE postgres=# Then added an entry to pg_hba.conf: local all testdb1 password ...
0
votes
1answer
259 views

Problems installing postgresql-9.4: Unable to locate package

I'm using Ubuntu 14.04. I'm trying to download postgresql using this guide. But when I run the command sudo apt-get install postgresql-9.4 in my terminal, I get this error message: E: Unable to ...
0
votes
1answer
281 views

Installing PostGIS on Ubuntu 15.04

When executing this command sudo apt-get install postgresql-9.4-postgis2.1 pgadmin3 to install PostgreSQL with PostGIS I get the following error: postgresql-9.4-postgis-2.1 : Depends: libgdal1 ...
0
votes
1answer
141 views

Unmet dependency while installing PostgreSQL on Ubuntu 15.04

I am trying to install Postgresql on my brand new Ubuntu 15.04 installation and run into this error: The following packages have unmet dependencies: libpq-dev : Depends: libpq5 (= 9.4.1-1.pgdg12.4+1) ...
2
votes
1answer
62 views

apt-get install pgpool2 fails on trusty

I am trying to install pgpool2 on trusty, but when using apt-get to do so it fails, like so: # uname -a Linux vagrant-ubuntu-trusty-64 3.13.0-51-generic #84-Ubuntu SMP Wed Apr 15 12:08:34 UTC 2015 ...
0
votes
1answer
33 views

default location of postgresql when installing through apt-get

When you install postgresql on 14.04, it sticks the main server program postgres at: /usr/lib/postgresql/9.3/bin/postgres the data directory where all the database clusters will be stored at: ...
0
votes
1answer
797 views

Ubuntu 15.04 PostgreSQL verions differ

I recently upgraded to Ubuntu 15.04 on Friday and was having trouble with my OpenStreetMap tile server. Upon further investigation I found that Ubuntu runs mismatched server and client versions, which ...
17
votes
5answers
77k 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 ...
2
votes
2answers
325 views

ubuntu machine had postgresql folder blown away manually - can't install or remove any packages

i have a machine where a user deleted their postgresql folder from the command line in an attempt to uninstall postgres. now when we try to install any other packages - even unrelated ones - we keep ...
0
votes
0answers
33 views

Big Challenge! Need Help installing an Open-source Software [duplicate]

Hi Ubuntu Community, I am new here and I need a helping hand. I am learning to use an open-source software, but I am having trouble installing it in Ubuntu 14.04 64-bit. The Open Foris Plataform ...
1
vote
1answer
292 views

pgAdmin show object browser text white on white with dark theme

When using a dark theme, the object browser uses white background. Is there some way to change this? This question has been asked a few times, but no answer still. The theme I am using is E17. ...
0
votes
1answer
116 views

PostgreSQL start.conf not working

I've just upgraded to 14.10 from 14.04. I have both 9.3 and 9.4 versions of PostgreSQL installed but, for now and until i fully migrate to 9.4, i just want to start the 9.3 cluster. I edited the ...
1
vote
0answers
114 views

PostgreSQL won't set up correctly

I just got a new VPS running Ubuntu 14.04 which I want to use as PostgreSQL server. I followed this guide but for some reason it won't work as described: ...
0
votes
0answers
113 views

Socorro - django.db.utils.OperationalError: unable to open database file

I am trying to install Socorro on fresh Ubuntu 10.04 (Amazon EC2). I am following this manual and I am on the step 6.2.8, and I am having a problem with following command: ./manage.py syncdb ...
0
votes
2answers
384 views

After upgrade to 10.10, mediawiki on postgres is broken

I upgraded to Ubuntu 10.10 from 10.04. 90% of the upgrade was ok but my Ubuntu-apache2-postgres-8.4 - mediawiki1.16 does not work anymore. Is there a bug in the postgres client or in php5 pg?
0
votes
1answer
135 views

Had to upgrade Postgres on Ubuntu; now, how to access old, missing databases?

My local connection on my Ubuntu server (14.04) wasn't working to my Postgres (9.3) database, so I tried upgrading it to 9.4 to solve the connection issues. Luckily I can now connect to the database, ...
1
vote
1answer
585 views

High CPU usage in the processes related to postgres in ubuntu 12.04

My Ubuntu server 12.04 hangs quite oftenly (say once in a day), after hard reboot it starts running normally. The server is Intel Xeon having 2 CPUs with 8GB RAM.There is high CPU usage in the ...
0
votes
0answers
81 views

Connect with postgresql remotely. Postgresql Installed in Amazon EC2 micro instance

I installed the Amazon EC an instance Ubuntu 14.04 and Postgresql database. Trying to connect remotely to the base and the pgAdmin III program but can not connect. I've tried many of the solutions ...
1
vote
1answer
2k views

Command pg_dump not found?

I was going to make a backup in a server and I got the error: pg_dump command not found I thought that if you had postgres installed, it worked. What I have to do to "install" it? Because I do not ...
3
votes
1answer
2k views

Postgis + could not access file “$libdir/postgis-2.1”: No such file or directory

I am running postgresql9.3 and postgis2.1 , it works fine. When i installed QGIS by using the following commands: sudo apt-get update sudo apt-get install qgis After installing QGIS the postGis is ...
2
votes
2answers
1k 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. ...
12
votes
1answer
4k 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 ...
0
votes
2answers
119 views

Trouble to delete PostgreSQL-User

How can I delete the User PostgreSQL? "It says User could not be deleted running '/usr/sbin/userdel' failed: Child process exited with code 16" postgres 2105 1 0 12:23 ? 00:00:00 ...
0
votes
1answer
554 views

Installing PG database on ubuntu

I am trying to install PG on my ubuntu system but I can't get past this error for sudo apt-get install postgresql-9.1 : Package postgresql-9.1 is not available, but is referred to by another package. ...
1
vote
1answer
323 views

how to log in to specific postgresql version

I have multiple versions of postgresql installed on my ubuntu box. 9.3 is for real stuff. I just installed 9.4 to do some tests with replication. Here's why I think I have two versions running: ...