Thread: Could not create log file error?
I am rather unsure of postgres logging, but I think the way to go is to unrem some of the lines in postgresql.conf, restart the db. Now I get this: * Starting PostgreSQL 8.2 database server * Error: Could not create log file /var/lib/postgresql/8.2/main/pg_log/postgresql-2007-07-15_143020.log I manually created a dir called pg_log, since it wasn't already there. What am I missing? -- View this message in context: http://www.nabble.com/Could-not-create-log-file-error--tf4083495.html#a11606286 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
And the other thing that I have found puzzling is that there *is* already a log file in the main postgres dir, right next to postgresql.cong (/etc/postgresql/8.2/main). In postgresql.cong all logging was rem'd; but that log file was being updated. What's the difference between the log file that was already there and the one that I'm trying to create via the conf file mods? novnov wrote: > > I am rather unsure of postgres logging, but I think the way to go is to > unrem some of the lines in postgresql.conf, restart the db. Now I get > this: > > * Starting PostgreSQL 8.2 database server > * Error: Could not create log file > /var/lib/postgresql/8.2/main/pg_log/postgresql-2007-07-15_143020.log > > I manually created a dir called pg_log, since it wasn't already there. > What am I missing? > -- View this message in context: http://www.nabble.com/Could-not-create-log-file-error--tf4083495.html#a11606752 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
novnov <novnovice@gmail.com> writes:
> * Error: Could not create log file
> /var/lib/postgresql/8.2/main/pg_log/postgresql-2007-07-15_143020.log
> I manually created a dir called pg_log, since it wasn't already there. What
> am I missing?
Wrong ownership or permissions of that directory, likely. You have left
out the part of the message that said what was wrong.
regards, tom lane
That is all that the error contains. I try to start postgres and it returns that error. I had tried to set the perms to allow creation of files but for some reason it didn't stick. Redid and all ok. I'm still curious as to why there is the log in the etc/.../main dir (actually I see now that it's a link to a file called postgresql-8.2-main.log), which seems to have been created by the installer, and the new one that is being written to pg_log. Thanks Tom Lane-2 wrote: > > novnov <novnovice@gmail.com> writes: >> * Error: Could not create log file >> /var/lib/postgresql/8.2/main/pg_log/postgresql-2007-07-15_143020.log > >> I manually created a dir called pg_log, since it wasn't already there. >> What >> am I missing? > > Wrong ownership or permissions of that directory, likely. You have left > out the part of the message that said what was wrong. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > -- View this message in context: http://www.nabble.com/Could-not-create-log-file-error--tf4083495.html#a11607650 Sent from the PostgreSQL - general mailing list archive at Nabble.com.