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

2
votes
1answer
9 views

not able to uninstall postsql-xc

Postgressql installation was broken once I installed postgres-xc and postgres-xc-client. I tried uninstalling but not able to do it. The log of activities follows: postgres@ashUbuntu:~$ sudo apt-get ...
0
votes
1answer
25 views

Which is the proper way to install postgresql [14.04]

Recently I have been trying to install a postgres server instance on 14.04 but I've run into the issue of not knowing which install I need/want. here are the different ones I've found ...
1
vote
1answer
36 views

postgres fails to uninstall

while trying to uninstall postgresql with sudo apt-get remove postgresql I received the following error message Reading package lists... Done Building dependency tree Reading state ...
-1
votes
1answer
25 views

Can't start postgres server

I've downloaded postgres and can't start the server. I used following command to install it: sudo apt-get install postgresql-9.4 as described here: http://www.postgresql.org/download/linux/ubuntu/ ...
0
votes
2answers
25 views

Run a .sh file depending on the content of a file

I want to create a .sh file that needs to have a look into the content of a different file, in this case is the postgresql configuration file. Is there any way that I can run a command within the .sh ...
0
votes
0answers
110 views

Cannot connect to Heroku Postgres DB with Pgadmin tool

I'm accessing the Postgres DB (which is a public URL )through Pgadmin tool. The database is hosted on Heroku. I get this error message: The connection to the database is lost. Do you want to ...
0
votes
1answer
30 views

How do I recover/reset the postgres password?

I have forgotten the password that I used while installing postgres. It asks for the password for every action I perform. What can I do in this case? I've even tried removing postgres and ...
0
votes
0answers
35 views

How to enable PgAdmin Query Tool Favorites

I use pgAdmin extensively but cannot get the Query Tool favorites to work. The Add Favourite and Manage Favourite menu options are greyed out. I think I have a valid .pgadminfavorites xml file as I ...
0
votes
0answers
23 views

dpkg hangs when updating / reinstalling postgresql after restarting postgresql during installation

I restarted postgresql during the process of upgrading it and now the upgrade process hangs for postgresql. I've tried everything including removing/purging postgresql but now it hangs on install. ...
0
votes
1answer
52 views

Steps to deinstall postgres

I installed postgres. It created a user account. I don't need postgres anymore. What are the steps I have to proceed to uninstall it completely from Ubuntu 14.04? (I didn't install the software over ...
3
votes
1answer
634 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 ...
0
votes
0answers
192 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
204 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
73 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 ...
1
vote
1answer
3k 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
2k 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
2answers
228 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 ...
3
votes
1answer
359 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
2answers
447 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
68 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
870 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 ...
4
votes
3answers
18k 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
864 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
77 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
295 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
4k 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
626 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
204 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: ...
2
votes
1answer
2k 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