Re: [GENERAL] pg_restore - table restoration

2014-01-14 Thread Adrian Klaver
On 01/14/2014 02:29 PM, Day, David wrote: I note for the observed failure of pg_restore -c -a -t, I have worked around this by performing a Truncate operation on the tables prior to invoking pg_restore with a simpler -a -t option combination. If this matter needs to be reposted as bug or needs f

Re: [GENERAL] pg_restore - table restoration

2014-01-14 Thread Day, David
advise. Thanks Dave -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Tuesday, January 14, 2014 10:33 AM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_restore - table restoration On 01/14/2014 06:06 AM, Day, David wrote: > Adr

Re: [GENERAL] pg_restore - table restoration

2014-01-14 Thread Adrian Klaver
On 01/14/2014 06:06 AM, Day, David wrote: Adrian, Thanks for confirming my observations. My hope was that I would be able to create one archive file with pg_dump -Fc, which at a future time could be used to do either a total restoration or partial restorations via options of pg_restore; ie. Not

Re: [GENERAL] pg_restore - table restoration

2014-01-14 Thread Day, David
ql-general@postgresql.org Subject: Re: [GENERAL] pg_restore - table restoration On 01/13/2014 01:43 PM, Day, David wrote: > Hi, > > This is sort of a continuation of = problems I was working on last > week > > with selective restorations of an archive file at the schema or table > level.

Re: [GENERAL] pg_restore - table restoration

2014-01-13 Thread Adrian Klaver
On 01/13/2014 01:43 PM, Day, David wrote: Hi, This is sort of a continuation of = problems I was working on last week with selective restorations of an archive file at the schema or table level. ( V9.3) Given that I dumped the entire database ( pg_dump –Fc my_db –f archive_file ) When I pg_

Re: [GENERAL] pg_restore - table restoration

2014-01-13 Thread Adrian Klaver
On 01/13/2014 01:43 PM, Day, David wrote: Hi, This is sort of a continuation of = problems I was working on last week with selective restorations of an archive file at the schema or table level. ( V9.3) Given that I dumped the entire database ( pg_dump –Fc my_db –f archive_file ) When I pg_

[GENERAL] pg_restore - table restoration

2014-01-13 Thread Day, David
Hi, This is sort of a continuation of = problems I was working on last week with selective restorations of an archive file at the schema or table level. ( V9.3) Given that I dumped the entire database ( pg_dump -Fc my_db -f archive_file ) When I pg_restore an entire schema ( -n ) everything