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
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? |