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

learn more… | top users | synonyms

2
votes
2answers
675 views

I'm unable to remove postgresql 9.3 after installing it

I installed Postgresql 9.3 for Ubuntu 14.04 trusty using this command: sudo apt-get install postgresql-client-9.3 libpq-dev I wanted to remove postgresql and instead install 9.2 so I ran this ...
1
vote
2answers
2k views

Does postgresql (server) setup a main cluster after installation? (14.04)

I'm surprised that installing postgresql on ubuntu doesn't give me a working postgres server setup immediately: it requires additional steps: Setting up postgresql-common (154) ... * No PostgreSQL ...
1
vote
2answers
411 views

Trying to install postgresql:i386 on 12.04 amd64

Due to some legacy 32 bit libraries being used in postgresql functions I need to get a 32 bit install of Postgresql on a 64 bit native system. But it seems like there is a problem with the multiarch ...
2
votes
1answer
2k views

Postgis + could not access file “$libdir/postgis-2.1”: No such file or directory

I am running postgresql9.3 and postgis2.1 , it works fine. When i installed QGIS by using the following commands: sudo apt-get update sudo apt-get install qgis After installing QGIS the postGis is ...
2
votes
1answer
612 views

Is there syntax highlighting for psql?

Is there some setting or package that I could use to give syntax highlighting to psql (the PostgreSQL shell)?
1
vote
1answer
412 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
194 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
127 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

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, ...
0
votes
1answer
32 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
31 views

PostgresSQL - How to connect to local machine

I installed Postgres to try it and I would like to use my laptop as server. I clicked on 'Add a connection to a server' and the form 'New Server Registration' opens but I don't know how to fill it ...
0
votes
1answer
95 views

12.04LTS -> 14.04LTS; Dist-upgrade failed; postrgesql; removal blacklist

I'm trying to upgrade a server from 12.04LTS to 14.04LTS, but it consistently fails with: The package ... is in the removal blacklist. This can be caused by: * Upgrading to a pre-release version ...
0
votes
1answer
41 views

how to hiding Ubuntu and postgreSQL versions?

I'm seeking to closing some vulnerabilities of my postgreSQL server that is running over ubuntu 12.04 server, some of these vulnerabilities is an ability of scanners to checking versions of my OS and ...
0
votes
1answer
2k views

install and load uuid-ossp on PostgreSQL

How can I install uuid-ossp extension on PostgreSQL 9.3? Is it using apt-get install? I did select * from pg_available_extensions; but I found no extensions that relates to uuid-ossp.
0
votes
1answer
390 views

Removing old postgresql after upgrading?

I upgraded my postgresql to 9.3 following the instruction found here When I run sudo service postgresql start it shows * Starting PostgreSQL 9.1 database server ...done. * Starting ...
0
votes
1answer
509 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
560 views

Ubuntu 12.04 Depends: postgresql-9.1-postgis

I am installing LocalWiki on a Virtual Machine hosted by 1&1.com It is Ubuntu 12.04. When I run sudo apt-get install localwiki as instructed by http://localwiki.org/install/, I get the following ...
0
votes
1answer
1k views

Installing PostgreSQL 9.x on Ubuntu 11.04

I tried following the direction from various websites: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgresql Unfortunately, it still wants to install 8.4. ...
2
votes
0answers
273 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
24 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
219 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 ...
1
vote
0answers
339 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
168 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
63 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
113 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
1k 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
415 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
29 views

Big Challenge! Need Help installing an Open-source Software

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 ...
0
votes
0answers
25 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
15 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 ...
0
votes
0answers
116 views

Accessing Virtual Mailboxes using Postifx, Dovecot, and Postgresql Ubuntu 12.04

