Re: [GENERAL] pg_dumpall problem when roles have default schemas

2008-09-17 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > I've run into a problem while migrating an existing 8.2.7 data base to a > new server running 8.3.3 (although I think the version numbers may not > matter -- I think I've seen this problem in the past and just lived with > it since so much of Postgresql is so great!). >

[GENERAL] pg_dumpall problem when roles have default schemas

2008-09-16 Thread btober
I've run into a problem while migrating an existing 8.2.7 data base to a new server running 8.3.3 (although I think the version numbers may not matter -- I think I've seen this problem in the past and just lived with it since so much of Postgresql is so great!). The problem stems from the fact th

[GENERAL] pg_dumpall problem when roles have default schemas

2008-09-12 Thread btober
I've run into a problem while migrating an existing 8.2.7 data base to a new server running 8.3.3 (although I think the version numbers may not matter -- I think I've seen this problem in the past and just lived with it since so much of Postgresql is so great!). The problem stems from the fac

Re: [GENERAL] pg_dumpall problem when roles have default schemas

2008-08-31 Thread btober
Tom Lane wrote: > [EMAIL PROTECTED] writes: >> Thus, when piping the output (from legacy host 192.168.2.2) to >> populate the newly initialized cluster, by way of running (on the new >> host 192.168.2.3) >> pg_dumpall -h 192.168.2.2|psql >> an error occurs in that first section when the s

Re: [GENERAL] pg_dumpall problem when roles have default schemas

2008-08-29 Thread btober
Tom Lane wrote: > [EMAIL PROTECTED] writes: >> Thus, when piping the output (from legacy host 192.168.2.2) to >> populate the newly initialized cluster, by way of running (on the new >> host 192.168.2.3) >> pg_dumpall -h 192.168.2.2|psql >> an error occurs in that first sectio

Re: [GENERAL] pg_dumpall problem when roles have default schemas

2008-08-28 Thread Tom Lane
[EMAIL PROTECTED] writes: > Thus, when piping the output (from legacy host 192.168.2.2) to > populate the newly initialized cluster, by way of running (on the new > host 192.168.2.3) > pg_dumpall -h 192.168.2.2|psql > an error occurs in that first section when the script attempts to > se

[GENERAL] pg_dumpall problem when roles have default schemas

2008-08-28 Thread btober
I've run into a problem while migrating an existing 8.2.7 data base to a new server running 8.3.3 (although I think the version numbers may not matter -- I think I've seen this problem in the past and just lived with it since so much of Postgresql is so great!). The problem stems from the f

Re: [GENERAL] Pg_dumpall problem

2003-11-20 Thread Matthew Lunnon
  - Original Message - From: Patrick Hatcher To: [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 12:34 AM Subject: [GENERAL] Pg_dumpall problem Did a pg_dumpall from my production database (7.3.2) and I tried to restoreto my Dev database (7.4