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

learn more… | top users | synonyms

0
votes
1answer
19 views

postgresql installation damaged

I installed postgresql using following command on 25th following instruction on (help.ubuntu.com/community/PostgreSQL) sudo apt-get install postgres postgresql-contrib It was working fine. Then on ...
2
votes
1answer
13 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 ...
0
votes
0answers
7 views

Is there an easy foolproof way to translate commands from Ubuntu to Debian, and vice-versa? [migrated]

If I want to work between Ubuntu and Debian or switch to one or the other, would there be a good way to know what commands will work on both? I have set up Debian with sudo (i.e. by not choosing a ...
1
vote
1answer
3k 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 ...
2
votes
0answers
57 views

Armitage won't start: parse error

I installed Armitage along with Metasploit and Postgresql but Armitage is not connecting. Starting Postgresql works fine sudo service postgresql start * Starting PostgreSQL 9.3 database server ...
4
votes
3answers
18k 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
0answers
24 views

Enable PostGIS extension on Ubuntu 14.04.2

I have troubles enabling PostGIS extension on Ubuntu 14.04.2 and PostgreSQL 9.3. I have installed the packages with this step by step procedure. PostgreSQL and pgAdminIII seem to be installed ...
-1
votes
0answers
33 views

Postgresql server won't listen

I am trying to setup postgresql for metasploit on Ubuntu. The service is running, and I do the following commands to create a user: sudo -s su postgres createuser msf -P -S -R -D After selecting my ...
0
votes
1answer
81 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
41 views

How do I solve a “server version mismatch” with pg_dump when I need BOTH PostgreSQL servers installed?

I installed two PostgreSQL servers in my computer. One is 9.1 and the other is 9.3. I need both servers installed. When I run pg_dump, however, I get a version mismatch error: server version: 9.3.6; ...
3
votes
1answer
4k 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
0answers
64 views

PostgreSQL functions undefined

Update: Have edited my question now after doing some more testing. I am trying to connect to a PostgreSQL server with PHP, but get the following error message: Fatal error: Call to undefined ...
1
vote
0answers
22 views

How do I build a deb that is fully compatible with an offical deb?

I've downloaded the source of postgresql-9.3 by doing: apt-get source postgresql-9.3 Then I've done my alteration to the configuration step and I've successfully built and tested the binaries. Now, ...
0
votes
0answers
20 views

Locale warning from Perl stops Postgres configuring

So I want to set up Postgres on a Microsoft Azure-server running Ubuntu 14.04. I need to make a cluster: user@mysystem:~$ pg_createcluster perl: warning: Setting locale failed. perl: warning: Please ...
0
votes
1answer
26 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 ...
-1
votes
1answer
30 views

Can't start postgres server

I've downloaded postgres and can't start the server. I used following command to install it: sudo apt-get install postgresql-9.4 as described here: http://www.postgresql.org/download/linux/ubuntu/ ...
1
vote
1answer
40 views

postgres fails to uninstall

while trying to uninstall postgresql with sudo apt-get remove postgresql I received the following error message Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
33 views

PostgreSQL User Authorization/Configuration Issues

I've installed postgresql 9.3, but can't get any users authorized. I also can't use initdb or pg_ctl. I can't find pg_hba.conf either.
0
votes
1answer
37 views

Running two PostgreSQL servers in same Ubuntu machine

Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports. We installed PostgreSQL 9.4 in two Ubuntu servers and now we ...
1
vote
0answers
23 views

package remove fail. postgresql-contrib-9.1: subprocess installed pre-removal script returned error exit status 127

Do you want to continue? [Y/n] y (Reading database ... 404522 files and directories currently installed.) Removing postgresql-contrib-9.1 (9.1.15-0ubuntu0.12.04) ... ...
0
votes
1answer
47 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: ...
0
votes
1answer
40 views

Error installing postgresql (subprocess installed post-installation script returned error exit status 64)

I'm getting an error when trying to install postgresql. I'll explain what I've found below, but here's the entire output: sudo apt-get install postgresql postgresql-contrib Reading package lists... ...
0
votes
2answers
56 views

Why don't my php files work on my Apache2 server?

I am trying to get a survey (PHP files) to work on an Apache server. I tried it first with XAMPP, but then got the following error message: Fatal error: Call to undefined function ...
1
vote
1answer
21 views

Can't create username for PostgreSQL

After installing rails and trying to install PostgreSQL in the terminal (following these instructions ...
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
27 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
27 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
67 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
10k 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
101 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
17 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 ...
1
vote
3answers
178 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
11 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
66 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
33 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
39 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
161 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 ...
2
votes
3answers
21k 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
86 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
19k 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
24 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
675 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
389 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
23 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
76 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
31 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
19 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
657 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
430 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 ...