--000e0cdf7632e012590475e52f38
Content-Type: text/plain; charset=ISO-8859-1
OK,
I've restore the data into a machine with x86_64 with success. I've only
moved my backup data directory into the restoration machine's postgres data
directory (cspecifically /var/lib/postgresql/8.3/main).
I've only had a little problem with the locales.
Thanks jose,
On Wed, Oct 14, 2009 at 12:11 PM, jose javier parra sanchez <
jojapasa [at] gmail.com> wrote:
> 2009/10/14 Alberto Asuero Arroyo <albertoasuero [at] gmail.com>:
> > I have the same version in the two servers (postgre 8.3), the difference
> is
> > only the architecture , the postgres was running in x86_64 and the
> restore
> > machine is a x86. But I can try to restore in x86, should I do it?
>
> No, you can't. Data is architecture dependant.
>
> >
> > thanks alberto
> >
> >
> >
> >
> > On Wed, Oct 14, 2009 at 12:02 PM, jose javier parra sanchez
> > <jojapasa [at] gmail.com> wrote:
> >>
> >> It depends, the original data was from what version ?, what platform
> >> (x86/x86_64/ppc/..) ?
> >>
> >> 2009/10/14 Alberto Asuero Arroyo <albertoasuero [at] gmail.com>:
> >> > Hi!
> >> >
> >> > I need to restore the postgre 8.3 from a data directory
> >> > /var/lib/postgresql/8.3/main which has the following content:
> >> >
> >> > $ ls -l
> >> >
> >> > drwx------ 5 postgres postgres 4096 oct 14 11:53 base
> >> > drwx------ 2 postgres postgres 4096 oct 14 12:10 global
> >> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_clog
> >> > drwx------ 4 postgres postgres 4096 oct 14 11:53 pg_multixact
> >> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_subtrans
> >> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_tblspc
> >> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_twophase
> >> > -rw------- 1 postgres postgres 4 oct 14 11:53 PG_VERSION
> >> > drwx------ 3 postgres postgres 4096 oct 14 11:53 pg_xlog
> >> > -rw------- 1 postgres postgres 133 oct 14 12:05 postmaster.opts
> >> > lrwxrwxrwx 1 root root 31 oct 14 11:53 root.crt ->
> >> > /etc/postgresql-common/root.
> >> > crt
> >> > lrwxrwxrwx 1 root root 36 oct 14 11:53 server.crt ->
> >> > /etc/ssl/certs/ssl-cert-snakeoil.pem
> >> > lrwxrwxrwx 1 root root 38 oct 14 11:53 server.key ->
> >> > /etc/ssl/private/ssl-cert-snakeoil.key
> >> >
> >> >
> >> >
> >> > I'm tried to replace this directory with the directory of my backup,
> but
> >> > I
> >> > had no success on startup.
> >> >
> >> > Is it possible restore postgre from a data source (I don't have any
> >> > dump)
> >> >
> >> > Thanks, ALberto
> >>
> >> --
> >> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgsql-admin
> >
> >
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--000e0cdf7632e012590475e52f38
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
OK,<br><br>=A0I've restore the data into a machine with x86_64 with suc=
cess. I've only moved my backup data directory into the restoration mac=
hine's=A0 postgres data directory (c<span class=3D"clickable" onclick=
=3D"dr4sdgryt(event,"Ox")"><span class=3D"q">specifically</span> =
</span>=A0 /var/lib/postgresql/8.3/main). <br>
<br>I've only had a little problem with the locales.<br><br>Thanks jose=
,<br><br><br><br>
<br><br><div class=3D"gmail_quote">On Wed, Oct 14, 2009 at 12:11 PM, jose j=
avier parra sanchez <span dir=3D"ltr"><<a href=3D"mailto:jojapasa [at] gmail.=
com">jojapasa [at] gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail=
_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt=
0pt 0.8ex; padding-left: 1ex;">
<div class=3D"im">2009/10/14 Alberto Asuero Arroyo <<a href=3D"mailto:al=
bertoasuero [at] gmail.com">albertoasuero [at] gmail.com</a>>:<br>
</div><div class=3D"im">> I have the same version in the two servers (po=
stgre 8.3), the difference is<br>
> only the architecture , the postgres was running in=A0 x86_64 and the =
restore<br>
> machine is a x86. But I can try to restore in x86, should I do it?<br>
<br>
</div>No, you can't. Data is architecture dependant.<br>
<div><div></div><div class=3D"h5"><br>
><br>
> thanks alberto<br>
><br>
><br>
><br>
><br>
> On Wed, Oct 14, 2009 at 12:02 PM, jose javier parra sanchez<br>
> <<a href=3D"mailto:jojapasa [at] gmail.com">jojapasa [at] gmail.com</a>> w=
rote:<br>
>><br>
>> It depends, the original data was from what version ?, what platfo=
rm<br>
>> (x86/x86_64/ppc/..) ?<br>
>><br>
>> 2009/10/14 Alberto Asuero Arroyo <<a href=3D"mailto:albertoasue=
ro [at] gmail.com">albertoasuero [at] gmail.com</a>>:<br>
>> > Hi!<br>
>> ><br>
>> > I need to restore the postgre 8.3 from a data directory<br>
>> > /var/lib/postgresql/8.3/main which has the following content:=
<br>
>> ><br>
>> > $ ls -l<br>
>> ><br>
>> > drwx------ 5 postgres postgres 4096 oct 14 11:53 base<br>
>> > drwx------ 2 postgres postgres 4096 oct 14 12:10 global<br>
>> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_clog<br>
>> > drwx------ 4 postgres postgres 4096 oct 14 11:53 pg_multixact=
<br>
>> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_subtrans<=
br>
>> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_tblspc<br=
>
>> > drwx------ 2 postgres postgres 4096 oct 14 11:53 pg_twophase<=
br>
>> > -rw------- 1 postgres postgres=A0=A0=A0 4 oct 14 11:53 PG_VER=
SION<br>
>> > drwx------ 3 postgres postgres 4096 oct 14 11:53 pg_xlog<br>
>> > -rw------- 1 postgres postgres=A0 133 oct 14 12:05 postmaster=
..opts<br>
>> > lrwxrwxrwx 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 31 oct 1=
4 11:53 root.crt -><br>
>> > /etc/postgresql-common/root.<br>
>> > crt<br>
>> > lrwxrwxrwx 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 36 oct 1=
4 11:53 server.crt -><br>
>> > /etc/ssl/certs/ssl-cert-snakeoil.pem<br>
>> > lrwxrwxrwx 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 38 oct 1=
4 11:53 server.key -><br>
>> > /etc/ssl/private/ssl-cert-snakeoil.key<br>
>> ><br>
>> ><br>
>> ><br>
>> > I'm tried to replace this directory with the directory of=
my backup, but<br>
>> > I<br>
>> > had no success on startup.<br>
>> ><br>
>> > Is it=A0 possible restore postgre from a data source (I don&#=
39;t have any<br>
>> > dump)<br>
>> ><br>
>> > Thanks, ALberto<br>
>><br>
>> --<br>
>> Sent via pgsql-admin mailing list (<a href=3D"mailto:pgsql-admin [at] p=
ostgresql.org">pgsql-admin [at] postgresql.org</a>)<br>
>> To make changes to your subscription:<br>
>> <a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=
=3D"_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
><br>
><br>
<br>
</div></div>--<br>
<div><div></div><div class=3D"h5">Sent via pgsql-admin mailing list (<a hre=
f=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgres ql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=3D"_blank=
">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</div></div></blockquote></div><br>
--000e0cdf7632e012590475e52f38--
