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
38 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
71 views

pg_dump won't run through PHP

This question has been addressed in various other posts but they don't seem to help me out. My issue is that I run the following script: $strBK = '/usr/bin/pg_dump --host localhost --port 5432 ...
0
votes
0answers
25 views

psql autocomplete stopped working suddenly

So I have psql 9.3 installed on my Ubuntu machine. Today I updated my Ruby and Ruby on Rails versions up to date and after that when I wanted to access my database in psql, I typed in as usual: psql ...
0
votes
0answers
392 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 ...
1
vote
1answer
474 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 ...
1
vote
2answers
618 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
70 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
175 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
1k 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
234 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
50 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
372 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
9k 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
509 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
1answer
56 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
187 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
485 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
160 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
57 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