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
