Re: [ADMIN] pg_dump max file size exceeded
On Wed, 20 Mar 2002, Rolf Luettecke wrote: RL Fred Moyer [EMAIL PROTECTED] writes: RL ran time pg_dump -c --verbose database datafile.psql from the command RL line and got a file size limit exceeded. datafile.psql stopped at 2 gigs. RL any ideas how to exceed that limit? RL RL Workaround: Pipe output to gzip/bzip2, if compressed file size does not RL reach 2 GB limit, or cut output into 2GB-pieces. ... and if it's still does not fit, pipe it further into split(1) ;-) [though I don't know whether this utility exists in standard Linux distrib. In BSDs it does.] Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN] *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- [EMAIL PROTECTED] *** ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[ADMIN] unable to locate a valid checkpoint
Hi to all, I'm quite new for this list, but I've already a big problem. After a shutdown, the postmaster doesn't restart due to a checkpoint error. The data of the DB is ... ehm important... so, how can I recover my installation? message: ## FindExec: found /usr/bin/postmaster using argv[0] 2002-03-22 13:42:46 [6002] DEBUG: database system was shut down at 2002-03-22 11:46:11 CET 2002-03-22 13:42:46 [6002] DEBUG: ReadRecord: invalid resource manager id 157 at (0, 561372168) 2002-03-22 13:42:46 [6002] DEBUG: Invalid primary checkPoint record 2002-03-22 13:42:46 [6002] DEBUG: Invalid RMID in secondary checkPoint record 2002-03-22 13:42:46 [6002] FATAL 2: Unable to locate a valid CheckPoint record 2002-03-22 13:42:46 [6002] DEBUG: proc_exit(2) 2002-03-22 13:42:46 [6002] DEBUG: shmem_exit(2) 2002-03-22 13:42:46 [6002] DEBUG: exit(2) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: Startup proc 6002 exited wit ## TIA, Auri ---(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: [ADMIN] unable to locate a valid checkpoint
Auri Mason [EMAIL PROTECTED] writes: I'm quite new for this list, but I've already a big problem. After a shutdown, the postmaster doesn't restart due to a checkpoint error. Shutdown? Exactly what happened there? It certainly doesn't look like you had a clean shutdown. At this point I think your only hope is contrib/pg_resetxlog, but that's a very blunt instrument. It'd be nice to understand what went wrong. regards, tom lane ---(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
