Thread: MDTFATAL: could note create log file . . . permission denied
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. -- View this message in context: http://postgresql.1045698.n5.nabble.com/MDTFATAL-could-note-create-log-file-permission-denied-tp4312282p4312282.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
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 thepostgres 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.
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] wrote:
> gpennhost: data postgres$ /usr/local/pgsql/bin/pg_ctl -D
> /usr/local/pgsql/data -l /some/path/here/logfile start
View this message in context: Re: MDTFATAL: could note create log file . . . permission denied
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
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] wrote:
> gpennhost: data postgres$ /usr/local/pgsql/bin/pg_ctl -D
> /usr/local/pgsql/data -l /some/path/here/logfile start
View this message in context: Re: MDTFATAL: could note create log file . . . permission denied
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
Pyrogerg <gregory.penn@gmail.com> 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
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
View this message in context: Re: MDTFATAL: could note create log file . . . permission denied
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
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
[hidden email]
April 18, 2011 11:47 PM
Pyrogerg <[hidden email]> 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])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-noviceIf 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.htmlTo unsubscribe from MDTFATAL: could note create log file . . . permission denied, click here.
[hidden email]
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$
[hidden email]
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])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-noviceIf 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.htmlTo unsubscribe from MDTFATAL: could note create log file . . . permission denied, click here.
View this message in context: Re: MDTFATAL: could note create log file . . . permission denied
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.