Prompt do Post
04/11/2005
0
Galera, eu tenho a versão 7.2 do postgres, e queria restaurar uma base minha na versão post 8, porém, não achei o prompt pra utilizar os comandos....na versão 8 não existe? como eu restauro a base?
Cristianopintado
Curtir tópico
+ 0
Responder
Posts
04/11/2005
Bon Jovi
Que eu saiba vc deve ir pelo prompt do sistema operacional e usar o pg_restore. E se for caso use a ferramenta gráfica pgAdmin.
No WinNT:
No WinNT:
Microsoft Windows XP [versão 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\usuario>cd C:\Arquivos de programas\PostgreSQL\8.0\bin C:\Arquivos de programas\PostgreSQL\8.0\bin>pg_restore.exe --help pg_restore restores a PostgreSQL database from an archive created by pg_dump. Usage: pg_restore [OPTION]... [FILE] General options: -d, --dbname=NAME connect to database name -f, --file=FILENAME output file name -F, --format=c|t specify backup file format -i, --ignore-version proceed even when server version mismatches -l, --list print summarized TOC of the archive -v, --verbose verbose mode --help show this help, then exit --version output version information, then exit Options controlling the restore: -a, --data-only restore only the data, no schema -c, --clean clean (drop) schema prior to create -C, --create create the target database -I, --index=NAME restore named index -L, --use-list=FILENAME use specified table of contents for ordering output from this file -O, --no-owner skip restoration of object ownership -P, --function=NAME(args) restore named function -s, --schema-only restore only the schema, no data -S, --superuser=NAME specify the superuser user name to use for disabling triggers -t, --table=NAME restore named table -T, --trigger=NAME restore named trigger -x, --no-privileges skip restoration of access privileges (grant/revoke) -X disable-triggers, --disable-triggers disable triggers during data-only restore -X use-set-session-authorization, --use-set-session-authorization use SESSION AUTHORIZATION commands instead of OWNER TO commands Connection options: -h, --host=HOSTNAME database server host or socket directory -p, --port=PORT database server port number -U, --username=NAME connect as specified database user -W, --password force password prompt (should happen automatically) -e, --exit-on-error exit on error, default is to continue If no input file name is supplied, then standard input is used. Report bugs to <pgsql-bugs@postgresql.org>. C:\Arquivos de programas\PostgreSQL\8.0\bin>
Responder
Clique aqui para fazer login e interagir na Comunidade :)