Re: Upgrade 7.2 to 7.3

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: James Williams <jw11(at)iprimus(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Upgrade 7.2 to 7.3
Date: 2003-08-09 15:35:51
Message-ID: 20030809153551.GE22927@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Aug 09, 2003 at 23:00:19 +1000,
James Williams <jw11(at)iprimus(dot)com(dot)au> wrote:
> A while ago, I played around a bit with PostgreSQL 7.2 and created a
> test database (think it was called mydb).
>
> Since then I've upgraded Linux and it also upgraded PostgreSQL to 7.3.
> Now I'm ready to start doing some proper stuff but I can't start the
> postmaster. It says I need to upgrade my database, but I don't care
> about the old database.
>
> Is there any way I can remove the old database and start working with 7.3?

You can delete the contents of the data directory and do an initdb.
You might want to save the config files before doing the delete so that
you can copy them back after the initdb. (Though I think the syntax
for the hba config file changed between 7.2 and 7.3, so it should need
to be tweaked in any case.)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Peter Childs 2003-08-09 16:16:47 Re: Auto_Increment
Previous Message Bruno Wolff III 2003-08-09 15:21:37 Re: Query about Boolean Data Type