FAQ
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.

Search Discussions

  • Brent Dombrowski at Apr 19, 2011 at 3:49 am

    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.
  • Pyrogerg at Apr 19, 2011 at 4:21 am
    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: http://postgresql.1045698.n5.nabble.com/MDTFATAL-could-note-create-log-file-permission-denied-tp4312282p4312440.html
    Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
  • Tom Lane at Apr 19, 2011 at 5:47 am

    Pyrogerg 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
  • Pyrogerg at Apr 19, 2011 at 3:21 pm
    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]
    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 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]
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedApr 19, '11 at 2:47a
activeApr 19, '11 at 3:21p
posts5
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase