PostgreSQL is a powerful, open source object-relational database system. Proven open source SQL database technology, optimized for cloud deployment, with enterprise-grade support.

learn more… | top users | synonyms

0
votes
0answers
45 views

Jboss not start in Ubuntu 14.04

I have installed Jboss but cant start it, please find the attachment. Can you give me any advice, how to fix ? ========================================================================= JBoss ...
0
votes
1answer
74 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
2answers
98 views

Install Phppgadmin without apache

I'm trying to setup a nginx+postgresql testing server,but when i try to install phppgadmin it tries to install apache2, I don't want to install apache2, is there a way to install it without apache?
1
vote
1answer
25 views

FATAL: role “roelof” does not exist

I did install postgresql according to the manual. But as soon as I do rails server I see the above error. Roelof Edit 1: the sudo -u postgres createuser roelof did the trick but now when I do rake ...
0
votes
1answer
58 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
256 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
92 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 ...
1
vote
2answers
42 views

Why does running this restore command take so long?

I'm using PostgreSQL 9.1 on Ubuntu 12.04. The development machine has 2GB RAM and it's a Centrino Duo. The Backup command is pg_dump and takes less than 5 seconds to run from the terminal. But my ...
1
vote
1answer
135 views

cannot write to log file pg_upgrade_internal.log on pg_upgrade

I keep on getting the above error whenever I run the following command via a postgres user. $ /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin/ -B /usr/lib/postgresql/9.3/bin/ -d ...
1
vote
3answers
4k views

Postgres password authentication fails

I've installed PostgreSQL 9.1 and pgadmin3 on Ubuntu Server 13.10. I configured postgresql.conf with: listen_addresses = '*' also I configured ph_hba.conf by changed peer connections to md5 Plus I ...
0
votes
1answer
377 views

failed to uninstall postgres-xc

While trying to set up my rails environment to use postgresql I mistakenly installed postgres-xc. However an error occurred in installation, so when I tried to remove the package I get the following ...
0
votes
0answers
32 views

Does PGAdmin need to be configured for EVERY desktop user?

I have a local machine (Ubuntu 12.04 desktop) with PGAdmin3. When I log in as a standard user on Ubuntu and run PGAdmin, I don't see any server connection. So do I have to recreate a server ...
0
votes
1answer
41 views

Why no PGAdmin in launcher for standard user?

I have installed PGAdmin and it all works well. But when I log in as a Standard User on Ubuntu 12.04 I don't see PGAdmin in the launcher. I have other programs like Libre Office, Lazarus and ...
0
votes
1answer
131 views

Locate a user's bashrc file

Really confused. Upon running cat etc/passwd I have found this: postgres:x:117:126:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash meaning I have a postgres user, right? I want to ...
0
votes
1answer
2k views

How can run sudo commands inside another user, or grant a user the same privileges as an admin?

Noob here, so just please tell me if this is stupid. Apologies also if the jargon in the title is a little off. Here's my problem. I have a user, postgres which I use for all tasks involving the ...
0
votes
1answer
382 views

Remove postgresql and daemon user entries in Ubuntu Logon Screen

I installed ubuntu 13.10 and installed some software. Now I see two new users in the logon screen called daemon and postgres. How can this happen? Is there a way to remove these entries from logon ...
1
vote
1answer
140 views

What accounts for the differing instructions on setting password for postgres?

I'm following this blog post http://hendrelouw73.wordpress.com/2012/11/14/how-to-install-postgresql-9-1-on-ubuntu-12-10-linux/ to install postgres on ubuntu. These are steps two and three. STEP 2: ...
1
vote
0answers
55 views

How to edit or add content to the postgres-xc.prerm file?

I tried to remove postgres-xc. But, I am getting an error like the following: Errors were encountered while processing: postgres-xc E: Sub-process /usr/bin/dpkg returned an error code (1) So, I ...
2
votes
1answer
1k views

error Can't find the 'libpq-fe.h header

Trying to set up postgres for rails. bundle install gives: Can't find the 'libpq-fe.h header