[GENERAL] copying a database without dumping it

2005-12-15 Thread Marc Brünink
Hi list, I know this was asked a lot of times on this mailing list. But actually no reply satisfied me :-) However: I've a running postgres database. It's about 6 GB big. Now I want to copy this database to another host. Clearly pg_dumpall comes to the mind. But there're 2 problems: 1. The n

Re: [GENERAL] copying a database without dumping it

2005-12-15 Thread Marc Brünink
On Donnerstag, Dez 15, 2005, at 12:11 Europe/Berlin, Tino Wildenhain wrote: Marc Brünink schrieb: Hi list, ... Now I'l try a custom dump. Perhaps this will suffice. But I guess it's impossible for a dump to be as fast as a cp. So if a cp would be possible I would favour it. O