Olá, Faça assim: psql nome_do_banco -U usuario (postgres) -f arquivo.backup
[]s 2009/1/15 Paulo Marcelo <[email protected]>: > estou tentando assim: > > locagdo como root > psql relacionamentos -f /relacionamentos.backup > > porém tá dando este mensagem: psql: FATAL: Ident authentication failed for > user "root" > > Paulo Marcelo > > > 2009/1/15 Rafael <[email protected]> >> >> uehue... >> >> Então, se estiver usando um sistema unix like: >> >> $ psql -f /caminho/arquivo.sql >> ou como disse o Jota, dentro da console: >> \i /caminho/arquivo.sql >> >> Se tiver usando Windows: >> - formate seu micro e instale linux :) >> >> Abraço. >> >> >> 2009/1/15 joao junior <[email protected]> >>> >>> e se tiver usando unix like >>> >>> psql -........ < arquivo.backup >>> >>> On Thu, 2009-01-15 at 09:44 -0200, Jota wrote: >>> > Olá, >>> > >>> > Você pode fazer também: >>> > >>> > psql nome_do_banco >>> > >>> > \i arquivo.backup >>> > >>> > []s >>> > >>> > 2009/1/15 Rafael <[email protected]>: >>> > > psql banco -f /home/base.backup >>> > > >>> > > >>> > > Abraço. >>> > > >>> > > 2009/1/15 Paulo Marcelo <[email protected]> >>> > >> >>> > >> Bom dia a todos, >>> > >> >>> > >> >>> > >> Fiz um backup de um banco de dados que estava em um >>> > >> postgres >>> > >> via pgadmin e na interface gráfica do pgadmin aconselha que se >>> > >> acrescente a >>> > >> extensão .backup, no pg admin não encontro a opção de restore, como >>> > >> poderia >>> > >> fazer esta reatauração via psql? >>> > >> >>> > >> Paulo Marcelo >>> > >> >>> > >> _______________________________________________ >>> > >> pgbr-geral mailing list >>> > >> [email protected] >>> > >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> > >> >>> > > >>> > > >>> > > >>> > > -- >>> > > Rafael Bozzetti - linuxuser: 418660 >>> > > -------------------------------------------------- >>> > > OpenS - WWW.OPENS.COM.BR >>> > > >>> > > >>> > > >>> > > _______________________________________________ >>> > > pgbr-geral mailing list >>> > > [email protected] >>> > > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> > > >>> > > >>> > >>> > >>> > >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> [email protected] >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> >> >> -- >> Rafael Bozzetti - linuxuser: 418660 >> -------------------------------------------------- >> OpenS - WWW.OPENS.COM.BR >> >> >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- João Paulo www.dextra.com.br/postgres PostgreSQL _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
