Skip site navigation (1) Skip section navigation (2)

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

From: Pyrogerg <gregory(dot)penn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: MDTFATAL: could note create log file . . . permission denied
Date: 2011-04-19 14:56:44
Message-ID: 4DADA29D.1030809@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

pgsql-novice by date

Next:From: Deka, Rajib IN MAA SLDate: 2011-04-20 13:12:48
Subject: Database system identifier mismatch
Previous:From: Fletcher JohnsonDate: 2011-04-19 14:54:10
Subject: Database encoding and Ctype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group