https://forum.postgresql.org.pl/viewtopic.php?id=1909 Wed, 27 Nov 2013 21:09:57 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=4842#p4842 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]]> Wed, 27 Nov 2013 21:09:57 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4842#p4842 https://forum.postgresql.org.pl/viewtopic.php?pid=4828#p4828 Mon, 25 Nov 2013 09:31:41 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4828#p4828 https://forum.postgresql.org.pl/viewtopic.php?pid=4827#p4827 e:\dane\b.sql]]> Mon, 25 Nov 2013 08:43:28 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4827#p4827 https://forum.postgresql.org.pl/viewtopic.php?pid=4821#p4821 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 .... :(]]> Mon, 25 Nov 2013 05:37:55 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4821#p4821 https://forum.postgresql.org.pl/viewtopic.php?pid=4812#p4812 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]]> Fri, 22 Nov 2013 22:07:08 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4812#p4812 https://forum.postgresql.org.pl/viewtopic.php?pid=4811#p4811 Fri, 22 Nov 2013 11:01:15 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4811#p4811