Re: how to restore postgre 8.3 from data directory - Mailing list pgsql-admin

From jose javier parra sanchez
Subject Re: how to restore postgre 8.3 from data directory
Date
Msg-id 99f1636c0910140302v12d0db73l5240dc97695bd94b@mail.gmail.com
Whole thread Raw
In response to how to restore postgre 8.3 from data directory  (Alberto Asuero Arroyo <albertoasuero@gmail.com>)
Responses Re: how to restore postgre 8.3 from data directory
List pgsql-admin
It depends, the original data was from what version ?, what platform
(x86/x86_64/ppc/..) ?

2009/10/14 Alberto Asuero Arroyo <albertoasuero@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

pgsql-admin by date:

Previous
From: Alberto Asuero Arroyo
Date:
Subject: how to restore postgre 8.3 from data directory
Next
From: Alberto Asuero Arroyo
Date:
Subject: Re: how to restore postgre 8.3 from data directory