Re: [BUGS] pg_dumpall

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> Kardos, Dr. Andreas writes:
>
> > The pg_dumpall script is not compatible with 7.0 psql and createdb.
>
> Darn me! I'll look into this. Some of the stuff in pg_dumpall can be
> solved more elegantly by now.
>
> > 1. pgsql -l delivers a different output (Owner instead of User ID).
> > Therefore in the following command "usesysid" has to be replaced by
> > "usename":
> >
> >  POSTGRES_USER="`echo \" \
> >   select usename \
> >   from pg_shadow \
> >   where usesysid = $DBUSERID; \" | \
> >   psql -A -q -t template1`"
>
> Huh? Doesn't it look like that now?

He wants it to be usename.

>
>
> > 2. createdb -help in the following line tries to connect the host "elp".
> >
> >  if createdb -help|grep encoding >/dev/null
> >  then
> >   echo "create database $DATABASE with encoding='`pg_encoding $ENCODING`';"
> >  else
> >   echo "create database $DATABASE;"
> >  fi
>
> I'd be inclined to say that you can leave off the encoding phrase if the
> encoding is 'SQL_ASCII' (or 0). That is always the case if you don't use
> multibyte.

I fixed that.  pg_encoding is only installed if multibyte is enabled.

>
>
> > 3. QNX4 only: The double quotes in
> >
> >  POSTGRES_USER="`echo \" \
> >
> > etc. must not be escaped with a backslash.
>
> Technically, it should just work without them (the backslash, that is).
> Then again, I'm not the greatest portable shell programmer.
>
> I'll see what I can do.

His end sounds pretty broken. May not be worth a fix.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026