Добрый день. Мне необходимо перенести таблицу из одной базы в другую на разных серверах.
На обоих серверах стоит PostgreSQL 9.2.
Всё делаю на линуксе через pgAdmin3.
Формирую бэкап
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
/opt/PostgreSQL/9.2/pgAdmin3/bin/pg_dump --host ip --port 5432 --username "postgres" --no-password --verbose --file "/home/pavelp/Документы/pl.backup" --table "public.p" "mydb"
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading extensions
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: finding extension members
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "p"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: creating TABLE p
pg_dump: restoring data for table "p"
pg_dump: dumping contents of table p
pg_dump: setting owner and privileges for TABLE p
pg_dump: setting owner and privileges for TABLE DATA p
Процесс вернул код выхода 0.
на другом сервере делаю ресторе
1.
2.
3.
4.
/opt/PostgreSQL/9.2/pgAdmin3/bin/pg_restore --host 192.168.1.124 --port 5432 --username "postgres" --dbname "sbit" --no-password --data-only --table p --schema public --verbose "/home/pavelp/Документы/pl.backup"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.
Процесс вернул код выхода 1.
Всё работало. Не понятно,что случилось? Настройки не менял.
вообще как правильно переносить таблицу с одной базы в другую?
