Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] pg_dumpall

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Kardos, Dr(dot) Andreas" <kardos(at)repas-aeg(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] pg_dumpall
Date: 2000-03-04 17:05:23
Message-ID: Pine.LNX.4.21.0003040345530.489-100000@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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?

> 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

> 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.

Peter Eisentraut                  Sernanders väg 10:115
peter_e(at)gmx(dot)net                   75262 Uppsala            Sweden

In response to

  • pg_dumpall at 2000-03-03 15:06:45 from Kardos, Dr. Andreas


pgsql-bugs by date

Next:From: Peter EisentrautDate: 2000-03-04 17:05:54
Subject: Re: [BUGS] grant/revoke bug with delete/update
Previous:From: Peter EisentrautDate: 2000-03-04 17:05:10
Subject: Re: [BUGS] Can't find a default operator class for type 1296.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group