2013-11-27T21:09:57Z PunBB https://forum.postgresql.org.pl/viewtopic.php?id=1909 c:\backup.sql 2. 2. w pliku backupu zmieniłem polecenie CREATE DATABASE na: CREATE DATABASE test_1250 WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Polish_Poland.1250' LC_CTYPE = 'Polish_Poland.1250'; ALTER DATABASE test_1250 OWNER TO postgres; \connect test_1250 3.psql --file=e:\dane\Bea\b.sql postgres postgres I mam nadzieję, że wszystko będzie OK]]> https://forum.postgresql.org.pl/profile.php?id=627 2013-11-27T21:09:57Z https://forum.postgresql.org.pl/viewtopic.php?pid=4842#p4842 https://forum.postgresql.org.pl/profile.php?id=1641 2013-11-25T09:31:41Z https://forum.postgresql.org.pl/viewtopic.php?pid=4828#p4828 e:\dane\b.sql]]> https://forum.postgresql.org.pl/profile.php?id=627 2013-11-25T08:43:28Z https://forum.postgresql.org.pl/viewtopic.php?pid=4827#p4827 pg_dump --encoding=WIN1250 --username=postgres --cr eate -W test >c:\backup.sql Password: pg_dump: Dumping the contents of table "users" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: character with byte sequence 0xc2 0x 88 in encoding "UTF8" has no equivalent in encoding "WIN1250" pg_dump: The command was: COPY .... :(]]> https://forum.postgresql.org.pl/profile.php?id=1641 2013-11-25T05:37:55Z https://forum.postgresql.org.pl/viewtopic.php?pid=4821#p4821 e:\dane\bea\b.sql 2. w pliku backupu zmieniłem polecenie CREATE DATABASE na: CREATE DATABASE test_1250 WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Polish_Poland.1250' LC_CTYPE = 'Polish_Poland.1250'; ALTER DATABASE test_1250 OWNER TO postgres; \connect test_1250 3. Wykonałem backup za pomocą polecenia: psql --file=e:\dane\Bea\b.sql postgres postgres I wszystko się wykonało]]> https://forum.postgresql.org.pl/profile.php?id=627 2013-11-22T22:07:08Z https://forum.postgresql.org.pl/viewtopic.php?pid=4812#p4812 https://forum.postgresql.org.pl/profile.php?id=1641 2013-11-22T11:01:15Z https://forum.postgresql.org.pl/viewtopic.php?pid=4811#p4811