Re: Backup and restore

--===============5702553115689939539==
Content-Type: multipart/alternative; boundary="001a1145bc5075d7a90569a5b0ef"

--001a1145bc5075d7a90569a5b0ef
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Ok muito obrigado a todos. Realmente tere que ver na m=C3=A3o mesmo.

Em qui, 12 de abr de 2018 09:04, Arlindo Neto <[email protected]> escreveu=
:

> Minha opini=C3=A3o: se o seu dump for data-only, voc=C3=AA vai ter que re=
criar os
> schemas, views etc na m=C3=A3o e adapta-los ou seus dados... Resumidament=
e, boa
> sorte. Vai ser trabalhoso, mas n=C3=A3o =C3=A9 imposs=C3=ADvel.
>
> Abra=C3=A7os.
>
> Em qui, 12 de abr de 2018 9:00 AM, F=C3=A1bio Telles Rodriguez <
> [email protected]> escreveu:
>
>> Ahh... um backup only data =C3=A9 algo realmente feio. Pra come=C3=A7ar.=
.. dump n=C3=A3o
>> =C3=A9 backup! ;-)
>>
>> Vide: https://www.savepoint.blog.br/2010/05/06/dump-nao-e-backup/
>>
>> Se voc=C3=AA n=C3=A3o colocar as informa=C3=A7=C3=B5es corretas no backu=
p, n=C3=A3o vai conseguir
>> extrair o que n=C3=A3o existe.
>>
>>
>>
>> Em 12 de abril de 2018 08:22, Manuel Garcia <[email protected]=
>
>> escreveu:
>>
>>> algu=C3=A9m j=C3=A1 tive algum problema similar que me possa orientar p=
ara poder
>>> resolver esse problema.
>>>
>>> 2018-04-12 8:21 GMT-03:00 Manuel Garcia <[email protected]>:
>>>
>>>> Bom dia,
>>>>
>>>> Sou Alejandro engenheiro em computa=C3=A7=C3=A3o trabalho no brasil co=
mo dba
>>>> postgresql, meu problema =C3=A9 o cliente que tem un dba na sua empres=
a fez um
>>>> backup do postgresql only data , deleto o banco e foi restaurar em out=
ra
>>>> maquina sem ter salvo o schema dele , como eu consigo recuperar as fun=
ction
>>>> tables views resumindo a estrutura do banco desde un backup only data =
???
>>>>
>>>>
>>>> --
>>>>            Manuel Alejandro Garcia Mellado
>>>> Ingeniero Ejecuci=C3=B3n en Inform=C3=A1tica e computaci=C3=B3n
>>>> Concepcion - Chile VIII Region del Bio - Bio
>>>>
>>>>
>>>
>>>
>>> --
>>>            Manuel Alejandro Garcia Mellado
>>> Ingeniero Ejecuci=C3=B3n en Inform=C3=A1tica e computaci=C3=B3n
>>> Concepcion - Chile VIII Region del Bio - Bio
>>>
>>>
>>> _______________________________________________
>>> pgbr-geral mailing list
>>> pgbr-geral-b/[email protected]
>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>>>
>>
>>
>>
>> --
>> Atenciosamente,
>> F=C3=A1bio Telles Rodriguez
>> blog: http:// <http://www.midstorm.org/~telles/>s
>> <http://tellesr.wordpress.com/>avepoint.blog.br
>> <http://savepoint.blog.br>
>> e-mail / gtalk / MSN: [email protected]
>> Skype: fabio_telles
>>
>> Timbira - A empresa brasileira de Postgres
>> http://www.timbira.com.br
>> _______________________________________________
>> pgbr-geral mailing list
>> pgbr-geral-b/[email protected]
>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
> _______________________________________________
> pgbr-geral mailing list
> pgbr-geral-b/[email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

--001a1145bc5075d7a90569a5b0ef
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Ok muito obrigado a todos. Realmente tere que ver na m=C3=
=A3o mesmo.</div><br><div class=3D"gmail_quote"><div dir=3D"ltr">Em qui, 12=
 de abr de 2018 09:04, Arlindo Neto &lt;<a href=3D"mailto:[email protected]=
m">[email protected]</a>&gt; escreveu:<br></div><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex"><div dir=3D"auto">Minha opini=C3=A3o: se o seu dump for data-only, voc=
=C3=AA vai ter que recriar os schemas, views etc na m=C3=A3o e adapta-los o=
u seus dados... Resumidamente, boa sorte. Vai ser trabalhoso, mas n=C3=A3o =
=C3=A9 imposs=C3=ADvel.<div dir=3D"auto"><br></div><div dir=3D"auto">Abra=
=C3=A7os.</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">Em qui=
, 12 de abr de 2018 9:00 AM, F=C3=A1bio Telles Rodriguez &lt;<a href=3D"mai=
lto:[email protected]" target=3D"_blank" rel=3D"noreferrer">fabio.tell=
[email protected]</a>&gt; escreveu:<br></div><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div=
 dir=3D"ltr">Ahh... um backup only data =C3=A9 algo realmente feio. Pra com=
e=C3=A7ar... dump n=C3=A3o =C3=A9 backup! ;-)<div><br></div><div>Vide:=C2=
=A0<a href=3D"https://www.savepoint.blog.br/2010/05/06/dump-nao-e-backup/" =
rel=3D"noreferrer noreferrer" target=3D"_blank">https://www.savepoint.blog.=
br/2010/05/06/dump-nao-e-backup/</a><br><div><br></div><div>Se voc=C3=AA n=
=C3=A3o colocar as informa=C3=A7=C3=B5es corretas no backup, n=C3=A3o vai c=
onseguir extrair o que n=C3=A3o existe.</div><div><br></div><div><br></div>=
</div></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">Em 12=
 de abril de 2018 08:22, Manuel Garcia <span dir=3D"ltr">&lt;<a href=3D"mai=
