Hali! Hónapok óta használom mentésre az alábbi parancsot: pg_dumpall -c -o -v -U postgres -h localhost > /dumpall.sql
ám most egyszercsak nem fut le: ... pg_dumpall: executing SELECT usename FROM pg_shadow WHERE usesysid = 18378; pg_dumpall: executing SELECT datname, coalesce(usename, (select usename from pg_shadow where usesysid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datistemplate, datpath, datacl FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn ORDER BY 1 pg_dumpall: query failed: ERROR: column "datpath" does not exist pg_dumpall: query was: SELECT datname, coalesce(usename, (select usename from pg_shadow where usesysid=(select datdba from pg_database where datname='template0'))), pg_encoding_to_char(d.encoding), datistemplate, datpath, datacl FROM pg_database d LEFT JOIN pg_shadow u ON (datdba = usesysid) WHERE datallowconn ORDER BY 1 Meg tudná valaki mondani, hogy mi történt...? És hogyan lehetne a problémát orvosolni? Előre is köszi, kjt McAfee SCM 4.1 által ellenőrizve!
_________________________________________________ linux lista - [email protected] http://mlf2.linux.rulez.org/mailman/listinfo/linux
