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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

Next:From: Frederic MassotDate: 2004-08-25 14:58:55
Subject: Size of database
Previous:From: Andrew FarmerDate: 2004-08-25 01:41:17
Subject: 7.3.4 Table corruption

pgsql-general by date

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

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