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

learn more… | top users | synonyms

0
votes
1answer
15 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
67 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
1answer
23 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
26 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
2answers
25 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
12 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
24 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
1answer
24 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
15 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
26 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
45 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
1answer
114 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
27 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
36 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
116 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
79 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
42 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
35 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
823 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
57 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 ...
1
vote
1answer
63 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
47 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
0answers
42 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 ...
1
vote
1answer
73 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 ...
0
votes
0answers
90 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
86 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 ...
2
votes
1answer
353 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 ...
0
votes
0answers
241 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
53 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
1answer
96 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 ...
0
votes
0answers
479 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
17 views

How can I install ODBC on Ubuntu? [duplicate]

I need the ODBC driver on Ubuntu to connect R with PostgreSQL, but I don't know how to install it.
0
votes
0answers
34 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 ...
1
vote
0answers
264 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
1answer
333 views

Missing PostgreSQL postmaster.pid

I have PostgreSQL 8.4 installed on ubuntu 12.04. When i start postgresql service through terminal, it doesn't start. Then i check and found that postmaster.pid is missing. My question is how can i ...
2
votes
2answers
149 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 ...
0
votes
0answers
82 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
102 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) ...
1
vote
0answers
98 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
1answer
102 views

pgAdmin show object browser text white on white with dark theme

When using a dark theme, the object browser uses white background. Is there some way to change this? This question has been asked a few times, but no answer still. The theme I am using is E17. ...
1
vote
1answer
460 views

Command pg_dump not found?

I was going to make a backup in a server and I got the error: pg_dump command not found I thought that if you had postgres installed, it worked. What I have to do to "install" it? Because I do not ...
0
votes
0answers
47 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 . ...
1
vote
1answer
145 views

PostgreSQL importing from folder

I lost my ubuntu partition (12.04) and I've installed the ubuntu 14.04, I could save my database files from postgreSQL v9.1, but now I'm with a problem how can I import this data base and my settings ...
0
votes
2answers
36 views

postgresql vs postgresql-server-dev package

What is the difference between postgresql and postgresql-server-dev packages. What are the purposes served by installing different packages and what are the use-cases of these?
3
votes
2answers
717 views

PostGIS dependency conflicts (ubuntu 14)

I asked this over on SO, but now I'm thinking the problem is mainly package management and belongs here. Subsequent to all the detail that can be found in the original post, I have tried (sudo ...
0
votes
1answer
36 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
39 views

Where are the log files for psql connection attempts?

I want to troubleshoot a failed attempt to connect to a remote Pg server using psql. I'd expected to find some log files for psql, but I didn't. Is there any other place where such information would ...
1
vote
1answer
448 views

What are the IP addresses in my iptables chain FORWARD settings in a Dokku/docker setup?

I've been playing around with Dokku on DigitalOcean (following this guide) and I'm trying to understand current firewall settings. So here's my setup: Ubuntu 14.04 Dokku Docker (as part of Dokku) ...
0
votes
0answers
160 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
1answer
1k views

Postfix PostgreSQL Dovecot SASL Authentication Fails Ubuntu 14.04LTS Server

I previously setup my mail server using Ubuntu 12.04LTS and all worked fine (see Postfix Dovecot SASL Authentication not enabled/working ubuntu 12.04 server), but I recently moved everything to new ...