Server not listening... easy fix or workaround?

From: Rainer Schuetz <rs(at)bagong(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Server not listening... easy fix or workaround?
Date: 2010-03-18 10:06:32
Message-ID: CAC14C81-B867-4FDF-BE81-65905776595B@bagong.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I just installed Postgresql 8.4 on a MacBook (Snow Leopard) through Macports. All went fine down to the point where I wanted to make configuration a bit more practical for myself ;)

The server was installed nicely, I could initialize the default database, create passwords, users, databases, import my saved data from a older install and access all this through pgadmin. Pgadmin also offers the possibility to edit configuration-files, but there is a problem: you have to be able to access them ;) and you can't offer file-system credentials through pgadmin (not that I knew you could). So I thought I add myself (the OSX-user) to the postgres group and make the defaultdb folders and file readable for the group and the .conf-files read-writable... As a result pgadmin wouldn't be able to access the server any more with an error message starting similar to: the server is not listening at 127.0.0.1 on port .... The server was still running as launchctl reported, but even a reboot, or a reconstruction of the defaultdb-folders through timemachine wouldn't make the server "listen" again. Obviously something security-related is going on of which I have no idea. Would somebody mind pointing me to a better practice or a workaround? Basically I just want to edit the configuration files through pgadmin... In a more general perspective I was also thinking about backing up my data through the file-system rather than manually dumping the files, because I could use my general backup-software which runs periodically - but here as well I'd have to have read- and potentially also write access to the defaultdb folders...
Thanks in advance
Rainer

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-03-18 14:08:33 Re: Server not listening... easy fix or workaround?
Previous Message Gurjeet Singh 2010-03-18 05:55:48 Re: PostgreSQL questions