On Wed, 2008-06-18 at 10:23 -0700, Rich Shepard wrote: > On Wed, 18 Jun 2008, Joshua D. Drake wrote: > > Then you can reinitialize a new cluster with initdb here: > > /var/lib/pgsql/data (you will have to remove the old one) > > As user postgres, I cleaned out /var/lib/pgsql/data/* and re-initialized. > I had to specify -E UTF8 because 8.3.3 is not finding en_US as a valid > locale coding. > You need to remove the directory, not the files underneath then: initdb -E UTF8 -D /var/lib/pgsql/data > > Then restore as normal using psql -U postgres < mydatabase.sql > Then pg_ctl -D /var/lib/pgsql/data and try restore. > Can't get here. > > As user postgres, I shut down the 8.1.13 process. However, I cannot start > the 8.3.3 daemon running. I tried as user postgres with the pg_ctl command, > and as root running the formerly-working '/etc/rc.d/rc.postgresql start' > command. What I see with the latter is: > > [root@salmo /etc/rc.d]# ./rc.postgresql start Ignore all slackware implementation for the moment. Let's get your data up and running, then we can worry about administrativia. Joshua D. Drake