how to restore postgre 8.3 from data directory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux