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
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 "drop schema public cascade") with "psql nms < dump.
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
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 include?
Also we're restorin
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
than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> Date: Wed, 31 Dec 2008 15:49:39 -0600
> From: tony_cad...@amsoftwaredesign.com
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] pg_restore question (-T and -t)
>
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Tony Caduto
> Sent: Wednesday, December 31, 2008 1:50 PM
> To: pgsql general
> Subject: [GENERAL] pg_restore question (-T and -t)
>
> Hi,
> does anyone know if you can do
Hi,
does anyone know if you can do multiple
-T or -t (restore named trigger, restore name table) switches?
In the docs for pg_restore it does not specify if it will accept more
than one, but in the pg_dump docs the -n and -t switches allow multiples.
Thanks,
tony
--
Sent via pgsql-general
13 matches
Mail list logo
