Thus spake The Hermit Hacker > all 77 databases got dump'd as the same database: Personally I never use pg_dumpall. It is easy to write a script to get the list of databases and use pg_dump to dump them individually. In fact I like dumping individual tables if I can. Mostly I like the ability to fix one table if there is a problem. Finding and fixing one 7 row table in a multi-gigabyte files really sucks. :-) -- D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
- [HACKERS] HOLD THE PRESSES!! ... pg_dump from v7.0.3 can... The Hermit Hacker
- [HACKERS] Re: HOLD THE PRESSES!! ... pg_dump from v... Joel Burton
- [HACKERS] Re: HOLD THE PRESSES!! ... pg_dump fr... The Hermit Hacker
- [HACKERS] Re: HOLD THE PRESSES!! ... pg_dum... The Hermit Hacker
- Re: [HACKERS] Re: HOLD THE PRESSES!! ..... Peter Eisentraut
- Re: [HACKERS] Re: HOLD THE PRESSES... The Hermit Hacker
- Re: [HACKERS] Re: HOLD THE PRESSES... Philip Warner
- Re: [HACKERS] Re: HOLD THE PRE... Peter Eisentraut
- Re: [HACKERS] Re: HOLD THE... Philip Warner
- Re: [HACKERS] Re: HOLD THE PRESSES... Tom Lane
- Re: [HACKERS] Re: HOLD THE PRESSES!! ... pg... D'Arcy J.M. Cain
- Re: [HACKERS] Re: HOLD THE PRESSES!! ..... Philip Warner
- Re: [HACKERS] Re: HOLD THE PRESSES!! ... pg_dum... Vince Vielhaber