Home > mailing lists

Thread: Unable to start pg service

Unable to start pg service

From

"Vladimir Leban"

Date:

22 June 2006, 05:58:55

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:

22 June 2006, 15:49:41

"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