Senhores, boa noite!
Fiz o seguinte teste de restauração de backup no PostgreSQL sem obter êxito:
1)Realizei um backup de uma tabela do meu sistema usando o comando a seguir:
C:\Program Files\pgAdmin III\1.18\pg_dump.exe --host 192.168.1.15 --port
5432 --username "dba" --no-password --format custom --encoding UTF8 --
verbose --file "C:\tagn.backup" --table "dba.tagn" "grpprd"
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 event triggers
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 "tagn"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "tagn"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "tagn"
pg_dump: reading triggers
pg_dump: reading triggers for table "tagn"
pg_dump: reading rewrite rules
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = off
pg_dump: dumping contents of table tagn
Process returned exit code 0.
2)Criei um novo banco de dados, usando enconding UTF8 com o seguinte
comando:
CREATE DATABASE teste
WITH ENCODING='UTF8'
OWNER=seguranca
TEMPLATE=template0
LC_COLLATE='C'
LC_CTYPE='C'
CONNECTION LIMIT=-1;
REVOKE ALL ON DATABASE teste FROM public;
GRANT ALL ON DATABASE teste TO public;
3) Neste banco, criei um schema e uma tabela com a mesma definição da
tabela de origem do backup e tentei restaurá-lo sem sucesso:
C:\Program Files\pgAdmin III\1.18\pg_restore.exe --host 192.168.1.11 --port
5432 --username "seguranca" --dbname "teste" --no-password --data-only --
table tagn --schema ta --verbose "C:\tagn.backup"
pg_restore: connecting to database for restore
Process returned exit code 0.
O pg_restore informa que conectou no banco, mas nada é restaurado...
Ao acompanhar o log do banco, nenhum registro é observado.
Alguém tem alguma sugestão?
Grato!
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
