Yes I tried to install that date. And that is from the beginning of the file.

I have a log from Friday as well.

# cat postgresql-Fri.log
LOG:  database system was shut down at 2012-03-09 15:43:14 CET
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
ERROR:  database "engine" does not exist
STATEMENT:  DROP DATABASE engine;

WARNING:  nonstandard use of escape in a string literal at character 46
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  column "status" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
WARNING:  column "owner" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
WARNING:  column "storage_pool_id" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
WARNING:  column "storage_pool_name" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.


Also I just ran a engine-cleanup and check what was added to todays log.
Then I did a engine-setup. All it did was that it added one line "FATAL:  database "engine" does not exist" to the log.

/Raboo

2012/3/11 Yair Zaslavsky <yzaslavs@redhat.com>
On 03/11/2012 09:32 PM, Elias Abacioglu wrote:
>
> 2012/3/11 Yair Zaslavsky <yzaslavs@redhat.com <mailto:yzaslavs@redhat.com>>
>
>     On 03/11/2012 05:48 PM, Elias Abacioglu wrote:
>     > Den den 11 mars 2012 16:40:06 skrev Yair Zaslavsky:
>     >> On 03/11/2012 05:24 PM, Elias Abacioglu wrote:
>     >>> Hi,
>     >>>
>     >>> I can postgresql is running and I can access it using "psql -U
>     postgres"
>     >>
>     >> What happens when you type "psql engine postgres" ?
>     > psql: FATAL:  database "engine" does not exist
>     Ok, postgres service is up, but something went wrong in the creation.
>
>     Can you please provide the postgres log?
>     It should be located at
>
>     /var/lib/pgsql/data/pg_log/postgresql-Sun.log (if you tried installing
>     it today).
>
>     Please notice that on my environment this directory is accessible from
>     root (and not my regular user).
>
>
> Here is the log from yesterday.
>
> LOG:  received fast shutdown request
> LOG:  aborting any active transactions
> LOG:  autovacuum launcher shutting down
> LOG:  shutting down
> LOG:  database system is shut down
> LOG:  database system was shut down at 2012-03-10 12:44:46 CET
> LOG:  autovacuum launcher started
> LOG:  database system is ready to accept connections
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> LOG:  received fast shutdown request
> LOG:  aborting any active transactions
> LOG:  autovacuum launcher shutting down
> LOG:  shutting down
> LOG:  database system is shut down
> LOG:  database system was shut down at 2012-03-10 14:29:30 CET
> LOG:  autovacuum launcher started
> LOG:  database system is ready to accept connections
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
> FATAL:  database "engine" does not exist
>
>
> Also it contains many more 'FATAL:  database "engine" does not exist'.
> Almost 70.000.

Thanks for the log,
Is this the date when you installed? Are these the first entries you
have in the log?