Re: dumping strategy
От | Mitch Vincent |
---|---|
Тема | Re: dumping strategy |
Дата | |
Msg-id | 004e01c0e93a$9fded610$1251000a@Mitch обсуждение исходный текст |
Ответ на | dumping strategy (newsreader@mediaone.net) |
Ответы |
Re: dumping strategy
|
Список | pgsql-general |
Why wouldn't pg_dump work? You can do pg_dump -t <tablename> <databasename> to dump just a single table.... If pg_dump fails for some reason, I'd say the developers would like to know as I'm sure it's not supposed to :-) Good luck! -Mitch > I have many tables and don't want to > dump all of them. Of 30 tables > about two are really huge and I > actually don't mind losing those > tables and don't want to backup. > One of the reasons being that > I transfer the back up to another > host and wish to economize on > bandwidth. > > pg_dump command cannot handle. > Ideally what I would like to > dump all but a few tables. Currently > I am dumping all but a few > tables to a directory and > then make a tar ball and then > bzip2 and transport to a machine > of my choice. > > Can someone tell me a better > solution? > > Thanks > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-general по дате отправления: