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

learn more… | top users | synonyms

1
vote
1answer
3k 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
25 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
364 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
51 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
259 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
0answers
771 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
127 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
674 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
105 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
291 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... ...
1
vote
1answer
901 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
307 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
134 views

Can't create username for PostgreSQL

After installing rails and trying to install PostgreSQL in the terminal (following these instructions ...
1
vote
1answer
2k 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
1k 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
64 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 ...
8
votes
4answers
10k views

install postgres 9.4 on ubuntu 14.04-2 [duplicate]

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
57 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
1k 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
76 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
136 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 ...
0
votes
1answer
263 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 ...
7
votes
3answers
14k 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
483 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
54 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
1k 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
282 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
50 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
71 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 ...
1
vote
2answers
5k 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
2answers
1k 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
187 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
479 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 ...
1
vote
1answer
2k 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
2k 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
50 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
2k 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: ...
1
vote
2answers
596 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
2k 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
2answers
706 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
1k 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. ...
2
votes
1answer
1k 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: ...
0
votes
1answer
20 views

Why do I have several application maps in usr?

I'm back at ubuntu after a long break. Im trying setting up postgres, pgadmin, apache etc. I've been downloading several version of the aboved mentioned applications. Before downloading new version ...
0
votes
1answer
123 views

How to make postgresql user access file system?

I am trying Postgresql for learning. I installed that from repository. by default user named postgres had created. I want to know that how can I make this user access files in the disk? I tried ...
0
votes
1answer
244 views

Problems executing make USE_PGXS=1 on Ubuntu 14.04(postgresql9.3)

Following guide for Postgresql9.3 on ubuntu I am getting an error executing make USE_PGXS=1 The output is: gcc -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format- security ...
3
votes
1answer
2k views

Pgadmin couldn't connect to PostgreSQL

installed pgadmin3 from ubuntu store Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused Is the server ...
2
votes
2answers
174 views

Which package provides the Postgresql init scipt?

If I haven't got /etc/init.d/postgresql file in what package could I find it?
1
vote
1answer
2k 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 ...
3
votes
3answers
57k 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 ...