pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nick Fankhauser <nickf@ontko.com>
To: Marvin <magosoft@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: pg_restore problem!!!
Date: Tue, 22 Jul 2003 15:29:33 -0500
Message-ID: <NEBBLAAHGLEEPCGOBHDGKEPCHMAA.nickf@ontko.com> (raw)
In-Reply-To: <3F1D9CCC.000003.02764@guaj215desa>

Mago-

pg_restore is used to restore a dump file created in one of the non-text
formats such as tar format.

To restore from a plain-text dump file, just pipe it into psql like so:

cat [filename] | psql [dbname]

-Nick

---------------------------------------------------------------------
Nick Fankhauser

    nickf@doxpop.com  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Marvin
Sent: Tuesday, July 22, 2003 3:22 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pg_restore problem!!!


I made a back up file with this sentence:

pg_dump -U [superusername] -C -D -f [filename]  [dbname]

It seems to work fine. I opened the file and I saw all the commands to
insert every piece of data and reconstruct my schema. However when I try to
restore that file it gets me the following error:

C:\>pg_restore [filename]
pg_restore: [archiver] input file does not appear to be a valid archive

What I am doing wrong??
Any ideas??

Thank you in advanced.


MAGO


_________________________________________________________________
  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquĆ­




view thread (17+ messages)  latest in thread

Message-ID: <NEBBLAAHGLEEPCGOBHDGKEPCHMAA.nickf@ontko.com>
Permalink:  ../NEBBLAAHGLEEPCGOBHDGKEPCHMAA.nickf@ontko.com/
Also on:    postgresql.org/message-id/NEBBLAAHGLEEPCGOBHDGKEPCHMAA.nickf@ontko.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: nickf@ontko.com, magosoft@gmx.net
  Subject: Re: pg_restore problem!!!
  In-Reply-To: <NEBBLAAHGLEEPCGOBHDGKEPCHMAA.nickf@ontko.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox