Skip site navigation (1) Skip section navigation (2)

pg_restore problems?

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pg_restore problems?
Date: 2001-04-29 22:24:39
Message-ID: 005001c0d0fb$2e44bf80$5a2b7ad8@expertrade.com (view raw or flat)
Thread:
Lists: pgsql-general
In testing db recovery, I backed up a database using the command:

pg_dump -b -Fc tssd_2000 > tssd_2000.dump

I then dropped the tssd_2000 database.

When trying to restore the database, the -v option seems to show all of the
schema creates and loads, but at the end, the database does not exist.  I'm
using the command:

pg_restore -v --clean --create tssd_2000.dump

But nothing was there.  I tried to just do a CREATE DATABASE tssd_2000
first, but then I get an error about the database being there already.  So I
dropped it again, and tried to just restore the schema with:

pg_restore -v -s tssd_2000.dump

Again, it looks like everything is going okay, but when it's done, there's
no database to be found.

What am I doing wrong?

Thanks,
David


Responses

pgsql-general by date

Next:From: David WallDate: 2001-04-29 22:26:21
Subject: blob/oids deleted with row?
Previous:From: Roelof OsingaDate: 2001-04-29 21:04:34
Subject: Nope, too soon [was: Re: FOR IMMEDIATE RELEASE: PostgreSQL v7.1 Release Announcement]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group