Yes I tried to install that date. And that is from the beginning of the file.<br><br>I have a log from Friday as well.<br><br># cat postgresql-Fri.log<br>LOG: database system was shut down at 2012-03-09 15:43:14 CET<br>LOG: database system is ready to accept connections<br>
LOG: autovacuum launcher started<br>ERROR: database "engine" does not exist<br>STATEMENT: DROP DATABASE engine;<br><br>WARNING: nonstandard use of escape in a string literal at character 46<br>HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.<br>
WARNING: column "status" has type "unknown"<br>DETAIL: Proceeding with relation creation anyway.<br>WARNING: column "owner" has type "unknown"<br>DETAIL: Proceeding with relation creation anyway.<br>
WARNING: column "storage_pool_id" has type "unknown"<br>DETAIL: Proceeding with relation creation anyway.<br>WARNING: column "storage_pool_name" has type "unknown"<br>DETAIL: Proceeding with relation creation anyway.<br>
<br><br>Also I just ran a engine-cleanup and check what was added to todays log.<br>Then I did a engine-setup. All it did was that it added one line "FATAL: database "engine" does not exist" to the log.<br>
<br>/Raboo<br><br><div class="gmail_quote">2012/3/11 Yair Zaslavsky <span dir="ltr"><<a href="mailto:yzaslavs@redhat.com">yzaslavs@redhat.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 03/11/2012 09:32 PM, Elias Abacioglu wrote:<br>
><br>
> 2012/3/11 Yair Zaslavsky <<a href="mailto:yzaslavs@redhat.com">yzaslavs@redhat.com</a> <mailto:<a href="mailto:yzaslavs@redhat.com">yzaslavs@redhat.com</a>>><br>
<div><div class="h5">><br>
> On 03/11/2012 05:48 PM, Elias Abacioglu wrote:<br>
> > Den den 11 mars 2012 16:40:06 skrev Yair Zaslavsky:<br>
> >> On 03/11/2012 05:24 PM, Elias Abacioglu wrote:<br>
> >>> Hi,<br>
> >>><br>
> >>> I can postgresql is running and I can access it using "psql -U<br>
> postgres"<br>
> >><br>
> >> What happens when you type "psql engine postgres" ?<br>
> > psql: FATAL: database "engine" does not exist<br>
> Ok, postgres service is up, but something went wrong in the creation.<br>
><br>
> Can you please provide the postgres log?<br>
> It should be located at<br>
><br>
> /var/lib/pgsql/data/pg_log/postgresql-Sun.log (if you tried installing<br>
> it today).<br>
><br>
> Please notice that on my environment this directory is accessible from<br>
> root (and not my regular user).<br>
><br>
><br>
> Here is the log from yesterday.<br>
><br>
> LOG: received fast shutdown request<br>
> LOG: aborting any active transactions<br>
> LOG: autovacuum launcher shutting down<br>
> LOG: shutting down<br>
> LOG: database system is shut down<br>
> LOG: database system was shut down at 2012-03-10 12:44:46 CET<br>
> LOG: autovacuum launcher started<br>
> LOG: database system is ready to accept connections<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> LOG: received fast shutdown request<br>
> LOG: aborting any active transactions<br>
> LOG: autovacuum launcher shutting down<br>
> LOG: shutting down<br>
> LOG: database system is shut down<br>
> LOG: database system was shut down at 2012-03-10 14:29:30 CET<br>
> LOG: autovacuum launcher started<br>
> LOG: database system is ready to accept connections<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
> FATAL: database "engine" does not exist<br>
><br>
><br>
> Also it contains many more 'FATAL: database "engine" does not exist'.<br>
> Almost 70.000.<br>
<br>
</div></div>Thanks for the log,<br>
Is this the date when you installed? Are these the first entries you<br>
have in the log?<br>
<br>
<br>
</blockquote></div><br>