From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Does pg_rman restore datafiles |
Date: | 2013-12-16 10:44:39 |
Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC0FD153@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
If anybody on this list has any expertise/experience with pg_rman I will be grateful if they can advise me on the following:
(Note I have also posted this onto the pg_rman google group):
If I create a tablespace called test then I get the following
[postgres(at)train03:~/datafiles/test]$ pwd
/var/lib/pgsql/datafiles/test
[postgres(at)train03:~/datafiles/test]$ ls -lt
total 4
drwx------. 2 postgres postgres 4096 Dec 12 15:27 PG_9.2_201204301
[postgres(at)train03:~/datafiles/test]$
However if I then do:
rm -rf /var/lib/pgsql/data/*
rm -rf /var/lib/pgsql/datafiles/test/*
i.e. delete the physical datafile and then do a restore from a previous back I get the below:
[postgres(at)train03:~/datafiles/test]$ ls -lt
total 0
[postgres(at)train03:~/datafiles/test]$
[postgres(at)train03:~/data/pg_tblspc]$ pwd
/var/lib/pgsql/data/pg_tblspc
[postgres(at)train03:~/data/pg_tblspc]$ ls -lt
total 0
lrwxrwxrwx. 1 postgres postgres 54 Dec 12 15:28 16410 -> /var/lib/pgsql/datafiles/test
[postgres(at)train03:~/data/pg_tblspc]$ ls -lt /var/lib/pgsql/datafiles/test
total 0
[postgres(at)train03:~/data/pg_tblspc]$
Is this expected behaviour?
Does pg_rman restore physical datafiles?
Thanks
Austen
Austen Birchall Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom
Tel: +44 (0)1392 884481 Fax: +44 (0)1392 885681
E-mail: austen(dot)birchall(at)metoffice(dot)gov(dot)uk Website: http://www.metoffice.gov.uk
From | Date | Subject | |
---|---|---|---|
Next Message | angelina410329 | 2013-12-17 09:22:36 | Re: How to Recover iPhone Contacts You Lost Somehow? |
Previous Message | Gerald Cheves | 2013-12-12 07:22:30 | PostgreSQL Studio |