lto:[email protected]" rel=3D"noreferrer noreferrer" target=3D"_b=
lank">[email protected]</a>&gt;</span> escreveu:<br><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;=
padding-left:1ex"><div dir=3D"ltr">algu=C3=A9m j=C3=A1 tive algum problema =
similar que me possa orientar para poder resolver esse problema.</div><div =
class=3D"m_-6586309500163302192m_-1218723963084019696HOEnZb"><div class=3D"=
m_-6586309500163302192m_-1218723963084019696h5"><div class=3D"gmail_extra">=
<br><div class=3D"gmail_quote">2018-04-12 8:21 GMT-03:00 Manuel Garcia <spa=
n dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" rel=3D"nor=
eferrer noreferrer" target=3D"_blank">[email protected]</a>&gt;</=
span>:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bord=
er-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Bom dia,=C2=A0<di=
v><br></div><div>Sou Alejandro engenheiro em computa=C3=A7=C3=A3o trabalho =
no brasil como dba postgresql, meu problema =C3=A9 o cliente que tem un dba=
 na sua empresa fez um backup do postgresql only data , deleto o banco e fo=
i restaurar em outra maquina sem ter salvo o schema dele , como eu consigo =
recuperar as function tables views resumindo a estrutura do banco desde un =
backup only data ???=C2=A0</div><span class=3D"m_-6586309500163302192m_-121=
8723963084019696m_7861964255581224860HOEnZb"><font color=3D"#888888"><div><=
br clear=3D"all"><div><br></div>-- <br><div class=3D"m_-6586309500163302192=
m_-1218723963084019696m_7861964255581224860m_4609042909819290057gmail_signa=
ture" data-smartmail=3D"gmail_signature">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0Manuel Alejandro Garcia Mellado=C2=A0<div><div>Ingeniero=C2=A0Ejecuc=
i=C3=B3n=C2=A0en=C2=A0Inform=C3=A1tica=C2=A0e=C2=A0computaci=C3=B3n</div><d=
iv>Concepcion - Chile VIII Region del Bio - Bio</div><div><br></div></div><=
/div>
</div></font></span></div>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"m_-6586309500163302192m_-1218723963084019696m_7861964255581224860gmail_=
signature" data-smartmail=3D"gmail_signature">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0Manuel Alejandro Garcia Mellado=C2=A0<div><div>Ingeniero=C2=A0=
Ejecuci=C3=B3n=C2=A0en=C2=A0Inform=C3=A1tica=C2=A0e=C2=A0computaci=C3=B3n</=
div><div>Concepcion - Chile VIII Region del Bio - Bio</div><div><br></div><=
/div></div>
</div>
</div></div><br>_______________________________________________<br>
pgbr-geral mailing list<br>
<a href=3D"mailto:pgbr-geral-b/[email protected]" rel=3D"noreferrer no=
referrer" target=3D"_blank">pgbr-geral-b/[email protected]</a><br>
<a href=3D"https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-g=
eral" rel=3D"noreferrer noreferrer noreferrer" target=3D"_blank">https://li=
stas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral</a><br></blockqu=
ote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=3D"m_-6586=
309500163302192m_-1218723963084019696gmail_signature" data-smartmail=3D"gma=
il_signature"><div dir=3D"ltr"><div><div>Atenciosamente,</div><div>F=C3=A1b=
io Telles Rodriguez</div>blog: <a href=3D"http://www.midstorm.org/~telles/"=
 rel=3D"noreferrer noreferrer" target=3D"_blank">http://</a><a href=3D"http=
