Tagged Questions

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

learn more… | top users | synonyms

0
votes
0answers
10 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
18 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
13 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
19 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
35 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
32 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
51 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
112 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
142 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
32 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
38 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
296 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
213 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
154 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
81 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
58 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
65 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
63 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
62 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. ...
0
votes
1answer
235 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
35 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
102 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
33 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?
2
votes
2answers
506 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
33 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
28 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
273 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
105 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 ...
0
votes
1answer
113 views

PostgreSQL data diff

Note: this question is not about syncing database schema/structure Problem In my web application I have a PostgreSQL database server (PGS) and a (separate machine) business logic server (BLS) which ...
0
votes
0answers
24 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
1answer
502 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.
3
votes
2answers
287 views

How to run postbooks server in Ubuntu?

I installed post-book accounting software from Ubuntu software center in 14.04 LTS. Also installed post-book demo database and PostgreSQL. But I cannot able to run the post-book server. How can I ...
0
votes
1answer
73 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 ...
0
votes
1answer
27 views

What order are config files loaded under linux when there are multiple sources?

I understand the main principle that local configuration files precede global /etc/ configuration files. What I really need though is some more detail on this because sometimes it's not obvious. The ...
0
votes
0answers
704 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
2answers
166 views

user postgres cannot access drive even after permissions and group membership are provided

I have been working on this for the better part of the morning. So I upgraded to ubuntu 14.04 last night, and that went smoothly. But there is an issue with the postgres user and access to my ...
2
votes
1answer
3k views

Starting PostgreSQL server, postgres user unknown

I am trying to start a PostgreSQL server (9.3) on Ubuntu 14.04. I am following this standard tutorial: https://help.ubuntu.com/community/PostgreSQL After updating to from 13.10 to 14.04 I purged the ...
1
vote
0answers
951 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 ...
0
votes
1answer
128 views

Compiling the mysql_fdw for postgresql?

I'm attempting to compile the MySQL Foreign Data Wrapper for Postgresql 9.1+, on Ubuntu 12.04 LTS and having a fair bit of trouble getting it to work. So far I've managed to use git to download the ...
0
votes
0answers
105 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
239 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 ...
1
vote
1answer
1k 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 ...
3
votes
2answers
2k views

postgresql broken after 14.04 despite succesful pg_upgrade [SOLVED]

I'm running an Ubuntu VPS where i'm am upgrading to 14.04. everything has gone smoothly so far. Except the PostgreSQL migration from 9.1 to 9.3. The server hosts a Django 1.6 site and the traceback ...
1
vote
4answers
5k 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 ...
0
votes
2answers
197 views

When will PostgreSQL 9.3 be supported on any version of Ubuntu LTS?

according to http://packages.ubuntu.com/saucy-updates/database/ the latest version of PostgreSQL that's supported in Ubuntu 12.04 LTS is 9.1, specifically the package name is postgresql-9.1 ...
0
votes
1answer
264 views

How to remove a package after incorrect installation attempt

I was trying to install PostgreSQL 9.3 from the downloaded installer: postgresql-9.3.4-3-linux-x64.run Still learning the ropes with Linux, I believe I originally installed it using an incorrect ...
1
vote
1answer
452 views

Postgresql server installation keeps failing due to postgresql-common error

The installation of postgresql server in Ubuntu 12.04 fails. Its seem to be due to incomplete configuration of postgresql-common package. I purged all packages related to postgresql, tried to ...