From: | Alberto Asuero Arroyo <albertoasuero(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | how to restore postgre 8.3 from data directory |
Date: | 2009-10-14 08:46:34 |
Message-ID: | 939ef32f0910140146h4fa17238v868d4806c106817d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | jose javier parra sanchez | 2009-10-14 10:02:45 | Re: how to restore postgre 8.3 from data directory |
Previous Message | Scott Marlowe | 2009-10-14 07:45:33 | Re: vacuumdb in parallel |