Re: [GENERAL] Dump and restore problem

2008-06-22 Thread David
On Sun, Jun 22, 2008 at 3:11 AM, Stuart Luppescu <[EMAIL PROTECTED]> wrote: > On 木, 2008-06-19 at 11:57 +0200, David wrote: >> > pg_restore: [tar archiver] could not open TOC file for input: No >> such >> > file or directory >> >> It sounds like the tar file is no longer being created. >> >> Try ma

Re: [GENERAL] Dump and restore problem

2008-06-21 Thread Martin
: Saturday, June 21, 2008 9:11 PM Subject: Re: [GENERAL] Dump and restore problem On 木, 2008-06-19 at 11:57 +0200, David wrote: > pg_restore: [tar archiver] could not open TOC file for input: No such > file or directory It sounds like the tar file is no longer being created. Try manuall

Re: [GENERAL] Dump and restore problem

2008-06-21 Thread Stuart Luppescu
On 木, 2008-06-19 at 11:57 +0200, David wrote: > > pg_restore: [tar archiver] could not open TOC file for input: No > such > > file or directory > > It sounds like the tar file is no longer being created. > > Try manually running the commands, and verify that the dump, restore, > and rsync still w

Re: [GENERAL] Dump and restore problem

2008-06-19 Thread David
On Wed, Jun 18, 2008 at 11:41 PM, Stuart Luppescu <[EMAIL PROTECTED]> wrote: [...] > pg_restore: [tar archiver] could not open TOC file for input: No such > file or directory It sounds like the tar file is no longer being created. Try manually running the commands, and verify that the dump, res

[GENERAL] Dump and restore problem

2008-06-18 Thread Stuart Luppescu
Hello, I had a very nice system where I mirrored everything to another machine each night, so in case of disaster, I could easily switch over to the mirror. The backup script uses a line like this: pg_dump -b -F t -h $postgresql_hostname $i > "$location_backup_dir/`date +%B-%Y`/$date_info/postgre

[GENERAL] dump and restore a single table containing large objects

2005-04-27 Thread John Liu
Is there a clean way to dump/restore a single table which contains large objects instead of the entire DB? In Pg version=7.4 - pg_dump: Large object output is not supported for a single table. pg_dump: Use all tables or a full dump instead. Does version 8.0's pg_dump support a single table dump c

Re: [GENERAL] Dump and Restore

2004-08-24 Thread Oliver Elphick
On Tue, 2004-08-24 at 17:36, Eduardo S. Fontanetti wrote: > I am using pg_dump. > > It means that I can't restore to a different name > database?? If you use pg_dump[all] without other options it will dump to a text file. Just edit the database name. -- Oliver Elphick

Re: [GENERAL] Dump and Restore

2004-08-24 Thread Eduardo S. Fontanetti
I am using pg_dump. It means that I can't restore to a different name database?? Eduardo S. Fontanetti --- Paul Thomas <[EMAIL PROTECTED]> escreveu: > > On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: > > How can I do a test if my dumping is really > working, I > > can't apply the dump in my

Re: [GENERAL] Dump and Restore

2004-08-24 Thread Ron St-Pierre
Eduardo S. Fontanetti wrote: How can I do a test if my dumping is really working, I can't apply the dump in my database, because it will overwrite a lot of data. I was thinking about restore in another database name, but I can't, it always restore on the original database. Somebody have a cooking r

Re: [ADMIN] [GENERAL] Dump and Restore

2004-08-24 Thread Thilina Gunasekara
--- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Thomas Sent: 24 August 2004 16:30 To: Eduardo S . Fontanetti Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] [GENERAL] Dump and Restore On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: > How can I do a test if my

Re: [GENERAL] Dump and Restore

2004-08-24 Thread Paul Thomas
On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: How can I do a test if my dumping is really working, I can't apply the dump in my database, because it will overwrite a lot of data. I was thinking about restore in another database name, but I can't, it always restore on the original database. Someb