Re: pg_dump in cycle
От | Najib Abi Fadel |
---|---|
Тема | Re: pg_dump in cycle |
Дата | |
Msg-id | 009001c49bd2$b643f180$f664a8c0@najib обсуждение исходный текст |
Ответ на | pg_dump in cycle (Ilia Chipitsine <ilia@paramon.ru>) |
Ответы |
Re: pg_dump in cycle
|
Список | pgsql-general |
U can use : select datname from pg_database; in order to get the list of databses HTH Najib. ----- Original Message ----- From: "Ilia Chipitsine" <ilia@paramon.ru> To: "Najib Abi Fadel" <nabifadel@usj.edu.lb> Sent: Thursday, September 16, 2004 10:41 AM Subject: Re: [GENERAL] pg_dump in cycle > > Use pg_dump instead of pg_dumpall > > > > example: > > pg_dump databaseName > databaseDumpFile > > > > if u have many databases, you can make a script that dumps each database in > > sure, I have many databases. > how can I write such script without explicitly specifying database names ? > I do not want to modify that script after I have added database. > > > it's own file .... > > > > > > > > ----- Original Message ----- > > From: "Ilia Chipitsine" <ilia@paramon.ru> > > To: <pgsql-general@postgresql.org> > > Sent: Thursday, September 16, 2004 8:08 AM > > Subject: [GENERAL] pg_dump in cycle > > > > > >> Dear Sirs, > >> > >> I want to dump all databases, but separately each database in its own > >> file, not all databases in one single file as pg_dumpall does. > >> > >> How can I implement that ? > >> > >> Cheers, > >> Ilia Chipitsine > >> > >> ---------------------------(end of broadcast)--------------------------- > >> TIP 4: Don't 'kill -9' the postmaster > >> > > > > >
В списке pgsql-general по дате отправления: