Received: from slip1.raccoon.com (slip1.raccoon.com [165.90.135.16]) by hub.org (8.9.2/8.9.1) with ESMTP id TAA25111 for ; Mon, 15 Mar 1999 19:41:34 -0500 (EST) (envelope-from perdue@raccoon.com) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip1.raccoon.com (8.8.7/8.8.7) with SMTP id SAA03362; Mon, 15 Mar 1999 18:40:37 -0600 Message-ID: <001701be6f45$81d4dc30$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue" From: "Tim Perdue" To: "Bruce Momjian" , Subject: Re: [SQL] Re: [HACKERS] URGENT - Date: Mon, 15 Mar 1999 18:39:52 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I still cannot get pg_dump to work since I fixed the system yesterday. This is a real mess and I need to make sure I have a current backup. -I upgraded from 6.4 -> 6.4.2 and applied the 2GB patch -I did "initdb" from the postgres user account -I cannot get pg_dump to work: ------- [tim@db /]$ pg_dump db_domain > /fireball/pg_dumps/db_domain.dump pg_dump error in finding the template1 database ------- At this point, the postmaster dies and restarts. I think I'm getting to where I need some real help getting this thing to dump again. The database is up and running just fine - I just cannot dump. Any tips or advice is GREATLY needed and appreciated at this point. All I need is it to take a dump ;-) Tim tim@perdue.net -----Original Message----- From: Bruce Momjian To: tim@perdue.net Date: Monday, March 15, 1999 11:57 AM Subject: Re: [SQL] Re: [HACKERS] URGENT - >> >> >> >From 6.4 -> 6.4.2 >> >> The production database is working well, but pg_dump doesn't work. Now >> I'm worried that my database will corrupt again and I won't have it >> backed up. > >6.4 to 6.4.2 should work just fine, and the patch should not change >that. Are you saying the application of the patch caused the system to >be un-dumpable? Or perhaps was it the stopping of the postmaster. I >can work with you to get it dump-able if needed? > >-- > Bruce Momjian | http://www.op.net/~candle > maillist@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 >