Re: [GENERAL] Dump and Restore

From: Lawrence C <research_2004(at)yahoo(dot)com>
To: olly(at)lfix(dot)co(dot)uk, "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Cc: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Dump and Restore
Date: 2004-08-25 01:51:44
Message-ID: 20040825015144.37773.qmail@web61010.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

You can also
$ cat dumpfile | more

--- Oliver Elphick <olly(at)lfix(dot)co(dot)uk> wrote:
> 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
> olly(at)lfix(dot)co(dot)uk
> Isle of Wight
> http://www.lfix.co.uk/oliver
> GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0
> 5664 7A2F A543 10EA
>
> ========================================
> "I saw in the night visions, and, behold, one
> like the
> Son of man came with the clouds of heaven, and
> came to
> the Ancient of days, and they brought him near
> before
> him. And there was given him dominion, and
> glory, and
> a kingdom, that all people, nations, and
> languages,
> should serve him; his dominion is an
> everlasting
> dominion, which shall not pass away, and his
> kingdom
> that which shall not be destroyed."
> Daniel 7:13,14
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Frederic Massot 2004-08-25 14:58:55 Size of database
Previous Message Andrew Farmer 2004-08-25 01:41:17 7.3.4 Table corruption

Browse pgsql-general by date

  From Date Subject
Next Message Joel 2004-08-25 01:58:32 Re: UTF-8 and LIKE vs =
Previous Message Christopher Browne 2004-08-25 00:56:01 Re: Unsupported 3rd-party solutions (Was: Few questions