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 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 recipe about to test if my > > backup is working fine, and will help if I need > > sometime? > > Are you using pg_dump or pg_dumpall? I just use > pg_dump on individual > databases (pg_dumpall works on the whole cluster) > and can restore that to > any database. > > > HTH > > -- > Paul Thomas > +------------------------------+---------------------------------------------+ > | Thomas Micro Systems Limited | Software Solutions > for > Business | > | Computer Consultants | > http://www.thomas-micro-systems-ltd.co.uk | > +------------------------------+---------------------------------------------+ > _______________________________________________________ Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade! http://br.acesso.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
