El 12/10/2010 13:26, Victor escribió:
Hello, my name is Viktor, I am from Ukraine.
I work under ArchLinux.
I have installed Postgresql 8.4.4 and I can't run it.
Report log:
Oct 12 17:53:25 localhost postgres[26997]: [1748-1] LOG: database
system was shut down at 2010-10-12 17:43:07 EEST
Oct 12 17:53:25 localhost postgres[26997]: [1749-1] DEBUG: checkpoint
record is at 0/7000020
Oct 12 17:53:25 localhost postgres[26997]: [1750-1] DEBUG: redo
record is at 0/7000020; shutdown TRUE
Oct 12 17:53:25 localhost postgres[26997]: [1751-1] DEBUG: next
transaction ID: 0/3162; next OID: 17842
Oct 12 17:53:25 localhost postgres[26997]: [1752-1] DEBUG: next
MultiXactId: 1; next MultiXactOffset: 0
Oct 12 17:53:25 localhost postgres[26997]: [1753-1] PANIC: could not
open file "pg_xlog/000000010000000000000007" (log file 0, segment 7):
???????????? ????????
Oct 12 17:53:25 localhost postgres[26995]: [1748-1] DEBUG: reaping
dead processes
Oct 12 17:53:25 localhost postgres[26995]: [1749-1] LOG: startup
process (PID 26997) was terminated by signal 6: Aborted
Oct 12 17:53:25 localhost postgres[26995]: [1750-1] LOG: aborting
startup due to startup process failure
Oct 12 17:53:25 localhost postgres[26995]: [1751-1] DEBUG:
shmem_exit(1): 3 callbacks to make
Oct 12 17:53:25 localhost postgres[26995]: [1752-1] DEBUG:
proc_exit(1): 3 callbacks to make
Oct 12 17:53:25 localhost postgres[26995]: [1753-1] DEBUG: exit(1)
Oct 12 17:53:25 localhost postgres[26995]: [1754-1] DEBUG:
shmem_exit(-1): 0 callbacks to make
Oct 12 17:53:25 localhost postgres[26995]: [1755-1] DEBUG:
proc_exit(-1): 0 callbacks to make
I hadn't this problem under previous version Postgresql 8.4.3.
I tried pg_resetxlog -f /var/lib/postgres/data, but it didn't resolve
this problem.
I tried reinit database but result is the same.
hi, you upgrade from 8.4.3 to 8.4.4,
do you have the file in $pgdate/pg_xlog/000000010000000000000007,
assuming pgdata in /var/lib/pgsql/data.
the database try to redo some transaction but don't have the log file.
have any backup prior upgrade?.
the logfile number is to small, this is not a production database, no?
Fernando Rodriguez
