pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [SQL] Re: [HACKERS] URGENT -
2+ messages / 2 participants
[nested] [flat]

* Re: [SQL] Re: [HACKERS] URGENT -
@ 1999-03-16 00:39 Tim Perdue <perdue@raccoon.com>
  1999-03-16 01:51 ` Re: [SQL] Re: [HACKERS] URGENT - Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Tim Perdue @ 1999-03-16 00:39 UTC (permalink / raw)
  To: Bruce Momjian <maillist@candle.pha.pa.us>; pgsql-sql@hub.org

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 <maillist@candle.pha.pa.us>
To: tim@perdue.net <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
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Re: [HACKERS] URGENT -
  1999-03-16 00:39 Re: [SQL] Re: [HACKERS] URGENT - Tim Perdue <perdue@raccoon.com>
@ 1999-03-16 01:51 ` Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 1999-03-16 01:51 UTC (permalink / raw)
  To: perdue@raccoon.com; +Cc: pgsql-sql@hub.org

Call me at my signature phone number.


[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 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 <maillist@candle.pha.pa.us>
> To: tim@perdue.net <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
> >
> 
> 


-- 
  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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-03-16 01:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-16 00:39 Re: [SQL] Re: [HACKERS] URGENT - Tim Perdue <perdue@raccoon.com>
1999-03-16 01:51 ` Bruce Momjian <maillist@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox