Re: [ADMIN] easy way to copy all DBs and users on a server

2003-11-13 Thread scott.marlowe
On Wed, 12 Nov 2003, exciteworks hosting wrote: > Is there an easy way to copy all DBs and users on a server to another > server? > > I need to get an exact duplicate. pg_dump -h source_server|psql -h dest_server ---(end of broadcast)--- TIP 5:

Re: [ADMIN] easy way to copy all DBs and users on a server

2003-11-13 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (exciteworks hosting) transmitted: > Is there an easy way to copy all DBs and users on a server to another > server? > > I need to get an exact duplicate. How exact is "exact"? One notion of "exact" would involve stopping th

Re: [ADMIN] easy way to copy all DBs and users on a server

2003-11-12 Thread A.Bhuvaneswaran
On Thu, 2003-11-13 at 07:47, exciteworks hosting wrote: > Is there an easy way to copy all DBs and users on a server to another > server? pg_dumpall is a good partner. If i am correct, you can also copy the entire data directory, provided if both versions are same. regards, bhuvaneswaran sign

[ADMIN] easy way to copy all DBs and users on a server

2003-11-12 Thread exciteworks hosting
Is there an easy way to copy all DBs and users on a server to another server? I need to get an exact duplicate. Thanks in avance! --- Josh Trefethen Exciteworks, Inc http://exciteworks.com ---(end of broadcast)--- TIP 6: Have you searched our li