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

learn more… | top users | synonyms

-1
votes
0answers
11 views

psql: FATAL: database “forum” does not exist

vagrant@vagrant-ubuntu-trusty-32:~$ cd /vagrant/forum vagrant@vagrant-ubuntu-trusty-32:/vagrant/forum$ psql forum psql: FATAL: database "forum" does not exist ...
0
votes
0answers
15 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
1answer
25 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
22 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
6 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
66 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
93 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
67 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
28 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
21 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
290 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
18 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
64 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
83 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
45 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, ...
2
votes
2answers
199 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
45 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
2answers
64 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
369 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. ...
1
vote
1answer
206 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
38 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
59 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 ...
0
votes
0answers
163 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
49 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 ...
3
votes
1answer
335 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 ...
1
vote
2answers
58 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
410 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 ...
1
vote
3answers
14k 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 ...
1
vote
1answer
303 views

Postgres createdb is not working in Ubuntu 14.04

I have been trying for hours to create a database in a specific directory in Ubuntu 14.04. First I tried createdb mydb and I got createdb: could not connect to database template1: FATAL: ...
0
votes
0answers
60 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, ...
1
vote
2answers
232 views

How to specify a different locale for postgreSQL installation?

My system's locale is en_US.UTF-8. Because of that, the postgreSQL installation uses this locale by default for the cluster during installation. Creating new cluster 9.3/main ... config ...
0
votes
0answers
51 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
2answers
130 views

how to remove postgresql and phppgadmin from xampp stack

I installed lampp from https://bitnami.com/stack/lamp on my pc running ubuntu 14.04 i also installed the postgresql addon too from https://bitnami.com/stack/postgresql Currently i can't seem to login ...
1
vote
1answer
811 views

PSQL - password authentication failed for user “postgres”

I have freshly installed postgresql 9.4 on my ubuntu 14.10 box and I have run \password as the postgres user and given it the password postgres: $> sudo -u postgres psql =# \password Enter new ...
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 ...
1
vote
0answers
273 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 ...
0
votes
0answers
526 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 ...
1
vote
1answer
215 views

installing Ubuntu Openstack - Canonical Distribution on a virtual environment

I've tried to install Ubuntu Openstack - Canonical Distribution using this new Ubuntu guide. During step 3, i use the following command to install MaaS; sudo apt install maas I've received this ...
0
votes
0answers
226 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
140 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 ...
1
vote
1answer
684 views

PgAdmin 3 @ Ubuntu 14.10: low responsiveness when typing

I've been using PostgreSQL and PgAdmin 3 for years without problems so far. Recently I installed Ubuntu 14.10 at new notebook with PgAdmin. The problem is that I have to type very slowly to get the ...
0
votes
1answer
495 views

Help Connecting Ubuntu Server 14.04 VM/postgres to postgreSQL workbench on localhost?

I'm new to SQL and am trying to configure and Ubuntu Server 14.04 VM to connect to SQL Workbench x64 on the localhost. Below are my settings for the Virtual machine's port forwarding and the error I ...
1
vote
1answer
320 views

Wine ODBC connection to local PostgreSQL database

I'm running PostgreSQL server which I want to access from program under wine. I installed necessary wine software to be able to make ODBC connection. But is it possible to access local PostgreSQL ...
0
votes
1answer
634 views

how to nicely stop all postgres processes

How do you nicely stop all postgres processes with pg_ctl (or otherwise), when you don't recall what the database directory is, nor have the PGDATA environment variable defined?
0
votes
2answers
6k views

How to install Postgresql 9.3 instead of default 9.4 in Ubuntu 14.10?

I'm on Utopic Unicorn and I need to install Postgresql 9.3 server and client. When I try to autocomplete sudo apt-get install postgres, I see only 9.4 packages: postgresql ...
0
votes
1answer
108 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 ...
2
votes
1answer
991 views

How to set DISPLAY variable for a process?

I try to run pgadmin3 as user postgres and I get following error: No protocol specified Error: Unable to initialize gtk, is DISPLAY set properly? Command pgadmin3 runs well under pavel (my main ...
0
votes
1answer
323 views

Django Cannot Create Test Database Permission Denied

I'm running Ubuntu 14.04 with Postgres 9.3, Python 3.0 and Django 1.7. When I try to debug my application from PyDev, I receive the following: Creating test database for alias 'default'... Got an ...