Jehan-Guillaume (ioguix) de Rorthais iog...@free.fr writes:
If you can spend some more time using -Fc, then you'll be able to play
with -l and -L switches of pg_restore to optionally decide what should
be restored or not (with more control than -n, -t, etc, think about
excluding slony stuffs
27.10.2010 t...@sss.pgh.pa.us napsal(a):
=?utf-8?Q?Martin_Povolny?= martin.povo...@solnet.cz writes:
I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping: I
was unable to
make a dump in the default 'tar' format. I got this message:
pg_dump: [tar archiver] archive member too
...@postgresql.org] On Behalf Of Jehan-Guillaume
(ioguix) de Rorthais
Sent: Tuesday, October 26, 2010 4:22 PM
To: Martin Povolny
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] large database: problems with pg_dump and pg_restore
Or even compress AND split it !
pg_dump -Fc dbname | split -b
Hallo,
I have some quite grave problems with dumping and restoring large databases
(4GB of
dump).
I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping: I was
unable to
make a dump in the default 'tar' format. I got this message:
pg_dump: [tar archiver] archive member too large
Zitat von Martin Povolny martin.povo...@solnet.cz:
Hallo,
I have some quite grave problems with dumping and restoring large
databases (4GB of
dump).
I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping:
I was unable to
make a dump in the default 'tar' format. I got this
Povolny
Sent: Tuesday, 26 October 2010 10:12 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] large database: problems with pg_dump and pg_restore
Hallo,
I have some quite grave problems with dumping and restoring large databases
(4GB of dump).
I had 5 databases, 4 dumped ok, the 5th
] *On Behalf Of *Martin Povolny
*Sent:* Tuesday, 26 October 2010 10:12 PM
*To:* pgsql-admin@postgresql.org
*Subject:* [ADMIN] large database: problems with pg_dump and pg_restore
Hallo,
I have some quite grave problems with dumping and restoring large
databases (4GB of dump
=?utf-8?Q?Martin_Povolny?= martin.povo...@solnet.cz writes:
I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping: I was
unable to
make a dump in the default 'tar' format. I got this message:
pg_dump: [tar archiver] archive member too large for tar format
This is expected: tar
: [ADMIN] large database: problems with pg_dump and pg_restore
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Or even compress AND split it !
pg_dump -Fc dbname | split -b 1G - dump_dbname
and restore:
cat dump_dbname* | pg_restore -d dbname
or
cat dump_dbname* | pg_restore | psql dbname
Le