It depends, the original data was from what version ?, what platform (x86/x86_64/ppc/..) ? 2009/10/14 Alberto Asuero Arroyo <albertoasuero@xxxxxxxxx>: > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
