pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedrestoring database
5+ messages / 5 participants
[nested] [flat]
* restoring database
@ 2003-12-22 14:58 LAIN Lucas TECHTEL <llain@techtel.com.ar>
0 siblings, 0 replies; 5+ messages in thread
From: LAIN Lucas TECHTEL @ 2003-12-22 14:58 UTC (permalink / raw)
To: pgsql-sql
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
llain@techtel.com.ar
TE. (54-11) 4000-3164
^ permalink raw reply [nested|flat] 5+ messages in thread
* restoring database
@ 2003-12-22 14:58 Lucas Lain <lainl@aconectarse.com>
2003-12-22 16:43 ` Re: restoring database Theodore Petrosky <tedpet5@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Lucas Lain @ 2003-12-22 14:58 UTC (permalink / raw)
To: pgsql-sql
Hi everybody ... i need to restore only one database from a pg_dumpall backup
file... how can i do it?
Thanks a lot !
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: restoring database
2003-12-22 14:58 restoring database Lucas Lain <lainl@aconectarse.com>
@ 2003-12-22 16:43 ` Theodore Petrosky <tedpet5@yahoo.com>
2003-12-22 17:53 ` Re: restoring database scott.marlowe <scott.marlowe@ihs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Theodore Petrosky @ 2003-12-22 16:43 UTC (permalink / raw)
To: Lucas Lain <lainl@aconectarse.com>; pgsql-sql
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 it will work.
Ted
--- Lucas Lain <lainl@aconectarse.com> wrote:
> 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
__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: restoring database
2003-12-22 14:58 restoring database Lucas Lain <lainl@aconectarse.com>
2003-12-22 16:43 ` Re: restoring database Theodore Petrosky <tedpet5@yahoo.com>
@ 2003-12-22 17:53 ` scott.marlowe <scott.marlowe@ihs.com>
2003-12-23 10:18 ` Re: restoring database Markus Bertheau <twanger@bluetwanger.de>
0 siblings, 1 reply; 5+ messages in thread
From: scott.marlowe @ 2003-12-22 17:53 UTC (permalink / raw)
To: Theodore Petrosky <tedpet5@yahoo.com>; +Cc: Lucas Lain <lainl@aconectarse.com>; pgsql-sql
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 this
> method is inconvenient.... (to say the least).
>
> However it will work.
In the past I've used
'cat -n filename'|grep -4 database
to find the starting points of individual databases etc... and then used
split to break it into the exact right size pieces to do this.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: restoring database
2003-12-22 14:58 restoring database Lucas Lain <lainl@aconectarse.com>
2003-12-22 16:43 ` Re: restoring database Theodore Petrosky <tedpet5@yahoo.com>
2003-12-22 17:53 ` Re: restoring database scott.marlowe <scott.marlowe@ihs.com>
@ 2003-12-23 10:18 ` Markus Bertheau <twanger@bluetwanger.de>
0 siblings, 0 replies; 5+ messages in thread
From: Markus Bertheau @ 2003-12-23 10:18 UTC (permalink / raw)
To: scott.marlowe <scott.marlowe@ihs.com>; +Cc: Theodore Petrosky <tedpet5@yahoo.com>; Lucas Lain <lainl@aconectarse.com>; pgsql-sql
В Пнд, 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 about.
> >
> > Obviously, if the dump_all is a terabyte database this
> > method is inconvenient.... (to say the least).
> >
> > However it will work.
>
> In the past I've used
>
> 'cat -n filename'|grep -4 database
>
> to find the starting points of individual databases etc... and then used
> split to break it into the exact right size pieces to do this.
That sounds like something pg_dump / pg_dumpall should be able to do
itself, don't you think?
--
Markus Bertheau <twanger@bluetwanger.de>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-12-23 10:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-22 14:58 restoring database LAIN Lucas TECHTEL <llain@techtel.com.ar>
2003-12-22 14:58 restoring database Lucas Lain <lainl@aconectarse.com>
2003-12-22 16:43 ` Theodore Petrosky <tedpet5@yahoo.com>
2003-12-22 17:53 ` scott.marlowe <scott.marlowe@ihs.com>
2003-12-23 10:18 ` Markus Bertheau <twanger@bluetwanger.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox