Re: [SQL] restoring database

2003-12-23 Thread Markus Bertheau
Ð ÐÐÐ, 22.12.2003, Ð 18:53, scott.marlowe ÐÐÑÐÑ: > On Mon, 22 Dec 2003, Theodore Petrosky wrote: > > > As I am not someone with a lot of experience > > (depending on the size of the 'dumpall') I would > > create a new database to suck up the 'all' then > > pg_dump the table I really cared abou

[SQL] restoring database

2003-12-22 Thread LAIN Lucas TECHTEL
Hi everybody ... i need to restore only one database from a pg_dumpall backup file... how can i do it? Thanks a lot ! -- Lucas Lain Gerencia de Ingeniería TechTel Telecomunicaciones [EMAIL PROTECTED] TE. (54-11) 4000-3164 ---(end of broadcast)--

Re: [SQL] restoring database

2003-12-22 Thread scott.marlowe
On Mon, 22 Dec 2003, Theodore Petrosky wrote: > As I am not someone with a lot of experience > (depending on the size of the 'dumpall') I would > create a new database to suck up the 'all' then > pg_dump the table I really cared about. > > Obviously, if the dump_all is a terabyte database th

Re: [SQL] restoring database

2003-12-22 Thread Theodore Petrosky
As I am not someone with a lot of experience (depending on the size of the 'dumpall') I would create a new database to suck up the 'all' then pg_dump the table I really cared about. Obviously, if the dump_all is a terabyte database this method is inconvenient (to say the least). However

[SQL] restoring database

2003-12-22 Thread Lucas Lain
Hi everybody ... i need to restore only one database from a pg_dumpall backup file... how can i do it? Thanks a lot ! ---(end of broadcast)--- TIP 8: explain analyze is your friend