Re: Server not listening... easy fix or workaround?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rainer Schuetz <rs(at)bagong(dot)de>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Server not listening... easy fix or workaround?
Date: 2010-03-18 14:08:33
Message-ID: 9992.1268921313@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Rainer Schuetz <rs(at)bagong(dot)de> writes:
> 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

If you look into the server's log file, you will probably find out that
it's refusing to start because of the insecure permissions on the data
directory. Don't do that. If you want to edit the config files you
need to be the postgres user.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-03-18 20:27:02 Re: Drop table by something other than its name
Previous Message Rainer Schuetz 2010-03-18 10:06:32 Server not listening... easy fix or workaround?