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

learn more… | top users | synonyms

0
votes
1answer
23 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
4answers
14k views

Uninstall postgresql from Ubuntu

I simply don't understand what's going on. sudo apt-get remove postgresql results in: Reading package lists... Done Building dependency tree Reading state information... Done Package ...
1
vote
1answer
35 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: ...
-1
votes
0answers
26 views

Postgresql- bad version or just bad operate system?

I'm experiencing a lot of conflicts with postgresql (9.1, 9.2, & 9.3) on Ubuntu 14.04. (32-bit) Versions that has errors, and when uninstalling and reinstalling, the config folders in etc are not ...
0
votes
1answer
19 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
20 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 ...
1
vote
2answers
1k views

apt-get -f install gives error

When I run apt-get -f install, it gives the following error: # apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting ...
0
votes
1answer
17 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
1answer
136 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 ...
0
votes
1answer
350 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 ...
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 ...
13
votes
1answer
7k views

Postgres doesn't have hstore extension

I was trying to run the following command but i threw me any error. template1=# CREATE EXTENSION hstore ERROR: could not open extension control file ...
0
votes
0answers
55 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 ...
8
votes
5answers
14k views

Problem Installing and configuring PostgreSQL

I am a newbie here and to the server administration. A couple of days back I have registered a server with Hetzner with Ubuntu 11.04. I intend to work with PostgreSQL, for which I have installed ...
1
vote
1answer
118 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
33 views

Postgresql ubuntu 12.04 not starting

I installed PostgreSQL on ubuntu 12.04, using apt-get install postgresql Everything worked fine. I made database, inserted data etc. Then I rebooted my computer, and postgres did not start. There is ...
0
votes
0answers
19 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 ...
2
votes
2answers
2k views

Is there an Postgres ERD tool (or pgAdmin III plugin)?

Don't hold it against me, but I have a fond memory of MS SQL Server Management Studio. I could very easily generate an ERD diagram from an existing database. Tables, relationships, the works. You ...
2
votes
1answer
93 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
54 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
148 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 ...
1
vote
1answer
108 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
votes
3answers
4k 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 ...
0
votes
2answers
70 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 ...
0
votes
0answers
49 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
1answer
80 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: ...
1
vote
2answers
106 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
35 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 ...
1
vote
1answer
252 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
23 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
0answers
102 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
1answer
170 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
266 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
135 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
80 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
1answer
344 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 ...
0
votes
1answer
116 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
3k 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
83 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 ...
3
votes
4answers
8k views

PHPPgAdmin not working in Ubuntu 14.04

After a fresh install of Ubuntu 14.04, I've installed postgresql and phppgadmin from the Ubuntu repos. I am using the Apache2 webserver. PHP is working fine in the webserver, as is PHPMyAdmin, but ...
1
vote
1answer
398 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
0answers
60 views

PostgreSQL start.conf not working

I've just upgraded to 14.10 from 14.04. I have both 9.3 and 9.4 versions of PostgreSQL installed but, for now and until i fully migrate to 9.4, i just want to start the 9.3 cluster. I edited the ...
2
votes
1answer
181 views

How to make Postgres start automatically on boot

I am new to Ubuntu and I would like to know how to make postgresql start automatically on boot and how to configure my setup so that I can start the postgres server if need be. I am working on a ...
2
votes
2answers
4k views

Run a PostgreSQL instance locally

I'm trying to follow this tutorial, but at the beginning it says to run a postgresql instance "locally" instead of as a daemon using the following commands. $ initdb pg $ postgres -D pg & $ ...
0
votes
0answers
133 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 ...
1
vote
2answers
3k views

upgrade pgadmin3 1.16 to 1.18

I'm running Ubuntu 13.04 and have pgadmin3 1.16 installed. I downloaded pgadmin3-1.18.1.tar.gz from http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/src/ I followed all the instructions found ...
0
votes
0answers
136 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
1answer
100 views

postgresql has different version in ubuntu minimal (server)

I bought an vps (virtual private server) and have installed ubuntu minimal (server) 12.04 32 bit on it for openerp use, and one of the openerp requirement is installing the postgresql I installed ...
16
votes
4answers
58k views

How do I find the path to pg_hba.conf from the shell?

I would like to obtain the path to pg_hba.conf from the shell. The path varies between versions of PostgreSQL. For instance, for 8.4 and 9.1: /etc/postgresql/8.4/main/pg_hba.conf ...
2
votes
1answer
791 views

postgres-xc will not install due to broken packages

On a 14.04 installation, postgresql was installed via sudo apt-get install postgresql postgresql-contrib libpq-dev This installation is meant to be a slave but cannot start up without running ...