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?