[GENERAL] invalid primary checkpoint record
dear all we have the following issues and cannot start the postgresql server: postgresql 8.0.5 redhat EL WS4 U3 the computer was shutdown properly. then the user restarted the computer, in the middle of rebooting, he switched off the power button on the wall. after that we cannot start the database server any more. the following is the log. please help. thanks cheng LOG: database system shutdown was interrupted at 2006-06-26 10:33:11 BST LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0001" (log file 0, segment 0): No such file or directory LOG: invalid primary checkpoint record LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0001" (log file 0, segment 0): No such file or directory LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 29959) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down LOG: database system shutdown was interrupted at 2006-06-26 10:33:11 BST LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0001" (log file 0, segment 0): No such file or directory LOG: invalid primary checkpoint record LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0001" (log file 0, segment 0): No such file or directory LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 30015) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down Euro-China Medlink ltd http://www.euro-china.co.uk ___ Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] postgresql training course, please recommend
dear all can any one recommend a good postgresql training course in the UK. thanks cheng = Best wishes Z C Wang ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself http://uk.messenger.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] pg_dumpall and large objects
hi, the man page says pg_dump cannot dump "large objects". can some one help me on what does this realy mean? how large is large? if we have some icons can we still use pg_dumpall to backup the db? also large objects do not include large strings, right? thanks cheng = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] pg_class could not be found
we are running redhat version 7.3.6-1 for EL AS3. most of our db can be analyised by your tool. bot only one is not. if we dump this one, init a db, then import with template1, things are ok and your tool can be used against this new db. any suggestions? please cheng --- Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > Maybe, but it doesn't work in some common cases > apparently, I just > don't have anything setup on my machine to test > everything out. I don't > even know which version you're running. > > Like I said, it's needs a lot of TLC. > > On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng > wang wrote: > > hi, > > i can see the file 1259 is there and the db > apparently > > working normal and can be started/stopped OK. > > > > if your tool cannot work on this set of db, does > it > > mean that the db is problematic? i am realy > worried. > > > > thanks in advance for advice. > > > > cheng > -- > Martijn van Oosterhout <[EMAIL PROTECTED]> > http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% > perspiration. A patent is a > > tool for doing 5% of the work and then sitting > around waiting for someone > > else to do the other 95% so you can sue them. > > ATTACHMENT part 2 application/pgp-signature = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] pg_class could not be found
hi, i can see the file 1259 is there and the db apparently working normal and can be started/stopped OK. if your tool cannot work on this set of db, does it mean that the db is problematic? i am realy worried. thanks in advance for advice. cheng --- Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > Sigh. Sorry, that tool really needs some TLC to get > it working across > all the versions of PostgreSQL I don't have access > to. It's looking for > pg_class and is assuming it's OID 1259 and trying to > open that file. > Evidently it's failing. > > You'd need to indicate the version of the database, > maybe strace it to > see where it's going wrong. > > Hope this helps, > > On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng > wang wrote: > > hi, > > > > has any one used Martijn van Oosterhout's > PostgreSQL > > table checker and dumper (pgfsck, at > > http://svana.org/kleptog/pgsql/pgfsck.html)? > > > > i ran this again my database and it gives this > error: > > > > Couldn't find relation pg_class(1259) > > > > does any one know what this is about > > > > cheng > > > > > > = > > Best wishes > > Z C Wang > > > > > > > > > > > > > > > Yahoo! Messenger - Communicate instantly..."Ping" > > your friends today! Download Messenger Now > > http://uk.messenger.yahoo.com/download/index.html > > > > ---(end of > broadcast)--- > > TIP 3: if posting/reading through Usenet, please > send an appropriate > > subscribe-nomail command to > [EMAIL PROTECTED] so that your > > message can get through to the mailing list > cleanly > > -- > Martijn van Oosterhout <[EMAIL PROTECTED]> > http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% > perspiration. A patent is a > > tool for doing 5% of the work and then sitting > around waiting for someone > > else to do the other 95% so you can sue them. > > ATTACHMENT part 2 application/pgp-signature = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] after using pg_resetxlog, db lost
it may be not that bad - thanks to Martijn van Oosterhout's tool, we can recover all the tables apart from three which type could not be recognised. this was a test db. but i have learnt a lot and also have a feel of the seriousness if the real thing broken. Thanks to every one and i hope that no is caught in this situation. cheng --- Tom Lane <[EMAIL PROTECTED]> wrote: > > what is the indication? > > I think you're out of luck :-(. Judging from your > messages over the > past few days, your disk drive committed multiple > major corruptions > of the data it was entrusted with. I hope you have > a reasonably > recent backup to go back to. > > regards, tom lane = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] pg_xlog
can any one tell me about the meaning of pg_xlog/0F1 pg_xlog/0F2 pg_xlog/0F3 pg_xlog/0F4 .. pg_xlog/0F8 is the pg_xlog/000 missing thanks chneg = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] pg_class could not be found
Thanks Martijn if i dump the db (pg_dumpall), the delete the pgsql dir, start a new pgsql dir, the import with template1, this error gone and the db can be checked by your excelent tool. also what is --Table arraytype.. Unknown type thanks --- Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > Sigh. Sorry, that tool really needs some TLC to get > it working across > all the versions of PostgreSQL I don't have access > to. It's looking for > pg_class and is assuming it's OID 1259 and trying to > open that file. > Evidently it's failing. > > You'd need to indicate the version of the database, > maybe strace it to > see where it's going wrong. > > Hope this helps, > > On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng > wang wrote: > > hi, > > > > has any one used Martijn van Oosterhout's > PostgreSQL > > table checker and dumper (pgfsck, at > > http://svana.org/kleptog/pgsql/pgfsck.html)? > > > > i ran this again my database and it gives this > error: > > > > Couldn't find relation pg_class(1259) > > > > does any one know what this is about > > > > cheng > > > > > > = > > Best wishes > > Z C Wang > > > > > > > > > > > > > > > Yahoo! Messenger - Communicate instantly..."Ping" > > your friends today! Download Messenger Now > > http://uk.messenger.yahoo.com/download/index.html > > > > ---(end of > broadcast)--- > > TIP 3: if posting/reading through Usenet, please > send an appropriate > > subscribe-nomail command to > [EMAIL PROTECTED] so that your > > message can get through to the mailing list > cleanly > > -- > Martijn van Oosterhout <[EMAIL PROTECTED]> > http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% > perspiration. A patent is a > > tool for doing 5% of the work and then sitting > around waiting for someone > > else to do the other 95% so you can sue them. > > ATTACHMENT part 2 application/pgp-signature = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] pg_class could not be found
hi, has any one used Martijn van Oosterhout's PostgreSQL table checker and dumper (pgfsck, at http://svana.org/kleptog/pgsql/pgfsck.html)? i ran this again my database and it gives this error: Couldn't find relation pg_class(1259) does any one know what this is about cheng = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] after using pg_resetxlog, db lost
sorry for the late reply in case it is useful to any one. the db server uses san to store the data. the update is only to the bios of the fibre card. if this is wrong, many other files should also go wrong, which is not the case. cheng --- Tom Lane <[EMAIL PROTECTED]> wrote: > =?iso-8859-1?q?zhicheng=20wang?= > <[EMAIL PROTECTED]> writes: > > Jun 1 10:43:55 linux708 postgres[5537]: [30] LOG: > database system shutdown was interrupted at > 2004-05-28 16:32:08 BST > > Jun 1 10:43:55 linux708 postgres[5537]: [31] LOG: > open of > /var/lib/pgsql/data/pg_xlog/ (log > file 0, segment 0) failed: No such file or directory > > Jun 1 10:43:55 linux708 postgres[5537]: [32] LOG: > invalid primary checkpoint record > > Jun 1 10:43:55 linux708 postgres[5537]: [33] LOG: > open of > /var/lib/pgsql/data/pg_xlog/ (log > file 0, segment 0) failed: No such file or directory > > Jun 1 10:43:55 linux708 postgres[5537]: [34] LOG: > invalid secondary checkpoint record > > Jun 1 10:43:55 linux708 postgres[5537]: [35] > PANIC: unable to locate a valid checkpoint record > > Hm, was this a very new Postgres installation? The > links to log file > 0/0 suggest that it was so new as to not yet have > accumulated 16Mb worth > of WAL traffic ... which is not a lot of traffic. > > If the links are accurate then what must have > happened is that your disk > subsystem lost the physical xlog file. > > If the links are not accurate then this suggests > corruption of the > pg_control file (i.e., overwriting those fields with > zeroes). I find > this idea a bit improbable, though, because the > pg_control file has > a CRC64 checksum. It seems very unlikely that > corruption of the > pg_control file wouldn't have been noticed and > complained of. > > In any case, it seems that your upgrade to new disk > hardware did not go > as smoothly as you thought. I'd be pretty surprised > if the Postgres > files are the only ones that got corrupted --- you'd > better look around > and find out what else is broken :-( > > regards, tom lane = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] after using pg_resetxlog, db lost
Hi, the /var/log/pgsql is empty but on this message log, what is "rhdb: ^[[60G["? i do not see this before thanks cheng --- Richard Huxton <[EMAIL PROTECTED]> wrote: > zhicheng wang wrote: > > Hi Richard Huxton > > > > below is the rhdb part of the shutdown log > > > > any indications for the failed restart? > > > > thanks > > cheng > > > > May 28 15:43:37 sanlinux rhdb: Stopping PostgreSQL > - > > Red Hat Edition service: > > May 28 15:43:37 sanlinux su(pam_unix)[12400]: > session > > opened for user postgres by (uid=0) > > May 28 15:43:40 sanlinux su(pam_unix)[12400]: > session > > closed for user postgres > > May 28 15:43:40 sanlinux rhdb: ^[[60G[ > > May 28 15:43:40 sanlinux rhdb: > > May 28 15:43:40 sanlinux rc: Stopping rhdb: > succeeded > > Not here - what do the postgresql logs show? > > -- >Richard Huxton >Archonet Ltd > > ---(end of > broadcast)--- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] after using pg_resetxlog, db lost
Hi Richard Huxton below is the rhdb part of the shutdown log any indications for the failed restart? thanks cheng May 28 15:43:37 sanlinux rhdb: Stopping PostgreSQL - Red Hat Edition service: May 28 15:43:37 sanlinux su(pam_unix)[12400]: session opened for user postgres by (uid=0) May 28 15:43:40 sanlinux su(pam_unix)[12400]: session closed for user postgres May 28 15:43:40 sanlinux rhdb: ^[[60G[ May 28 15:43:40 sanlinux rhdb: May 28 15:43:40 sanlinux rc: Stopping rhdb: succeeded = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] after using pg_resetxlog, db lost
Dear Richard it was not a crash. we issued poweroff command, then we used a dos floppy to upgrade bios on the fibrecard. then when we reboot into the redhat AS3, the rhdb could not start. the log is attached. after using pg_resetxlog, we cannot see our db, only template0/1 listed by psql -l please help cheng --- Richard Huxton <[EMAIL PROTECTED]> wrote: > zhicheng wang wrote: > > dear all > > after we shutdown the rh_postgres-server 7.3.6, > rhdb > > could not start. we tried > > > > pg_resetxlog -f PGDATA > > > > then the server can be started, but only template0 > and > > template1 db available. > > > > our database not listed. > > Was there a crash? > What do your logs say? > How much disk space does your /data/base directory > use and is that > enough for your data? > Do you have your backups available? > > -- >Richard Huxton >Archonet Ltd = Best wishes Z C Wang Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html rhdb.log Description: rhdb.log ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] after using pg_resetxlog, db lost
dear all after we shutdown the rh_postgres-server 7.3.6, rhdb could not start. we tried pg_resetxlog -f PGDATA then the server can be started, but only template0 and template1 db available. our database not listed. please any help thanks cheng Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
