Thread: Unable to start pg service

Unable to start pg service

From
"Vladimir Leban"
Date:
Hello,
 
I'm curently in version 7.3
 
I know, this is an old version and It would be a good idea to migrate.
Before doing that, I would like to make a dump of my base. That's why I must running this service at any coast.
 
Thank's for your help !! :)
 

2006-06-19 10:31:55 LOG:  database system shutdown was interrupted at 2006-06-19

 10:23:06

2006-06-19 10:31:55 LOG:  checkpoint record is at 0/17B1FC0

2006-06-19 10:31:55 LOG:  redo record is at 0/17B1FC0; undo record is at 0/0; sh

utdown TRUE

2006-06-19 10:31:55 LOG:  next transaction id: 105375; next oid: 28662

2006-06-19 10:31:55 LOG:  database system was not properly shut down; automatic

recovery in progress

2006-06-19 10:31:55 LOG:  ReadRecord: invalid magic number 0000 in log file 0, s

egment 1, offset 8069120

2006-06-19 10:31:55 LOG:  redo is not required

2006-06-19 10:31:57 PANIC:  XLogWrite: write request 0/17B2000 is past end of lo

g 0/17B2000

2006-06-19 10:31:57 DEBUG:  reaping dead processes

2006-06-19 10:31:57 LOG:  startup process (pid 2304) was terminated by signal 6

2006-06-19 10:31:57 LOG:  aborting startup due to startup process failure

2006-06-19 10:31:57 DEBUG:  proc_exit(1)

2006-06-19 10:31:57 DEBUG:  shmem_exit(1)

IpcMemoryDetach: shmdt(0xd00000) failed: Invalid argument

2006-06-19 10:31:57 DEBUG:  exit(1)

 
 

Re: Unable to start pg service

From
Tom Lane
Date:
"Vladimir Leban" <vladimir.leban@docubase-systems.fr> writes:
> I'm curently in version 7.3

> 2006-06-19 10:31:57 PANIC:  XLogWrite: write request 0/17B2000 is past
> end of log 0/17B2000

Update to 7.3.latest --- IIRC we fixed that in 7.3.4.  You should be able
to update in-place to a newer 7.3.* postmaster without losing any data.

            regards, tom lane