://tellesr.wordpress.com/" rel=3D"noreferrer noreferrer" target=3D"_blank">=
s</a><a href=3D"http://savepoint.blog.br" rel=3D"noreferrer noreferrer" tar=
get=3D"_blank">avepoint.blog.br</a><div>e-mail / gtalk / MSN:=C2=A0<a href=
=3D"mailto:[email protected]" rel=3D"noreferrer noreferrer" target=3D"=
_blank">[email protected]</a><div>Skype: fabio_telles</div></div><div>=
<br></div><div>Timbira - A empresa brasileira de Postgres</div><div><a href=
=3D"http://www.timbira.com.br" rel=3D"noreferrer noreferrer" target=3D"_bla=
nk">http://www.timbira.com.br</a>=C2=A0</div></div></div></div>
</div>
_______________________________________________<br>
pgbr-geral mailing list<br>
<a href=3D"mailto:pgbr-geral-b/[email protected]" rel=3D"noreferrer no=
referrer" target=3D"_blank">pgbr-geral-b/[email protected]</a><br>
<a href=3D"https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-g=
eral" rel=3D"noreferrer noreferrer noreferrer" target=3D"_blank">https://li=
stas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral</a></blockquote>=
</div>
_______________________________________________<br>
pgbr-geral mailing list<br>
<a href=3D"mailto:pgbr-geral-b/[email protected]" target=3D"_blank" re=
l=3D"noreferrer">pgbr-geral-b/[email protected]</a><br>
<a href=3D"https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-g=
eral" rel=3D"noreferrer noreferrer" target=3D"_blank">https://listas.postgr=
esql.org.br/cgi-bin/mailman/listinfo/pgbr-geral</a></blockquote></div>

--001a1145bc5075d7a90569a5b0ef--

--===============5702553115689939539==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline

X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KcGdici1nZXJh
bCBtYWlsaW5nIGxpc3QKcGdici1nZXJhbEBsaXN0YXMucG9zdGdyZXNxbC5vcmcuYnIKaHR0cHM6
Ly9saXN0YXMucG9zdGdyZXNxbC5vcmcuYnIvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3BnYnIt
Z2VyYWw=

--===============5702553115689939539==--