Thread: About PostgreSQL 8.0
Hi. I've started to learn SQL about 6 months ago, and now I'd upgraded PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the README file (how stupid I was) and there were instructions to how to do it; the upgrade I mean. Now I'm wondering, server is not running because fileformat or something like that is wrong - I did the upgrade wrongly. I do not have any relevant data in the Postgre database, so I don't need to backup it (which was one point of the upgrading). How I must have to proceed that I can start the Postgre server? Do I use the initdb command and if I do, how I do it with default locations? I'm very new on PostgreSQL and do not have much experience on SQL. I'm running on FC3. I hope that you understand what my problem is. I will explain more, if you don't. Plz, help me. -- Jarkko Elfving <jarelf@ebaana.net>
On Sun, 23 Jan 2005 00:13:08 +0200, Jarkko Elfving <jarelf@ebaana.net> wrote: > Hi. > > I've started to learn SQL about 6 months ago, and now I'd upgraded > PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the > README file (how stupid I was) and there were instructions to how to do > it; the upgrade I mean. Now I'm wondering, server is not running because > fileformat or something like that is wrong - I did the upgrade wrongly. > I do not have any relevant data in the Postgre database, so I don't need > to backup it (which was one point of the upgrading). How I must have to > proceed that I can start the Postgre server? Do I use the initdb command > and if I do, how I do it with default locations? I'm very new on > PostgreSQL and do not have much experience on SQL. I'm running on FC3. > > I hope that you understand what my problem is. I will explain more, if > you don't. If you don't care about losing your data, you can fix this by shutting down postgresql, deleting the contents of /var/lib/pgsql/data and then starting postgresql again. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
On Sun, Jan 23, 2005 at 12:13:08AM +0200, Jarkko Elfving wrote: > I've started to learn SQL about 6 months ago, and now I'd upgraded > PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the > README file (how stupid I was) and there were instructions to how to do > it; the upgrade I mean. Now I'm wondering, server is not running because > fileformat or something like that is wrong - I did the upgrade wrongly. I'd guess that you didn't do an initdb and tried to run an 8.0 server with a 7.4 cluster. See the "Installation Instructions" chapter of the documentation, in particular the "If You Are Upgrading" section; see also "Migration Between Releases" in the "Backup and Restore" chapter and the documentation for initdb: http://www.postgresql.org/docs/8.0/static/installation.html http://www.postgresql.org/docs/8.0/static/migration.html http://www.postgresql.org/docs/8.0/static/app-initdb.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/