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.
Is this the date when you installed? Are these the first entries you
have in the log?