Re: [GENERAL] pg_restore question

2016-09-19 Thread Adrian Klaver
On 09/19/2016 01:55 PM, kbran...@pwhome.com wrote: On 09/19/2016 01:06 PM, kbrannen(at)pwhome(dot)com wrote: --- adrian(dot)klaver(at)aklaver(dot)com wrote: From: Adrian Klaver To: kbrannen(at)pwhome(dot)com, pgsql-general(at)postgresql(dot)org Subject: Re: [GENERAL] pg_restore question Date

Re: [GENERAL] pg_restore question

2016-09-19 Thread
>On 09/19/2016 01:06 PM, kbrannen(at)pwhome(dot)com wrote: >>> --- adrian(dot)klaver(at)aklaver(dot)com wrote: >>> >>> From: Adrian Klaver >>> To: kbrannen(at)pwhome(dot)com, pgsql-general(at)postgresql(dot)org >>> Subject: Re: [GENERAL] pg_rest

Re: [GENERAL] pg_restore question

2016-09-19 Thread Adrian Klaver
On 09/19/2016 01:06 PM, kbran...@pwhome.com wrote: --- adrian.kla...@aklaver.com wrote: From: Adrian Klaver To: kbran...@pwhome.com, pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_restore question Date: Mon, 19 Sep 2016 12:46:24 -0700 On 09/19/2016 11:46 AM, kbran...@pwhome.com wrote

Re: [GENERAL] pg_restore question

2016-09-19 Thread Adrian Klaver
On 09/19/2016 01:06 PM, kbran...@pwhome.com wrote: --- adrian.kla...@aklaver.com wrote: From: Adrian Klaver To: kbran...@pwhome.com, pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_restore question Date: Mon, 19 Sep 2016 12:46:24 -0700 On 09/19/2016 11:46 AM, kbran...@pwhome.com wrote

Re: [GENERAL] pg_restore question

2016-09-19 Thread
> --- adrian.kla...@aklaver.com wrote: > > From: Adrian Klaver > To: kbran...@pwhome.com, pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_restore question > Date: Mon, 19 Sep 2016 12:46:24 -0700 > > On 09/19/2016 11:46 AM, kbran...@pwhome.com wrote: > >

Re: [GENERAL] pg_restore question

2016-09-19 Thread Adrian Klaver
On 09/19/2016 11:46 AM, kbran...@pwhome.com wrote: I think I'm going to need some help in understanding a couple of restore issues. This is for Pg 9.5.1. It seems that if I create a dump using pg_dump --clean --create --format=p --dbname=nms --schema=public > dump.sql then the restore (after

Re: [GENERAL] pg_restore question

2010-12-04 Thread Tom Lane
u235sentinel writes: > We're backing up our database using pg_dump with compression. We're > selecting each database however when we tried running a pg_restore > everything cept for the roles were restored. > I'm digging through the pg_restore options, Is there an option I'm > forgetting to i

Re: [GENERAL] pg_restore question (-T and -t)

2009-01-06 Thread Bruce Momjian
Martin Gainty wrote: > > Tony- > > pgdump version 8.3 will dump multiple tables (with multiple -t) > http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html > > but I dont see the same multiple table functionality with pgrestore > http://www.postgresql.org/docs/8.3/interactive/app-pgrest

Re: [GENERAL] pg_restore question (-T and -t)

2008-12-31 Thread Martin Gainty
Tony- pgdump version 8.3 will dump multiple tables (with multiple -t) http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html but I dont see the same multiple table functionality with pgrestore http://www.postgresql.org/docs/8.3/interactive/app-pgrestore.html you may have found a bug..

Re: [GENERAL] pg_restore question (-T and -t)

2008-12-31 Thread George Pavlov
Why not just try it! Answer: all -t switches after the first one are ignored. (And, no, "pg_restore --help" does not mention that). However with -l and -L, you have a much more powerful mechanism for specifying exactly which objects you want restored. > -Original Message- > From: pgsql-ge