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

learn more… | top users | synonyms

0
votes
1answer
418 views

Unable to remove pgadmin3 version 1.18 from Ubuntu 14.04

I am running Ubuntu 14.04 and have pgadmin3 version 1.18.1, PostgreSQL 9.4 installed. I am new to pgadmin3. I want to upgrade to pgadmin3 1.20.0. So I used sudo apt-get update sudo apt-get install ...
0
votes
1answer
81 views

Double Quotes inside Double Quotes problem for postgres sensitive database name priviliges

Having a database with case sensitive name like MyDb, if I want to use psql to grant all privileges on this database to the user 'user' I can just write: GRANT ALL PRIVILEGES ON DATABASE "MyDb" TO ...
0
votes
1answer
405 views

Can't to log in postgres account by pgAdmin

Before I changed my forgotten postgres pass using 'su - root' in command line. Then I try to connect server using pgAdmin and I get error: Error connecting to the server: FATAL: password ...
0
votes
1answer
110 views

Database / systemctl issues after switch to 15.04

I recently updated Ubuntu to 15.04. Since then, I've been having issues starting and stopping postgres and mongodb, which also affects apt-get when it tries to install or uninstall them. Here's the ...
0
votes
0answers
223 views

Installing Foreman Fails

For some reason I can't setup Foreman, after being so simple it keeps failing. It happens after I run the $ foreman-installer Everything looks great and then these two errors show up: Execution ...
0
votes
1answer
85 views

Is it possible to 'export' an installed package

I need to install a software that runs only on Ubuntu 10.04. This software uses Postgres 9.0 client, which depends on libpq5 version 9.2.4-0ppa1~lucid Version 9.2.4 is no more available on PPAs. ...
1
vote
0answers
653 views

ERROR: could not access file “$libdir/plpython2”: No such file or directory

I am running postgresql 9.4 ("PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14), 64-bit" ) when I am trying to create language in postgres SQL : ...
1
vote
1answer
213 views

Can't run PSQL scripts from terminal

I can't seem to run PSQL script files from my Ubuntu terminal. Specifically, when I run ./populate_ppima_db.sh melon melon I get the following output: Insert Basic Data psql: FATAL: Peer ...
0
votes
1answer
501 views

how to fix Error: Port conflict: another instance is already running

I fired two command sudo apt-get update sudo apt-get upgrade It will give me error after upgrade(after press "Y") Setting up postgresql-9.1 (9.1.19-0ubuntu0.12.04) ... * Starting ...
0
votes
0answers
261 views

PostgreSQL move data directory to home folder

i have a problem with the moving of my data directory of postgresql. I found many different ways, but none worked. The most sensible way for me was: stop postgresql copy data from old folder to new ...
4
votes
1answer
383 views

Using Expect in Bash to set the inital “postgres” user password?

Following the tutorial here: http://www.unixmen.com/install-postgresql-9-4-phppgadmin-ubuntu-14-10/ I am scripting the installation of PostgreSQL in bash but having a problem when it comes to setting ...
0
votes
2answers
877 views

Postgres 9.4 running but “service status” reports it down

Ubuntu 14.04.3 LTS and a new installation of Postgres 9.4 (with apt-get install postgresql-9.4, nothing fancy). Postgres was started with pg_ctl start by the postgres user. The status command reports ...
1
vote
1answer
4k views

can not install libpq-dev in ubuntu 14.04

I can not install libpq-dev for postgresql, i tried sudo apt-get install libpq-dev and output Building dependency tree Reading state information... Done Some packages could not be installed....
0
votes
0answers
86 views

How to access PostgresSQL by Windows ODBC

I just installed odoo by standart GIT (incl. postgresSQL).It's only command-line OS. Now I need to connect with MS-Access by ODBC to the database. How do I need to configure Ubuntu 14.04 and ...
0
votes
1answer
361 views

Couldn't Excute command line PostGIS pgsql2shp

I am using postgres 9.3 with postgis 2.1 on Ubuntu 14. When I tried to dump pgsql table using pgsql2shp, I get the following error. Error: pg_wrapper: pgsql2shp was not found in /usr/lib/postgresql/...
1
vote
1answer
219 views

Don't create default cluster in postgresql

How do I prevent postgresql-9.4 from creating default cluster (main)? I have Ubuntu 14.04, use aptitude and postresql official repository. I'm using ansible to control multiple servers and want to ...
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 ...
0
votes
1answer
762 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
2k 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 ...
3
votes
2answers
2k 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 ...
2
votes
1answer
5k 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
26 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
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....
1
vote
1answer
371 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
1k 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
144 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
992 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
116 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) ... /var/lib/dpkg/info/postgresql-...
0
votes
1answer
311 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
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: ...
0
votes
2answers
353 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 pg_escape_string(...
1
vote
1answer
173 views

Can't create username for PostgreSQL

After installing rails and trying to install PostgreSQL in the terminal (following these instructions https://www.digitalocean.com/community/tutorials/how-to-use-postgresql-with-your-ruby-on-rails-...
2
votes
1answer
4k 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
2k 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
67 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 ...
9
votes
4answers
14k 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
59 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
2k 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
311 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 ...
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 ...
0
votes
1answer
591 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
1answer
4k 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
2answers
56 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
90 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 (...
2
votes
2answers
7k 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
218 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
619 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 ...
2
votes
1answer
4k 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: /var/...
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 ...