Re: Correct pg_dumpall Syntax

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(at)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