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

learn more… | top users | synonyms

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 ...
1
vote
1answer
1k views

Cannot connect to Port 5432

My company has a Linux Database server. I only have one user that needs access to this server. He is using PostgreSQL to access this server. It has been working fine for over a year. Today when he ...
1
vote
1answer
365 views

Attempt start postgres server fails and gives no response?

When I do on my local machine. sudo service postgresql start I usually get the following or some error. * Starting PostgreSQL 9.1 database server [ OK ] But when I ...
1
vote
1answer
151 views

Ubuntu login black screen after postgis install

I just built a new computer running an ASUS P8Z77-V LK motherboard with no graphics card. Can boot into Ubuntu, run a bunch of the usual programs (Chrome, etc) no problem. However, when I install ...
0
votes
1answer
15 views

Postgres pg_hba.conf Configuration

I'm trying to develop a python application using Postgres. Unfortunately everytime I do a db.session.commit() I get this as an error: OperationalError: (OperationalError) fe_sendauth: no password ...
0
votes
1answer
43 views

Postgres changes file permissions to its detriment

Someone, please, please, please explain to me what the hell is going on here, and how I can fix this? I'll let my console do the talking: root@worker2:/var/run# service postgresql start * Starting ...
0
votes
1answer
83 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
74 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
63 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
1answer
206 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
1answer
304 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
1answer
96 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
388 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 ...
0
votes
1answer
53 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
1answer
226 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
48 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
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 ...
3
votes
0answers
818 views

Postgresql 9.3 service unable to start

I have Ubuntu 14.04 machine. I'm trying to turn my server on, but there is no success. It was running months ago, but then I've disabled it on startup. Now I need to run it again. I've tried purging ...
2
votes
0answers
14 views

How to uninstall specific versions of Postgres?

On Ubuntu 14.04 I have done this to get the latest postgres: sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' wget ...
2
votes
0answers
323 views

Postgresql 8.2 service will not stop and uninstall

My system config is as follows: System (running on Amazon EC2) Ubuntu 10.04 Postgresql-8.2 installed and it is working. ubuntu@ip:~$ sudo /etc/init.d/postgresql-8.2 status: Running clusters: ...
1
vote
0answers
277 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
0answers
24 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, ...
1
vote
0answers
89 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) ... ...
1
vote
0answers
48 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 ...
1
vote
0answers
42 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 ...
1
vote
0answers
1k 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
0answers
438 views

Error while upgrading postgres

Ubuntu 14.04. Package manager reported that postgresql was broken. When I tried to upgrade it produced the following error: (synaptic:30668): GLib-CRITICAL **: g_child_watch_add_full: assertion 'pid ...
1
vote
0answers
355 views

PostgreSQL Backup With Barman

I'm trying to backup my server which i created on PostgreSQL (9.1). While on my normal user i type "su barman", it asks me barman's password, i enter the password. On barman's shell i type "barman ...
1
vote
0answers
93 views

Connecting sublime_text3 editor with postgresql

I am new in sublime_text3. I want to connect my sublime_text editor with my system PostgreSQL in ubuntu12.10. I have tried few plugins but its not working. Any one have any idea how to do that?
1
vote
0answers
138 views

Symbolic link error to Java / LIBJVM

All, When trying to install postgresql, I get the following error: /sbin/ldconfig.real: usr/lib/jvm/java-1.7.0-openjdk-amd64/jre/lib/amd64/jamvm/libjvm.so is not a symbolic link I think this is ...
1
vote
0answers
2k views

Postgresql starting error

The postgresql 9.1 database server is not starting. Can anyone help in this. * Restarting PostgreSQL 9.1 database server * Removed stale pid file. The ...
1
vote
0answers
508 views

How to run Python- postgresql in ubuntu 12.04

I am trying to test pyhton-postgresql script in ubuntu 12.04. The script is this: import psycopg2 import sys con = None try: con = psycopg2.connect(database='mydb', ...
0
votes
0answers
26 views

Cannot connect remotely to either MySQL or Postgres

I am trying to connect remotely to the MySQL database on my cloud server which is configured with Ubuntu 14.04.03. However I cannot do so (details below). I can neither connect from a Windows client ...
0
votes
0answers
48 views

Sudo service <argument> stop not working

While looking through the output of service --status-all to find some programs to kill and increase my battery life I ran into a problem. I run sudo service postgresql stop and I get the stopping ...
0
votes
0answers
11 views

Proper Install instruction for installing PostgreSQL on Ubuntu 14.04 LTS

I have followed the instructions on several site to install PostgreSQL on 14.04 however none have been successful. There has been different failures from unmet dependencies to simply not installing at ...
0
votes
0answers
55 views

two postgres have been installed, remove both

I have previously installed postgres 9.1 by How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 14.04 It was installed correctly and my app was working fine, but today its not working ...
0
votes
0answers
20 views

How to use PgAdmin?

I have installed PgAdmin III in my Ubuntu Gnome OS. How can I start using it in order to create a database? What should I give as service while connecting to a server?
0
votes
0answers
32 views

Why is Postgres running even after uninstall? How do I stop it?

I have uninstalled postgres using sudo apt-get --purge remove postgresql a few days back. I have restarted my computer quite a few times since then. But the postgres server seems to be running even ...
0
votes
0answers
141 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
0answers
152 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 ...
0
votes
0answers
37 views

Lost PostgreSQL connections after database package reinstall

I upgraded my home server from 12.04 to 14.04 which came with PostgreSQL 9.3. Unexperienced, I forgot to verify which clusters I was running. I uninstalled 8.4 and 9.1 (Aptitude classified them as ...
0
votes
0answers
44 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
0answers
231 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
0answers
408 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
0answers
73 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
118 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
0answers
49 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
0answers
241 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
0answers
353 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
0answers
244 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 ...