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

learn more… | top users | synonyms

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
1answer
20 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 ...
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 ...
2
votes
0answers
63 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 ...
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
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; ...
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
21 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
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 ...
-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/ ...
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 ...
0
votes
1answer
35 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
24 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
41 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
1answer
48 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
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 ...
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
69 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 ...
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
181 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
82 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
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
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 ...
1
vote
2answers
170 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 ...
0
votes
1answer
88 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 ...
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
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
77 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
670 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 ...
0
votes
1answer
146 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
100 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
52 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
1k 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 ...
1
vote
0answers
24 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
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
0answers
211 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
135 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
1answer
246 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, ...
3
votes
2answers
451 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
134 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 ...