Re: MDTFATAL: could note create log file . . . permission denied

Issue resolved.

My solution wasn't based on understanding the problem, unfortunately. I
just deleted the postgresql directories and reinstalled using a binary
from enterprisedb.com. At least it's up and running now, so I can start
figuring out how to put together a database.

Cheers,
Gregory

> ------------------------------------------------------------------------
>
> Tom Lane-2 [via PostgreSQL]
> <mailto:ml-node+4312551-823411009-199339(at)n5(dot)nabble(dot)com>
> April 18, 2011 11:47 PM
>
>
> Pyrogerg <[hidden email]
> </user/SendEmail.jtp?type=node&node=4312551&i=0&by-user=t>> writes:
> > Brent,
> > I did as you suggested and obtained the same results as before.
>
> > gpennhost:bin postgres$ /usr/local/pgsql/bin/pg_ctl -D
> > /usr/local/pgsql/data -l /usr/local/pgsql/data/logfile start
> > server starting
> > gpennhost:bin postgres$ createdb test
> > createdb: could not connect to database postgres: could not connect to
> > server: No such file or directory
> > Is the server running locally and accepting
> > connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> > gpennhost:bin postgres$
>
> What appears in the logfile? Also, where are you seeing the message
> quoted in your Subject?
>
> regards, tom lane
>
> --
> Sent via pgsql-novice mailing list ([hidden email]
> </user/SendEmail.jtp?type=node&node=4312551&i=1&by-user=t>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>
> ------------------------------------------------------------------------
> If you reply to this email, your message will be added to the
> discussion below:
> http://postgresql.1045698.n5.nabble.com/MDTFATAL-could-note-create-log-file-permission-denied-tp4312282p4312551.html
>
> To unsubscribe from MDTFATAL: could note create log file . . .
> permission denied, click here
> <http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4312282&code=Z3JlZ29yeS5wZW5uQGdtYWlsLmNvbXw0MzEyMjgyfC0xNTU1MzM2MzM1>.
>
> ------------------------------------------------------------------------
>
> Gregory Penn <mailto:gregory(dot)penn(at)gmail(dot)com>
> April 18, 2011 10:21 PM
>
>
> Brent,
>
> I did as you suggested and obtained the same results as before.
>
> gpennhost:bin postgres$ /usr/local/pgsql/bin/pg_ctl -D
> /usr/local/pgsql/data -l /usr/local/pgsql/data/logfile start
> server starting
> gpennhost:bin postgres$ createdb test
> createdb: could not connect to database postgres: could not connect to
> server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> gpennhost:bin postgres$
>
>
> ------------------------------------------------------------------------
>
> Brent Dombrowski [via PostgreSQL]
> <mailto:ml-node+4312387-1557495654-199339(at)n5(dot)nabble(dot)com>
> April 18, 2011 9:49 PM
>
>
> On Apr 18, 2011, at 7:47 PM, Pyrogerg wrote:
>
> > After many more hours than it would've taken someone more competent, I
> > finally have postgresql 9.0 installed on my Mac (OS 10.6). Now I'm
> trying to
> > start the server and create a test database, but I've run into a
> problem . .
> > .
> >
> > gpennhost:data postgres$ /usr/local/pgsql/bin/pg_ctl -D
> > /usr/local/pgsql/data -l logfile start
> > server starting
> > gpennhost:data postgres$ createdb test
> > createdb: could not connect to database postgres: could not connect to
> > server: No such file or directory
> > Is the server running locally and accepting
> > connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> > gpennhost:data postgres$
> >
> > I've looked at the config file, and verified that the port defaults
> to 5432,
> > but I don't know what else to do. I've spent 10 hours today getting
> to this
> > point, and searching this forum and others hasn't turned up a
> solution. If
> > you have advice on how to proceed, please keep in mind that I am
> very new to
> > this.
> >
> > Thanks in advance.
>
>
> The logfile is set to the current directory. Try using the full path
> to the logfile. It needs to be in a directory that the postgres owner
> can write to.
>
> gpennhost: data postgres$ /usr/local/pgsql/bin/pg_ctl -D
> /usr/local/pgsql/data -l /some/path/here/logfile start
>
>
> Brent D.
>
>
> --
> Sent via pgsql-novice mailing list ([hidden email]
> </user/SendEmail.jtp?type=node&node=4312387&i=0&by-user=t>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>
> ------------------------------------------------------------------------
> If you reply to this email, your message will be added to the
> discussion below:
> http://postgresql.1045698.n5.nabble.com/MDTFATAL-could-note-create-log-file-permission-denied-tp4312282p4312387.html
>
> To unsubscribe from MDTFATAL: could note create log file . . .
> permission denied, click here
> <http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4312282&code=Z3JlZ29yeS5wZW5uQGdtYWlsLmNvbXw0MzEyMjgyfC0xNTU1MzM2MzM1>.
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/MDTFATAL-could-note-create-log-file-permission-denied-tp4312282p4313481.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.