>I want to backup a database but exclude certain schemas with a patter.
>I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on.
>Will this work?
>$pg_dump --exclude-schema='sch_*'
>this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
>anything wrong here?
>t
On Wed, Aug 28, 2013 at 9:30 PM, Jay Vee wrote:
> $pg_dump --exclude-schema='sch_*'
>
> this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
> anything wrong here?
The option is fine and works for me on 9.2.4, I suspect the could do a clash with the -N (exclude-schema).
On 08/28/2013 12:30 PM, Jay Vee wrote:
I want to backup a database but exclude certain schemas with a patter.
I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on.
Will this work?
$pg_dump --exclude-schema='sch_*'
this does not seem to exclude all schemas with this pattern
I want to backup a database but exclude certain schemas with a patter.
I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on.
Will this work?
$pg_dump --exclude-schema='sch_*'
this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
anything wrong here?
than
Madison Kelly wrote:
Richard Huxton wrote:
As far as I can tell, you can only dump one schema at a time. Is
this true?
No, pg_dump dumps a whole database by default. You can dump just a
single schema or table though.
Hmm, I wonder why I thought this... Was this true in older versions or
Richard Huxton wrote:
As far as I can tell, you can only dump one schema at a time. Is
this true?
No, pg_dump dumps a whole database by default. You can dump just a
single schema or table though.
Hmm, I wonder why I thought this... Was this true in older versions or
did I just imagine th
Hi,
On Thu, 2007-01-04 at 11:20 -0500, Madison Kelly wrote:
>As far as I can tell, you can only dump one schema at a time. Is
> this true?
You can dump multiple schemas and multiple tables at a time with 8.2.
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
Postgr
Madison Kelly wrote:
Hi all,
I've created a database (pgsql 8.1 on Debian Etch) that uses
triggers/functions to keep all changes for various tables in a history
schema. This is the first time I've done this (captured and stored
changes in a different schema) so I was hoping for some backup/
Hi all,
I've created a database (pgsql 8.1 on Debian Etch) that uses
triggers/functions to keep all changes for various tables in a history
schema. This is the first time I've done this (captured and stored
changes in a different schema) so I was hoping for some backup/restore
advice.
A
Andreas Kretschmer wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> schrieb:
> > > > I would like to use pg_dump to backup a list of tables to one file,
> > > > but it looks like
> > > > the -t option only supports one file. So, pg_dump gives you the
> > > > option of backing
> > > > up and entire d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/02/06 09:56, Alvaro Herrera wrote:
> A. Kretschmer wrote:
>> am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes:
>>> Hi,
>>>
>>> I would like to use pg_dump to backup a list of tables to one file,
>>> but it looks like
>>>
Alvaro Herrera <[EMAIL PROTECTED]> schrieb:
> > > I would like to use pg_dump to backup a list of tables to one file,
> > > but it looks like
> > > the -t option only supports one file. So, pg_dump gives you the
> > > option of backing
> > > up and entire database or one file, but nothing in be
A. Kretschmer wrote:
> am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes:
> > Hi,
> >
> > I would like to use pg_dump to backup a list of tables to one file,
> > but it looks like
> > the -t option only supports one file. So, pg_dump gives you the
> > option of backing
>
am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes:
> Hi,
>
> I would like to use pg_dump to backup a list of tables to one file,
> but it looks like
> the -t option only supports one file. So, pg_dump gives you the
> option of backing
> up and entire database or one file
Hi,
I would like to use pg_dump to backup a list of tables to one file,
but it looks like
the -t option only supports one file. So, pg_dump gives you the
option of backing
up and entire database or one file, but nothing in between. Am I
missing something?
Is there a way to backup multiple
[EMAIL PROTECTED] writes:
> Can I dump specifc table and still get the actual sequence for it.
It works for me in 7.3 and later --- at least when the column was
created by calling it a SERIAL column. If you made the sequence
separately then I don't think this is really a bug.
On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:
> is ther a way to pass a password to the pg_dump command to avoid being
> prompted for it.
> I want to execute the dump from a perl or shell script and dont want to
> open accees for the user in the pg_hba.conf
Use the ~/.pgpass file. It w
Hi,
is ther a way to pass a password to the pg_dump command to avoid being
prompted for it.
I want to execute the dump from a perl or shell script and dont want to
open accees for the user in the pg_hba.conf
I tried
PGUSER=userid PGPASSWD=passwd pg_dump -Fc -f dump.db mydb;
Thanks
Alex
---
18 matches
Mail list logo