Ok, so I'm running a server distro of Ubuntu, I think it's 12.04 (I know it's 12, forgot the subversion) with postfix as SMTP, dovecat for IMAP, and postgresql for my virtual mailbox databases. I ...
0
votes
0answers
35 views

Postgresql Error in oR

I am trying to run bundle install and i get this error Gem::Ext::BuildError: ERROR: Failed to build gem native extension. /home/aditya/.rvm/rubies/ruby-2.1.3/bin/ruby extconf.rb ...
0
votes
0answers
58 views

postgresql 9.3 broken after multiple reinstallations

I would like to remove postgresql 9.3 from my Kubuntu 14.04 system, so that I may do a clean reinstall. I think I installed the version that ships with Kubuntu, but I'm not sure because I installed, ...
0
votes
0answers
45 views

Administrator User Issues with Postgresql 9.3, Can't Uninstall

I've read every other related question available here. None of them are having the same problem or provide solutions. I need to uninstall Postgres. When I go to the var/lib directory to edit the ...
0
votes
0answers
413 views

psql: could not connect to server: Connection refused

I installed postgre 9.3 on my Ubuntu 14.04 and I get an error like this psql: could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting ...
0
votes
0answers
192 views

Why I get PG::ConnectionBad?

When I visit my local server http://lvh.me:3000/ I get this error: could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP ...
0
votes
0answers
112 views

file pg_archivecleanup doesn't exist in postgres

I am trying to get log shipping replication working with postgresql 9.3 on Ubuntu 13.04 (Raring Ringtail). I installed postgresql on master and slave by doing: apt-get install postgresql I believe ...
0
votes
0answers
159 views

Password authentication failed for user bucardo

So basically when I tried to proceed with my Bucardo installation (using bucardo_ctl install) with these settings: Current connection settings: 1. Host: localhost 2. Port: 5432 ...
0
votes
0answers
171 views

Unable to proceed with Bucardo installation

I'm recently installing Bucardo to work with PostgreSQL. I had trouble installing Bucardo and the relevant libraries from packages, so I installed them through apt-get instead. My problem is that ...
0
votes
0answers
352 views

PGAdmin 3 - server closed the connection unexpectedly

I have installed PostgreSQL and PGAdmin3 for the first time as specified here. When I try to connect to database using PGAdmin it throws Error connecting to the server: server closed the connection ...
0
votes
0answers
72 views

Postgresql Slony error storenode

I had installed Ubuntu 14.04 with PostgreSQL 9.3 server and Slony for database replication and pgadmin3 as gui, all installed from ubuntu ppa. When I try to add "test" slony-i cluster I have following ...
0
votes
0answers
1k views

Ubuntu 14.01 Server + PostgreSQL Install + Configuration

This might be a simple or complicated question, but I recently installed Open-xchange using the guide here ...
0
votes
0answers
37 views

weird behaviour

I am using the Ubuntu 12.04 Precise Pangolin, from past few days I am observing a strange behaviour with my ubuntu server. Let me give you a brief introduction to my server. Installed Softwares and ...
0
votes
0answers
137 views

How can I install pg_test_fsync on Ubuntu Server 14.04?

I attempted to install pg_test_fsync on Ubuntu 14.04 LTS and it appears it cannot be installed without removing postgresql. How can I install pg_test_fsync and keep postgresql? $ pg_test_fsync The ...
0
votes
0answers
162 views

Depending on postgresql-plpython for every installed version of postgresql

I'm working on a project which gets installed as an Ubuntu package. This is part of the code for generating the database (modified): CREATE EXTENSION plpythonu; CREATE FUNCTION foo (str text) ...
0
votes
0answers
65 views

packet-o-matic on Trusty 14.04

I'm trying to install pom on Trusty and have installed the pre-reqs listed at http://wiki.packet-o-matic.org/pom/installation but pom ./configure fails to recognize postgresql root# ./configure . ...
0
votes
0answers
316 views

installing plperl in postgresql

I am trying to use the perl language in postgresql, thus I need to install plperl. I am running all of my queries in pgadmin III. When I first tried create extension plperl; I get the following ...
0
votes
0answers
2k views

Problems in installation of Postgresql

I got following error while installing postgresql client The following packages have unmet dependencies: postgresql-9.3 : Depends: postgresql-client-9.3 but it is not going to be installed Depends: ...
0
votes
0answers
140 views

Problem installing postgresql on ubuntu 12.04 LTS error "cannot find proc/version

I'm trying to install PostgreSQL on my VPS running Ubuntu 12.04. A month ago I success installed Postgresql 9.3 but I forgot the Postgis extension, after I installed the Postgis there come a problem ...
0
votes
0answers
301 views

Failure to install postgresql-plperl-8.4 on Ubuntu 14.04

I have recently had a problem installing postgresql-plperl-8.4 on the new Ubuntu 14.04 distribution. The reason why I am installing older version of plperl is that the server getting upgraded needs to ...