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
>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
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
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
> --- 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:
> >
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
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
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
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..
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
10 matches
Mail list logo