Re: [BUGS] pg_dumpall
От | Bruce Momjian |
---|---|
Тема | Re: [BUGS] pg_dumpall |
Дата | |
Msg-id | 200003072309.SAA27170@candle.pha.pa.us обсуждение исходный текст |
Ответ на | pg_dumpall ("Kardos, Dr. Andreas" <kardos@repas-aeg.de>) |
Список | pgsql-bugs |
[Charset iso-8859-1 unsupported, filtering to ASCII...] > The pg_dumpall script is not compatible with 7.0 psql and createdb. > > 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`" Fixed. > > 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 Thanks. I changed it to run pg_encoding and see if it existed. Patch applied. > > Unfortunately it is not sufficient to use > > createdb --help|grep encoding > > because the word "encoding" is always present in the usage message now. > > 3. QNX4 only: The double quotes in > > POSTGRES_USER="`echo \" \ > > etc. must not be escaped with a backslash. Unfortunately I haven't found a > simple solution working on all platforms. Thats why I am not sending a > patch. Wow, that is pretty broken if it can't handle that. -- 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
В списке pgsql-bugs по дате отправления: