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
11 views

Postgres session appears next to mine

I'm using Ubuntu 14.04 LTS, today when I start the OS I found a new user added next to mine and the guest user called Postgres and I never added it manually. All I knew is that recently I installed : ...
0
votes
0answers
19 views

How to use PgAdmin?

I have installed PgAdmin III in my Ubuntu Gnome OS. How can I start using it in order to create a database? What should I give as service while connecting to a server?
0
votes
2answers
184 views

Postgres 9.4 running but “service status” reports it down

Ubuntu 14.04.3 LTS and a new installation of Postgres 9.4 (with apt-get install postgresql-9.4, nothing fancy). Postgres was started with pg_ctl start by the postgres user. The status command reports ...
0
votes
0answers
17 views

Installing mit-scheme alongside postgres

I recently started reading structure and interpretation of a programing language and as such I want to install the mit-scheme interpreter but I realized whenever I installed it, it uninstalled ...
2
votes
1answer
117 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
46 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
176 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 ...
0
votes
2answers
33 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
225 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
160 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
77 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
49 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
86 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
2k 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
1answer
344 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 ...
1
vote
1answer
6k 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 ...
4
votes
2answers
3k 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
328 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
503 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
638 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
129 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
1k 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 ...
7
votes
3answers
25k 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
1k 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
90 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
386 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
6k 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
689 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
245 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