Re: [GENERAL] postgres upgrade

2007-05-12 Thread Martijn van Oosterhout
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote: > I'm trying to upgrade from 8.1 to 8.2. > > Apparently the upgrade I just ran through installed a second database > on my server. > > I was hoping that the debian configuration would migrate this for me. > I recall there was once a t

Re: [GENERAL] postgres upgrade

2007-05-12 Thread Ray Stell
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote: > Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload > into 8.2? http://www.postgresql.org/docs/faqs.FAQ.html#item3.6 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Conta

postgres upgrade

2007-05-12 Thread Tom Allison
I'm trying to upgrade from 8.1 to 8.2. Apparently the upgrade I just ran through installed a second database on my server. I was hoping that the debian configuration would migrate this for me. I recall there was once a time when it would ask you about moving data from old to new databases.

Re: Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-25 Thread Oliver Elphick
On Thu, 2003-11-20 at 16:23, Monique Y. Herman wrote: > On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned: > > Hello, > > > > I have a database running on potato using postgres 6.5 that I'd like > > to upgrade to Woody running postgres 7.2. ... > I believe the install notes say, somewhere,

Re: Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-20 Thread Monique Y. Herman
On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned: > Hello, > > I have a database running on potato using postgres 6.5 that I'd like > to upgrade to Woody running postgres 7.2. > > The docs seem to imply that upgrading with this big a jump from 6.5 to > 7.2 is dangerous.even if I do i

Re: Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-20 Thread John M Flinchbaugh
On Wed, Nov 19, 2003 at 06:50:19PM -0800, Henry Hollenberg wrote: > The docs seem to imply that upgrading with this big a jump from > 6.5 to 7.2 is dangerous.even if I do it by hand like so: > > pg_dump mydatabase > dump.mydatabase > destroydb mydatabase > upgrade the database system to 7.2 >

BCP Postgres upgrade 6.5-->7.2

2003-11-19 Thread hgh
Hello, I have a database running on potato using postgres 6.5 that I'd like to upgrade to Woody running postgres 7.2. The docs seem to imply that upgrading with this big a jump from 6.5 to 7.2 is dangerous.even if I do it by hand like so: pg_dump mydatabase > dump.mydatabase destroydb myda

Best Current Pratice Postgres upgrade 6.5-->7.2

2003-11-19 Thread Henry Hollenberg
Hello, I have a database running on potato using postgres 6.5 that I'd like to upgrade to Woody running postgres 7.2. The docs seem to imply that upgrading with this big a jump from 6.5 to 7.2 is dangerous.even if I do it by hand like so: pg_dump mydatabase > dump.mydatabase destroydb mydata

Re: postgres upgrade failed.....

2002-12-10 Thread Rob Weir
On Thu, Dec 05, 2002 at 05:26:33PM +0100, Bruno Boettcher wrote: > Hello > > i got used to the automatic postgres upgrade... and stopped making > myself dumps before upgrading... :( > > and now i am stuck.. the automatic upgrade failed, and i don't know > how

postgres upgrade failed.....

2002-12-05 Thread Bruno Boettcher
Hello i got used to the automatic postgres upgrade... and stopped making myself dumps before upgrading... :( and now i am stuck.. the automatic upgrade failed, and i don't know how to get this back... i tried the migration file, but couldn't get something usable out of it...

Re: postgres upgrade for dummies? [solved]

2002-02-17 Thread Andreas Goesele
Andreas Goesele <[EMAIL PROTECTED]> writes: > "J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]> writes: > > > Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new > > authentication method "peer" which 6.5 doesn't understand and which 7.1's > > default configuration employs IIRC. > > Thi

Re: postgres upgrade for dummies?

2002-02-17 Thread Andreas Goesele
"J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]> writes: > Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new > authentication method "peer" which 6.5 doesn't understand and which 7.1's > default configuration employs IIRC. This helped. Thanks. But now I have a new problem: The encodin

Re: postgres upgrade for dummies?

2002-02-17 Thread Oliver Elphick
On Sun, 2002-02-17 at 14:20, J.H.M. Dassen (Ray) wrote: > On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote: > > So I did read README.Debian.migration.gz and then run postgresql-dump > > with the options in the README. This is what I got: > > > > Stopping and restarting the postmaster

Re: postgres upgrade for dummies?

2002-02-17 Thread J.H.M. Dassen \(Ray\)
On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote: > I now did a new try, again without any success. The automatic > upgrading process first looks promising but than ends with the > following error message: > You are now connected to database template1 as user user. > create database u

postgres upgrade for dummies?

2002-02-16 Thread Andreas Goesele
Hi, Short story: Is there an easy way to upgrade from postgresql 6.5 to 7.1? An easy to follow document explaining how to do it? Long story: Many tries, no success: I have a nicely working postgresql 6.5 on Debian woody. When I first upgraded to woody I too tried to upgrade to postgresql 7.1, bu

Postgres upgrade

1999-04-14 Thread Max
I'm trying to upgrade my version of postgres from 6.3 to 6.4 and following the instructions in /usr/doc/postgresql/README.Debian.migration.gz, I use the following command as user "postgres": $ which postgresql-dump /usr/lib/postgresql/bin/postgresql-dump $ postgresql-dump -t db.out -ucil The Postg